APPS.CSTPCOIC dependencies on CST_ITEM_COST_DETAILS

Line 189: DELETE FROM CST_ITEM_COST_DETAILS CICD

185: );
186:
187: location := 2;
188:
189: DELETE FROM CST_ITEM_COST_DETAILS CICD
190: WHERE CICD.ORGANIZATION_ID = to_org_id
191: AND CICD.COST_TYPE_ID = to_cst_type_id
192: AND (
193: /* -- ALL ITEMS -- */

Line 224: FROM CST_ITEM_COST_DETAILS CIC2

220:
221: DELETE FROM CST_ITEM_COSTS CIC
222: WHERE EXISTS (
223: SELECT 'Item exists in from org'
224: FROM CST_ITEM_COST_DETAILS CIC2
225: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
226: AND CIC2.ORGANIZATION_ID = from_org_id
227: AND CIC2.COST_TYPE_ID = from_cst_type_id
228: )

Line 259: DELETE FROM CST_ITEM_COST_DETAILS CICD

255: /* following delete needs to change */
256:
257: location := 4;
258:
259: DELETE FROM CST_ITEM_COST_DETAILS CICD
260: WHERE EXISTS (
261: SELECT 'Item exists in from org'
262: FROM CST_ITEM_COST_DETAILS CIC2
263: WHERE CIC2.INVENTORY_ITEM_ID = CICD.INVENTORY_ITEM_ID

Line 262: FROM CST_ITEM_COST_DETAILS CIC2

258:
259: DELETE FROM CST_ITEM_COST_DETAILS CICD
260: WHERE EXISTS (
261: SELECT 'Item exists in from org'
262: FROM CST_ITEM_COST_DETAILS CIC2
263: WHERE CIC2.INVENTORY_ITEM_ID = CICD.INVENTORY_ITEM_ID
264: AND CIC2.ORGANIZATION_ID = from_org_id
265: AND CIC2.COST_TYPE_ID = from_cst_type_id
266: )

Line 773: * from CST_ITEM_COST_DETAILS

769: END IF;
770:
771: /*
772: * Copy over columns into CST_ITEM_CST_DTLS_INTERFACE
773: * from CST_ITEM_COST_DETAILS
774: *
775: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE
776: */
777:

Line 775: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE

771: /*
772: * Copy over columns into CST_ITEM_CST_DTLS_INTERFACE
773: * from CST_ITEM_COST_DETAILS
774: *
775: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE
776: */
777:
778: location := 6;
779:

Line 921: CST_ITEM_COST_DETAILS CICD

917: BOM_DEPARTMENTS BD,
918: CST_ACTIVITIES CA,
919: BOM_RESOURCES BR,
920: CST_COST_ELEMENTS CCE,
921: CST_ITEM_COST_DETAILS CICD
922: WHERE CICI.GROUP_ID = grp_id
923: AND CICD.INVENTORY_ITEM_ID = CICI.INVENTORY_ITEM_ID
924: AND CICD.ORGANIZATION_ID = from_org_id
925: AND CICD.COST_TYPE_ID = from_cst_type_id