DBA Data[Home] [Help]

APPS.ENG_BOM_PKG dependencies on BOM_STRUCTURES_B

Line 71: select bill_sequence_id from bom_structures_b

67: ATO_IN_KIT_EXCEPTION EXCEPTION;
68: ATO_IN_MODEL_EXCEPTION EXCEPTION;
69:
70: cursor all_bills(X_org_id number, X_eng_item_id number, X_designator_option number , X_alt_bom_designator varchar2) is
71: select bill_sequence_id from bom_structures_b
72: WHERE ORGANIZATION_ID = X_org_id
73: AND ASSEMBLY_ITEM_ID = X_eng_item_id
74: AND ((X_designator_option = 2 AND
75: ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 290: select bill_sequence_id from bom_structures_b

286:
287:
288: cursor all_bills(X_org_id number, X_eng_item_id number,
289: X_designator_option number, X_alt_bom_designator varchar2) is
290: select bill_sequence_id from bom_structures_b
291: WHERE ORGANIZATION_ID = X_org_id
292: AND ASSEMBLY_ITEM_ID = X_eng_item_id
293: AND ((X_designator_option = 2 AND
294: ALTERNATE_BOM_DESIGNATOR IS NULL)