eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPPLLC dependencies on CST_PAC_EXPLOSION_TEMP

Line 75: cst_pac_explosion_temp (

71: has been a completion/scrap/return for the item
72: ------------------------------------------------------------------------*/
73:
74: INSERT INTO
75: cst_pac_explosion_temp (
76: pac_period_id,
77: cost_group_id,
78: assembly_item_id,
79: component_item_id,

Line 91: FROM cst_pac_explosion_temp

87: 1000
88: FROM dual
89: WHERE NOT EXISTS (
90: SELECT 'exists'
91: FROM cst_pac_explosion_temp
92: WHERE assembly_item_id = -1
93: AND component_item_id = comp_rec.inventory_item_id
94: AND pac_period_id = i_pac_period_id
95: AND cost_group_id = i_cost_group_id);

Line 101: cst_pac_explosion_temp(

97: IF(NVL(comp_rec.flow_schedule,'N') <> 'Y') THEN /* not CFM */
98: IF (comp_rec.repetitive_line_id IS NULL) THEN /* discrete jobs */
99: IF (i_method = 1) THEN
100: INSERT INTO
101: cst_pac_explosion_temp(
102: pac_period_id,
103: cost_group_id,
104: assembly_item_id,
105: component_item_id,

Line 119: FROM cst_pac_explosion_temp

115: FROM wip_requirement_operations wro
116: WHERE wro.wip_entity_id = comp_rec.transaction_source_id
117: AND NOT EXISTS (
118: SELECT 'exists'
119: FROM cst_pac_explosion_temp
120: WHERE assembly_item_id = comp_rec.inventory_item_id
121: AND component_item_id = inventory_item_id
122: AND pac_period_id = i_pac_period_id
123: AND cost_group_id = i_cost_group_id);

Line 126: cst_pac_explosion_temp(

122: AND pac_period_id = i_pac_period_id
123: AND cost_group_id = i_cost_group_id);
124: ELSE /* i_method = 2 */
125: INSERT INTO
126: cst_pac_explosion_temp(
127: pac_period_id,
128: cost_group_id,
129: assembly_item_id,
130: component_item_id,

Line 148: FROM cst_pac_explosion_temp

144: AND transaction_date BETWEEN trunc(i_start_date)
145: AND (trunc(i_end_date) + 0.99999)
146: AND NOT EXISTS (
147: SELECT 'exists'
148: FROM cst_pac_explosion_temp
149: WHERE assembly_item_id = comp_rec.inventory_item_id
150: AND component_item_id = inventory_item_id
151: AND pac_period_id = i_pac_period_id
152: AND cost_group_id = i_cost_group_id)

Line 160: cst_pac_explosion_temp(

156: END IF;
157: ELSE /* repetitive schedules */
158: IF (i_method = 1) THEN
159: INSERT INTO
160: cst_pac_explosion_temp(
161: pac_period_id,
162: cost_group_id,
163: assembly_item_id,
164: component_item_id,

Line 181: FROM cst_pac_explosion_temp

177: AND mmta.repetitive_schedule_id = wro.repetitive_schedule_id
178: AND wro.wip_entity_id = comp_rec.transaction_source_id
179: AND NOT EXISTS (
180: SELECT 'exists'
181: FROM cst_pac_explosion_temp
182: WHERE assembly_item_id = comp_rec.inventory_item_id
183: AND component_item_id = inventory_item_id
184: AND pac_period_id = i_pac_period_id
185: AND cost_group_id = i_cost_group_id);

Line 188: cst_pac_explosion_temp(

184: AND pac_period_id = i_pac_period_id
185: AND cost_group_id = i_cost_group_id);
186: ELSE /* i_method = 2 */
187: INSERT INTO
188: cst_pac_explosion_temp(
189: pac_period_id,
190: cost_group_id,
191: assembly_item_id,
192: component_item_id,

Line 211: FROM cst_pac_explosion_temp

207: AND transaction_date BETWEEN trunc(i_start_date)
208: AND (trunc(i_end_date) + 0.99999)
209: AND NOT EXISTS (
210: SELECT 'exists'
211: FROM cst_pac_explosion_temp
212: WHERE assembly_item_id = comp_rec.inventory_item_id
213: AND component_item_id = inventory_item_id
214: AND pac_period_id = i_pac_period_id
215: AND cost_group_id = i_cost_group_id)

Line 227: cst_pac_explosion_temp(

223: -- time, effectivity dates changed so its difficult to get the bill
224: -- back in time
225: IF (i_method = 1) THEN
226: INSERT INTO
227: cst_pac_explosion_temp(
228: pac_period_id,
229: cost_group_id,
230: assembly_item_id,
231: component_item_id,

Line 249: FROM cst_pac_explosion_temp

245: AND (trunc(i_end_date) + 0.99999)
246: AND mmt.transaction_action_id in (1,27,33,34)
247: AND NOT EXISTS (
248: SELECT 'exists'
249: FROM cst_pac_explosion_temp
250: WHERE assembly_item_id = comp_rec.inventory_item_id
251: AND component_item_id = inventory_item_id
252: AND pac_period_id = i_pac_period_id
253: AND cost_group_id = i_cost_group_id);

Line 256: cst_pac_explosion_temp(

252: AND pac_period_id = i_pac_period_id
253: AND cost_group_id = i_cost_group_id);
254: ELSE /* i_method = 2 */
255: INSERT INTO
256: cst_pac_explosion_temp(
257: pac_period_id,
258: cost_group_id,
259: assembly_item_id,
260: component_item_id,

Line 278: FROM cst_pac_explosion_temp

274: AND (trunc(i_end_date) + 0.99999)
275: AND mmt.transaction_action_id in (1,27,33,34)
276: AND NOT EXISTS (
277: SELECT 'exists'
278: FROM cst_pac_explosion_temp
279: WHERE assembly_item_id = comp_rec.inventory_item_id
280: AND component_item_id = inventory_item_id
281: AND pac_period_id = i_pac_period_id
282: AND cost_group_id = i_cost_group_id)

Line 339: FROM cst_pac_explosion_temp

335: c_cost_group_id IN NUMBER)
336: IS
337: SELECT DISTINCT
338: component_item_id cii
339: FROM cst_pac_explosion_temp
340: WHERE pac_period_id = c_pac_period_id
341: AND cost_group_id = c_cost_group_id
342: AND deleted = 'N';
343:

Line 359: FROM cst_pac_explosion_temp cpet,

355: msik2.inventory_item_id component_item_id,
356: msik2.concatenated_segments component_item,
357: we.wip_entity_id wip_entity_id,
358: we.wip_entity_name wip_entity
359: FROM cst_pac_explosion_temp cpet,
360: mtl_material_transactions mmt1,
361: mtl_material_transactions mmt2,
362: mtl_system_items_kfv msik1,
363: mtl_system_items_kfv msik2,

Line 413: l_cii cst_pac_explosion_temp.component_item_id%TYPE;

409: l_iteration NUMBER DEFAULT 0;
410: l_level_code NUMBER DEFAULT 1001;
411: l_update_flag BOOLEAN DEFAULT FALSE;
412: l_Processed_all_rows BOOLEAN DEFAULT FALSE;
413: l_cii cst_pac_explosion_temp.component_item_id%TYPE;
414: l_looping_transaction C_looping_transactions%ROWTYPE;
415: l_stmt_num NUMBER;
416: LOOP_ERROR EXCEPTION;
417: LOOP_WARNING EXCEPTION;

Line 429: UPDATE cst_pac_explosion_temp

425: Marking for deletion rows which have component item same as the
426: assembly item. This is for non standard jobs
427: ------------------------------------------------------------------------*/
428:
429: UPDATE cst_pac_explosion_temp
430: SET deleted = 'Y',
431: loop_count = l_iteration
432: WHERE component_item_id = assembly_item_id
433: AND deleted = 'N'

Line 459: UPDATE /+ index(cet1 CST_PAC_EXPLOSION_TEMP_N1) /

455: previous iterations since components can occur at different levels
456: --------------------------------------------------------------------*/
457: l_stmt_num := 40;
458:
459: UPDATE /*+ index(cet1 CST_PAC_EXPLOSION_TEMP_N1) */
460: cst_pac_explosion_temp cet1
461: SET deleted = 'Y',
462: loop_count = l_iteration
463: WHERE component_item_id = l_cii

Line 460: cst_pac_explosion_temp cet1

456: --------------------------------------------------------------------*/
457: l_stmt_num := 40;
458:
459: UPDATE /*+ index(cet1 CST_PAC_EXPLOSION_TEMP_N1) */
460: cst_pac_explosion_temp cet1
461: SET deleted = 'Y',
462: loop_count = l_iteration
463: WHERE component_item_id = l_cii
464: AND deleted = 'N'

Line 469: FROM cst_pac_explosion_temp cet2

465: AND pac_period_id = i_pac_period_id
466: AND cost_group_id = i_cost_group_id
467: AND NOT EXISTS (
468: SELECT 'exists as a parent'
469: FROM cst_pac_explosion_temp cet2
470: WHERE cet2.assembly_item_id = l_cii
471: AND pac_period_id = i_pac_period_id
472: AND cost_group_id = i_cost_group_id
473: AND loop_count >= l_iteration);

Line 513: if "undeleted" rows still exist in cst_pac_explosion_temp and no rows

509:
510: l_stmt_num := 60;
511:
512: /*------------------------------------------------------------------------
513: if "undeleted" rows still exist in cst_pac_explosion_temp and no rows
514: were updated, then this implies there is a LOOP.
515: ----------------------------------------------------------------------*/
516:
517: IF (NOT l_update_flag AND l_counter > 0) THEN

Line 541: SELECT component_item_id FROM cst_pac_explosion_temp cpet

537: WHERE low_level_code = 1000
538: AND cost_group_id = i_cost_group_id
539: AND pac_period_id = i_pac_period_id
540: AND NOT EXISTS (
541: SELECT component_item_id FROM cst_pac_explosion_temp cpet
542: WHERE assembly_item_id = -1
543: AND component_item_id = cpllc.inventory_item_id
544: AND cost_group_id = i_cost_group_id
545: AND pac_period_id = i_pac_period_id);

Line 554: cst_pac_explosion_temp

550: cst_pac_low_level_codes
551: WHERE cost_group_id = i_cost_group_id
552: AND pac_period_id = i_pac_period_id;
553: DELETE FROM
554: cst_pac_explosion_temp
555: WHERE cost_group_id = i_cost_group_id
556: AND pac_period_id = i_pac_period_id;
557:
558: o_err_num := -999;