1658: and (si.organization_id = ri2.organization_id or
1659: ri2.organization_id is NULL)
1660: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1661:
1662: table_name := 'CST_ITEM_COSTS_INTERFACE';
1663: delete from CST_ITEM_COSTS_INTERFACE ci
1664: where ci.rowid in ( select ci2.rowid
1665: from CST_ITEM_COSTS_INTERFACE ci2,
1666: MTL_SYSTEM_ITEMS_INTERFACE si
1659: ri2.organization_id is NULL)
1660: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1661:
1662: table_name := 'CST_ITEM_COSTS_INTERFACE';
1663: delete from CST_ITEM_COSTS_INTERFACE ci
1664: where ci.rowid in ( select ci2.rowid
1665: from CST_ITEM_COSTS_INTERFACE ci2,
1666: MTL_SYSTEM_ITEMS_INTERFACE si
1667: where si.inventory_item_id = ci2.inventory_item_id
1661:
1662: table_name := 'CST_ITEM_COSTS_INTERFACE';
1663: delete from CST_ITEM_COSTS_INTERFACE ci
1664: where ci.rowid in ( select ci2.rowid
1665: from CST_ITEM_COSTS_INTERFACE ci2,
1666: MTL_SYSTEM_ITEMS_INTERFACE si
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'))));