APPS.CSTPCINT dependencies on CST_ITEM_CST_DTLS_INTERFACE

Line 65: * Resolve all ORGANIZATION_CODE in CST_ITEM_CST_DTLS_INTERFACE.

61: )
62: WHERE CICI.GROUP_ID = i_group_id;
63:
64: /*
65: * Resolve all ORGANIZATION_CODE in CST_ITEM_CST_DTLS_INTERFACE.
66: * This must be done first, before the following updates.
67: *
68: */
69: location := 3;

Line 71: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI

67: *
68: */
69: location := 3;
70:
71: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI
72: SET
73: CICDI.ORGANIZATION_ID = (
74: SELECT MP.ORGANIZATION_ID
75: FROM MTL_PARAMETERS MP

Line 83: * in CST_ITEM_CST_DTLS_INTERFACE.

79:
80: /*
81: * Resolve all INVENTORY_ITEM_ID, COST_TYPE_ID, DEPARTMENT_ID,
82: * ACTIVITY_ID, RESOURCE_ID, BASIS_RESOURCE_ID, and COST_ELEMENT_ID
83: * in CST_ITEM_CST_DTLS_INTERFACE.
84: *
85: * This must be done after the ORGANIZATION_ID is resolved.
86: */
87: location := 4;

Line 96: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI

92: * and there are no good indices to use. Therefore the performance
93: * of the following update statement is BAD.
94: */
95:
96: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI
97: SET
98: INVENTORY_ITEM_ID = (
99: SELECT MIF.ITEM_ID
100: FROM MTL_ITEM_FLEXFIELDS MIF

Line 107: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI

103: )
104: WHERE CICDI.GROUP_ID = i_group_id
105: AND CICDI.INVENTORY_ITEM_ID IS NULL;
106:
107: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI
108: SET
109: COST_TYPE_ID = (
110: SELECT CCT.COST_TYPE_ID
111: FROM CST_COST_TYPES CCT

Line 185: update cst_item_cst_dtls_interface

181: and mp.organization_id = wsm.organization_id
182: and UPPER(mp.wsm_enabled_flag) = 'Y';
183:
184: if (l_to_wsm_flag <= 0) then
185: update cst_item_cst_dtls_interface
186: set yielded_cost = null
187: where organization_id = i_to_org_id
188: and group_id = i_group_id
189: and yielded_cost is not null;

Line 210: FROM cst_item_cst_dtls_interface CICDI

206: DECODE(cost_element_id,
207: 3,1,
208: 5,5),
209: i_group_id
210: FROM cst_item_cst_dtls_interface CICDI
211: WHERE CICDI.group_id = i_group_id
212: AND CICDI.resource_code IS NOT NULL
213: AND CICDI.resource_id IS NULL
214: UNION

Line 220: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI

216: INVENTORY_ITEM,
217: ACTIVITY,
218: 2,
219: i_group_id
220: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI
221: WHERE CICDI.GROUP_ID = i_group_id
222: AND CICDI.ACTIVITY_ID IS NULL
223: AND CICDI.ACTIVITY IS NOT NULL;
224:

Line 237: from cst_item_cst_dtls_interface cicdi

233: select inventory_item,
234: resource_code,
235: 6,
236: i_group_id
237: from cst_item_cst_dtls_interface cicdi
238: where cicdi.group_id = i_group_id
239: /* TL Material Overhead needs to have Subelement specified */
240: and cicdi.resource_code is null
241: and (cicdi.cost_element_id = 2 and cicdi.level_type = 1);

Line 256: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI

252: INVENTORY_ITEM,
253: DEPARTMENT,
254: 3,
255: i_group_id
256: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI
257: WHERE CICDI.GROUP_ID = i_group_id
258: AND CICDI.DEPARTMENT_ID IS NULL
259: AND CICDI.DEPARTMENT IS NOT NULL
260: UNION

Line 266: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI

262: INVENTORY_ITEM,
263: BASIS_RESOURCE_CODE,
264: 4,
265: i_group_id
266: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI
267: WHERE CICDI.GROUP_ID = i_group_id
268: AND CICDI.BASIS_RESOURCE_ID IS NULL
269: AND CICDI.BASIS_RESOURCE_CODE IS NOT NULL;
270:

Line 284: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI

280: INVENTORY_ITEM,
281: COST_ELEMENT,
282: 5,
283: i_group_id
284: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI
285: WHERE CICDI.GROUP_ID = i_group_id
286: AND CICDI.COST_ELEMENT_ID IS NULL
287: AND CICDI.COST_ELEMENT IS NOT NULL;
288:

Line 539: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI

535: ATTRIBUTE14,
536: ATTRIBUTE15,
537: --bug5839929
538: YIELDED_COST
539: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI
540: WHERE CICDI.GROUP_ID = i_group_id;
541:
542:
543: RETURN( 0 ); /* No Error */

Line 569: DELETE FROM CST_ITEM_CST_DTLS_INTERFACE CICDI

565: WHERE CICI.GROUP_ID = i_group_id;
566:
567: location := 1;
568:
569: DELETE FROM CST_ITEM_CST_DTLS_INTERFACE CICDI
570: WHERE CICDI.GROUP_ID = i_group_id;
571:
572: RETURN( 0 ); /* No Error */
573: