BOM Bill of Material Listing (1)

Description
Categories: Concurrent Program, Manufacturing
Application: Bills of Material
Source: Bill of Material Listing
Short Name: BOMRASSY
select  item1.SEGMENT1 assembly_flex_values , item1 . description assy_desc , DECODE ( b . assembly_type , 1 , 'No' , 'Yes' ) eng_bill_flag ,  mcat.SEGMENT1||'
'||mcat.SEGMENT2 catg_flex_values , b . alternate_bom_designator alternate , b . organization_id organization_id ,  item2.SEGMENT1 common_flex_values , item2 . description common_desc , item2 . organization_id common_org_id , item1 . inventory_item_id item_id , b . assembly_item_id assy_id , NVL ( b . common_assembly_item_id , b . assembly_item_id ) common_assy_id , b . common_organization_id from bom_bill_of_materials b , mtl_item_categories micat , mtl_system_items item1 , mtl_system_items item2 , mtl_categories mcat , bom_lists blist   where blist.sequence_id = : P_SEQUENCE_ID and blist.organization_id = b.organization_id and b.assembly_item_id = item1.inventory_item_id and b.organization_id = item1.organization_id and item1.bom_enabled_flag = 'Y' and NVL ( b.common_assembly_item_id , b.assembly_item_id ) = item2.inventory_item_id and NVL ( b.common_organization_id , b.organization_id ) = item2.organization_id and ( ( b.assembly_type = 1 and : P_BOM_OR_ENG = 'BOM' ) or ( : P_BOM_OR_ENG = 'ENG' ) ) and item1.SEGMENT1 BETWEEN '00' AND 'zzz' and : P_CATG_SET_ID = micat.category_set_id and b.assembly_item_id = micat.inventory_item_id and b.organization_id = micat.organization_id and mcat.category_id = micat.category_id and 1 = 1 and ( ( : P_ALT_OPTION = 1 ) or ( : P_ALT_OPTION = 2 and b.alternate_bom_designator is NULL ) or ( : P_ALT_OPTION = 3 and b.alternate_bom_designator = : P_ALTERNATE ) ) and ( ( : P_COMMON_ORG is NULL ) or ( : P_COMMON_ITEM_ID is NULL and : P_COMMON_ORG = b.common_organization_id ) or ( : P_COMMON_ORG = b.common_organization_id and : P_COMMON_ITEM_ID = b.common_assembly_item_id ) ) ORDER BY 1 ASC,13 ASC , item1.SEGMENT1 , NVL ( b.alternate_bom_designator , ' ' ) , : P_ORG_CODE
Parameter Name SQL text Validation
Trace Flag
 
Eng Bill Flag
 
Category Structure
 
Number
BOM_SRS_ORG_ID
 
Number
Common Bill
 
Common Organization
 
LOV Oracle
Alternate
 
LOV Oracle
Alternate Selection
 
LOV Oracle
To
 
Categories From
 
Category Set
 
LOV Oracle
To
 
Items From
 
Ask a question