DBA Data[Home] [Help]

APPS.INVPPRCI dependencies on MTL_SYSTEM_ITEMS_B

Line 54: insert into MTL_SYSTEM_ITEMS_B

50: into the inventory system master table */
51:
52: table_name := 'MTL_SYSTEM_ITEMS';
53:
54: insert into MTL_SYSTEM_ITEMS_B
55: (INVENTORY_ITEM_ID,
56: ORGANIZATION_ID,
57: LAST_UPDATE_DATE,
58: LAST_UPDATED_BY,

Line 498: MTL_SYSTEM_ITEMS_B M, /* Model */

494: SYSDATE
495: from
496: MTL_PARAMETERS MP1,
497: MTL_PARAMETERS MP2,
498: MTL_SYSTEM_ITEMS_B M, /* Model */
499: MTL_SYSTEM_ITEMS_INTERFACE I
500: where M.ORGANIZATION_ID = MP1.ORGANIZATION_ID
501: and I.COPY_ITEM_ID = M.INVENTORY_ITEM_ID
502: and I.SET_ID = TO_CHAR(to_number(USERENV('SESSIONID')))

Line 536: MTL_SYSTEM_ITEMS_B M, /* Model */

532: login_id /* last_update_login */
533: from
534: MTL_PARAMETERS MP1,
535: MTL_PARAMETERS MP2,
536: MTL_SYSTEM_ITEMS_B M, /* Model */
537: MTL_SYSTEM_ITEMS_INTERFACE I
538: , FND_LANGUAGES L
539: where M.ORGANIZATION_ID = MP1.ORGANIZATION_ID
540: and I.COPY_ITEM_ID = M.INVENTORY_ITEM_ID

Line 623: from MTL_SYSTEM_ITEMS_B SI,

619: prg_appid,
620: prg_id,
621: SYSDATE,
622: req_id
623: from MTL_SYSTEM_ITEMS_B SI,
624: MTL_PARAMETERS MP1,
625: MTL_PARAMETERS MP2,
626: MTL_SYSTEM_ITEMS_INTERFACE R
627: where R.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))