APPS.CSTPCOIC dependencies on CST_ITEM_COST_DETAILS

Line 177: DELETE FROM CST_ITEM_COST_DETAILS CICD

173: );
174:
175: location := 2;
176:
177: DELETE FROM CST_ITEM_COST_DETAILS CICD
178: WHERE CICD.ORGANIZATION_ID = to_org_id
179: AND CICD.COST_TYPE_ID = to_cst_type_id
180: AND (
181: /* -- ALL ITEMS -- */

Line 212: FROM CST_ITEM_COST_DETAILS CIC2

208:
209: DELETE FROM CST_ITEM_COSTS CIC
210: WHERE EXISTS (
211: SELECT 'Item exists in from org'
212: FROM CST_ITEM_COST_DETAILS CIC2
213: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
214: AND CIC2.ORGANIZATION_ID = from_org_id
215: AND CIC2.COST_TYPE_ID = from_cst_type_id
216: )

Line 247: DELETE FROM CST_ITEM_COST_DETAILS CICD

243: /* following delete needs to change */
244:
245: location := 4;
246:
247: DELETE FROM CST_ITEM_COST_DETAILS CICD
248: WHERE EXISTS (
249: SELECT 'Item exists in from org'
250: FROM CST_ITEM_COST_DETAILS CIC2
251: WHERE CIC2.INVENTORY_ITEM_ID = CICD.INVENTORY_ITEM_ID

Line 250: FROM CST_ITEM_COST_DETAILS CIC2

246:
247: DELETE FROM CST_ITEM_COST_DETAILS CICD
248: WHERE EXISTS (
249: SELECT 'Item exists in from org'
250: FROM CST_ITEM_COST_DETAILS CIC2
251: WHERE CIC2.INVENTORY_ITEM_ID = CICD.INVENTORY_ITEM_ID
252: AND CIC2.ORGANIZATION_ID = from_org_id
253: AND CIC2.COST_TYPE_ID = from_cst_type_id
254: )

Line 761: * from CST_ITEM_COST_DETAILS

757: END IF;
758:
759: /*
760: * Copy over columns into CST_ITEM_CST_DTLS_INTERFACE
761: * from CST_ITEM_COST_DETAILS
762: *
763: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE
764: */
765:

Line 763: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE

759: /*
760: * Copy over columns into CST_ITEM_CST_DTLS_INTERFACE
761: * from CST_ITEM_COST_DETAILS
762: *
763: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE
764: */
765:
766: location := 6;
767:

Line 909: CST_ITEM_COST_DETAILS CICD

905: BOM_DEPARTMENTS BD,
906: CST_ACTIVITIES CA,
907: BOM_RESOURCES BR,
908: CST_COST_ELEMENTS CCE,
909: CST_ITEM_COST_DETAILS CICD
910: WHERE CICI.GROUP_ID = grp_id
911: AND CICD.INVENTORY_ITEM_ID = CICI.INVENTORY_ITEM_ID
912: AND CICD.ORGANIZATION_ID = from_org_id
913: AND CICD.COST_TYPE_ID = from_cst_type_id