DBA Data[Home] [Help]

APPS.INVPPRCI dependencies on MTL_DESCR_ELEMENT_VALUES

Line 1004: table_name := 'MTL_DESCR_ELEMENT_VALUES';

1000:
1001: /* Copy the item descriptive element values into the regular
1002: product table. */
1003:
1004: table_name := 'MTL_DESCR_ELEMENT_VALUES';
1005: insert into MTL_DESCR_ELEMENT_VALUES
1006: (INVENTORY_ITEM_ID,
1007: ELEMENT_NAME,
1008: LAST_UPDATE_DATE,

Line 1005: insert into MTL_DESCR_ELEMENT_VALUES

1001: /* Copy the item descriptive element values into the regular
1002: product table. */
1003:
1004: table_name := 'MTL_DESCR_ELEMENT_VALUES';
1005: insert into MTL_DESCR_ELEMENT_VALUES
1006: (INVENTORY_ITEM_ID,
1007: ELEMENT_NAME,
1008: LAST_UPDATE_DATE,
1009: LAST_UPDATED_BY,

Line 1035: from MTL_DESCR_ELEMENT_VALUES M, /* Model's desc elem values */

1031: prg_id, /* PROGRAM_ID */
1032: SYSDATE, /* PROGRAM_UPDATE_DATE */
1033: req_id, /* REQUEST_ID */
1034: NVL(V.ELEMENT_SEQUENCE,M.ELEMENT_SEQUENCE)
1035: from MTL_DESCR_ELEMENT_VALUES M, /* Model's desc elem values */
1036: MTL_DESC_ELEM_VAL_INTERFACE V,
1037: MTL_SYSTEM_ITEMS_INTERFACE SI
1038: where V.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID
1039: and SI.SET_ID = TO_CHAR(to_number(USERENV('SESSIONID')))