APPS.EGO_PUBLICATION_PKG dependencies on BOM_COMPONENTS_B

Line 1281: FROM bom_components_b

1277: WHERE bill_sequence_id = p_structure_id ;
1278:
1279: IF (p_component_id is not null) THEN
1280: SELECT component_item_id INTO l_comp_item_id
1281: FROM bom_components_b
1282: WHERE bill_sequence_id = p_structure_id
1283: AND component_sequence_id = p_component_id;
1284: END IF;
1285:

Line 1321: FROM bom_components_b c

1317: xmlelement("EndDateTime", c.disable_date)
1318: )
1319: )
1320: )
1321: FROM bom_components_b c
1322: where c.component_sequence_id = p_component_id
1323: )
1324: )))
1325: INTO x_doc

Line 1370: FROM bom_components_b c

1366: )
1367: )
1368: )
1369: )
1370: FROM bom_components_b c
1371: where c.bill_sequence_id = s.common_bill_sequence_id
1372: )
1373: )))
1374: INTO x_doc