DBA Data[Home] [Help]

APPS.BOM_BOM_COMPONENT_UTIL dependencies on BOM_STRUCTURE_TYPES_B

Line 1641: FROM BOM_STRUCTURE_TYPES_B STRUCT_TYPE,

1637: l_Structure_Type_Name,
1638: l_Assembly_Item_Id,
1639: l_Organization_Id,
1640: l_Structure_Name
1641: FROM BOM_STRUCTURE_TYPES_B STRUCT_TYPE,
1642: BOM_STRUCTURES_B BOM_STRUCT
1643: -- Added the below NVL condition for bug 14202819
1644: WHERE NVL(BOM_STRUCT.STRUCTURE_TYPE_ID, 1) = STRUCT_TYPE.STRUCTURE_TYPE_ID
1645: AND BOM_STRUCT.BILL_SEQUENCE_ID = l_Rev_Comp_Unexp_Rec.BILL_SEQUENCE_ID;