DBA Data[Home] [Help]

APPS.ENG_BOM_PKG dependencies on BOM_INVENTORY_COMPONENTS_S

Line 300: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,

296: BOM_T.ATTRIBUTE13,
297: BOM_T.ATTRIBUTE14,
298: BOM_T.ATTRIBUTE15,
299: 1,
300: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
301: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),
302: BOM_T.REQUEST_ID,
303: BOM_T.PROGRAM_APPLICATION_ID,
304: BOM_T.PROGRAM_ID,

Line 301: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),

297: BOM_T.ATTRIBUTE14,
298: BOM_T.ATTRIBUTE15,
299: 1,
300: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
301: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),
302: BOM_T.REQUEST_ID,
303: BOM_T.PROGRAM_APPLICATION_ID,
304: BOM_T.PROGRAM_ID,
305: BOM_T.PROGRAM_UPDATE_DATE,

Line 309: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),

305: BOM_T.PROGRAM_UPDATE_DATE,
306: BOM_T.COMMON_ORGANIZATION_ID,
307: BOM_T.NEXT_EXPLODE_DATE,
308: BOM_T.EFFECTIVITY_CONTROL,
309: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),
310: X_mfg_item_id,
311: ORGANIZATION_ID
312: FROM BOM_BILL_OF_MATERIALS BOM_T
313: WHERE ORGANIZATION_ID = X_org_id