DBA Data[Home] [Help]

APPS.INVPPRCI dependencies on CST_ITEM_COSTS_INTERFACE

Line 1662: table_name := 'CST_ITEM_COSTS_INTERFACE';

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

Line 1663: delete from CST_ITEM_COSTS_INTERFACE ci

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

Line 1665: from CST_ITEM_COSTS_INTERFACE ci2,

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