DBA Data[Home] [Help]

APPS.INVPPRCI dependencies on CST_ITEM_CST_DTLS_INTERFACE

Line 1671: table_name := 'CST_ITEM_CST_DTLS_INTERFACE';

1667: where si.inventory_item_id = ci2.inventory_item_id
1668: and si.organization_id = ci2.organization_id
1669: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1670:
1671: table_name := 'CST_ITEM_CST_DTLS_INTERFACE';
1672: delete from CST_ITEM_CST_DTLS_INTERFACE ci
1673: where ci.rowid in ( select ci2.rowid
1674: from CST_ITEM_CST_DTLS_INTERFACE ci2,
1675: MTL_SYSTEM_ITEMS_INTERFACE si

Line 1672: delete from CST_ITEM_CST_DTLS_INTERFACE ci

1668: and si.organization_id = ci2.organization_id
1669: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1670:
1671: table_name := 'CST_ITEM_CST_DTLS_INTERFACE';
1672: delete from CST_ITEM_CST_DTLS_INTERFACE ci
1673: where ci.rowid in ( select ci2.rowid
1674: from CST_ITEM_CST_DTLS_INTERFACE ci2,
1675: MTL_SYSTEM_ITEMS_INTERFACE si
1676: where si.inventory_item_id = ci2.inventory_item_id

Line 1674: from CST_ITEM_CST_DTLS_INTERFACE ci2,

1670:
1671: table_name := 'CST_ITEM_CST_DTLS_INTERFACE';
1672: delete from CST_ITEM_CST_DTLS_INTERFACE ci
1673: where ci.rowid in ( select ci2.rowid
1674: from CST_ITEM_CST_DTLS_INTERFACE ci2,
1675: MTL_SYSTEM_ITEMS_INTERFACE si
1676: where si.inventory_item_id = ci2.inventory_item_id
1677: and si.organization_id = ci2.organization_id
1678: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));