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
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
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'))));