DBA Data[Home] [Help]

APPS.EGO_PUBLICATION_PKG dependencies on BOM_STRUCTURES_B

Line 1276: FROM bom_structures_b

1272: BEGIN
1273: -- TBD : debug :print input vars here
1274:
1275: SELECT assembly_item_id, organization_id INTO l_assly_item_id, l_assly_item_org_id
1276: FROM bom_structures_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

Line 1326: FROM bom_structures_b s

1322: where c.component_sequence_id = p_component_id
1323: )
1324: )))
1325: INTO x_doc
1326: FROM bom_structures_b s
1327: WHERE s.bill_sequence_id = p_structure_id;
1328: ELSE
1329: BEGIN
1330: IF ((p_get_first_level_comps IS NULL) OR (p_get_first_level_comps = 'N')) THEN

Line 1345: FROM bom_structures_b s

1341: )
1342: )
1343: )
1344: INTO x_doc
1345: FROM bom_structures_b s
1346: WHERE s.bill_sequence_id = p_structure_id;
1347: END;
1348: ELSIF (p_get_first_level_comps = 'Y') THEN
1349: BEGIN

Line 1375: FROM bom_structures_b s

1371: where c.bill_sequence_id = s.common_bill_sequence_id
1372: )
1373: )))
1374: INTO x_doc
1375: FROM bom_structures_b s
1376: WHERE s.bill_sequence_id = p_structure_id;
1377: END;
1378: END IF;
1379: END;