APPS.INVPPRCI dependencies on MTL_DESC_ELEM_VAL_INTERFACE

Line 1036: MTL_DESC_ELEM_VAL_INTERFACE V,

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')))
1040: and M.INVENTORY_ITEM_ID = SI.COPY_ITEM_ID

Line 1608: table_name := 'MTL_DESC_ELEM_VAL_INTERFACE';

1604: and cri.cross_reference is not NULL
1605: and org_independent_flag is not NULL )
1606: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1607:
1608: table_name := 'MTL_DESC_ELEM_VAL_INTERFACE';
1609: delete from MTL_DESC_ELEM_VAL_INTERFACE di
1610: where di.rowid in ( select di2.rowid
1611: from MTL_DESC_ELEM_VAL_INTERFACE di2,
1612: MTL_SYSTEM_ITEMS_INTERFACE si

Line 1609: delete from MTL_DESC_ELEM_VAL_INTERFACE di

1605: and org_independent_flag is not NULL )
1606: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1607:
1608: table_name := 'MTL_DESC_ELEM_VAL_INTERFACE';
1609: delete from MTL_DESC_ELEM_VAL_INTERFACE di
1610: where di.rowid in ( select di2.rowid
1611: from MTL_DESC_ELEM_VAL_INTERFACE di2,
1612: MTL_SYSTEM_ITEMS_INTERFACE si
1613: where si.inventory_item_id = di2.inventory_item_id

Line 1611: from MTL_DESC_ELEM_VAL_INTERFACE di2,

1607:
1608: table_name := 'MTL_DESC_ELEM_VAL_INTERFACE';
1609: delete from MTL_DESC_ELEM_VAL_INTERFACE di
1610: where di.rowid in ( select di2.rowid
1611: from MTL_DESC_ELEM_VAL_INTERFACE di2,
1612: MTL_SYSTEM_ITEMS_INTERFACE si
1613: where si.inventory_item_id = di2.inventory_item_id
1614: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1615: