APPS.BOMPLDCI dependencies on MTL_SYSTEM_ITEMS_S

Line 276: select MTL_SYSTEM_ITEMS_S.NEXTVAL,

272: ITEM_TYPE,
273: CUSTOMER_ORDER_ENABLED_FLAG,
274: INTERNAL_ORDER_ENABLED_FLAG
275: )
276: select MTL_SYSTEM_ITEMS_S.NEXTVAL,
277: D.ORGANIZATION_ID,
278: SYSDATE, /* LAST_UPDATE_DATE */
279: 1, /* LAST_UPDATED_BY */
280: SYSDATE, /* CREATION_DATE */

Line 517: MTL_SYSTEM_ITEMS S,

513: l_item_type,
514: 'N',
515: 'N'
516: from MTL_DEMAND D,
517: MTL_SYSTEM_ITEMS S,
518: BOM_PARAMETERS P,
519: MTL_SALES_ORDERS L,
520: SO_LINES_ALL SL,
521: FND_ID_FLEX_SEGMENTS FS,

Line 594: dupl_total_stmt := dupl_total_stmt || ' ' || 'and exists((select ''exists'' from mtl_system_items S2 where S2.inventory_item_id <> I.inventory_item_id';

590: stmt_num := 24;
591:
592: dupl_total_stmt := 'select I.inventory_item_id,I.organization_id from mtl_system_items_interface I where I.SET_ID = TO_CHAR(USERENV(''SESSIONID'')) and I.organization_id = :org_buf';
593:
594: dupl_total_stmt := dupl_total_stmt || ' ' || 'and exists((select ''exists'' from mtl_system_items S2 where S2.inventory_item_id <> I.inventory_item_id';
595:
596: ind := 0;
597: stmt_num := 25;
598: for ind in 1..20 loop

Line 998: MTL_SYSTEM_ITEMS S,

994: L.SEGMENT1|| ci_del || D.USER_LINE_NUM || ci_del || TO_CHAR(hold_next_seq),
995: L.SEGMENT1|| ci_del || D.USER_LINE_NUM ||ci_del|| D.USER_DELIVERY || ci_del ||
996: TO_CHAR(hold_next_seq)), S.SEGMENT20),S.SEGMENT20)
997: from MTL_SYSTEM_ITEMS_INTERFACE I2,
998: MTL_SYSTEM_ITEMS S,
999: BOM_PARAMETERS P,
1000: MTL_SALES_ORDERS L,
1001: MTL_DEMAND D,
1002: FND_ID_FLEX_SEGMENTS FS,