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.

[Home] [Help]

APPS.CSTPPWAS dependencies on MTL_PAC_TXN_COST_DETAILS

Line 144: INTO mtl_pac_txn_cost_details

140:
141: INSERT ALL
142: WHEN pp_pl_material_out <> 0 THEN
143: -- Previous Level and Material cost element
144: INTO mtl_pac_txn_cost_details
145: (pac_period_id,
146: cost_group_id,
147: cost_type_id ,
148: inventory_item_id,

Line 183: INTO mtl_pac_txn_cost_details

179: SYSDATE,
180: p_login)
181: -- Previous Level and Material Overhead cost element
182: WHEN pp_pl_material_overhead_out <> 0 THEN
183: INTO mtl_pac_txn_cost_details
184: (pac_period_id,
185: cost_group_id,
186: cost_type_id ,
187: inventory_item_id,

Line 222: INTO mtl_pac_txn_cost_details

218: SYSDATE,
219: p_login)
220: -- Previous Level and Resource cost element
221: WHEN pp_pl_resource_out <> 0 THEN
222: INTO mtl_pac_txn_cost_details
223: (pac_period_id,
224: cost_group_id,
225: cost_type_id ,
226: inventory_item_id,

Line 261: INTO mtl_pac_txn_cost_details

257: SYSDATE,
258: p_login)
259: -- Previous Level and Outsideprocessing cost element
260: WHEN pp_pl_outside_processing_out <> 0 THEN
261: INTO mtl_pac_txn_cost_details
262: (pac_period_id,
263: cost_group_id,
264: cost_type_id ,
265: inventory_item_id,

Line 300: INTO mtl_pac_txn_cost_details

296: SYSDATE,
297: p_login)
298: -- Previous Level and Overhead cost element
299: WHEN pp_pl_overhead_out <> 0 THEN
300: INTO mtl_pac_txn_cost_details
301: (pac_period_id,
302: cost_group_id,
303: cost_type_id ,
304: inventory_item_id,

Line 339: INTO mtl_pac_txn_cost_details

335: SYSDATE,
336: p_login)
337: -- This Level and Resource cost element
338: WHEN pp_tl_resource_out <> 0 THEN
339: INTO mtl_pac_txn_cost_details
340: (pac_period_id,
341: cost_group_id,
342: cost_type_id ,
343: inventory_item_id,

Line 378: INTO mtl_pac_txn_cost_details

374: SYSDATE,
375: p_login)
376: -- This Level and Overhead cost element
377: WHEN pp_tl_overhead_out <> 0 THEN
378: INTO mtl_pac_txn_cost_details
379: (pac_period_id,
380: cost_group_id,
381: cost_type_id ,
382: inventory_item_id,

Line 417: INTO mtl_pac_txn_cost_details

413: SYSDATE,
414: p_login)
415: -- This Level and Outsideprocessing cost element
416: WHEN pp_tl_outside_processing_out <> 0 THEN
417: INTO mtl_pac_txn_cost_details
418: (pac_period_id,
419: cost_group_id,
420: cost_type_id ,
421: inventory_item_id,

Line 458: INTO mtl_pac_txn_cost_details

454: -- Create 0 TL Material instead of 0 PL Material when there is no non-zero cost details
455: WHEN (pp_pl_material_out = 0 AND pp_pl_material_overhead_out = 0 AND pp_pl_resource_out = 0 AND
456: pp_pl_outside_processing_out = 0 AND pp_pl_overhead_out = 0 AND pp_tl_resource_out = 0 AND
457: pp_tl_outside_processing_out = 0 AND pp_tl_overhead_out = 0) THEN
458: INTO mtl_pac_txn_cost_details
459: (pac_period_id,
460: cost_group_id,
461: cost_type_id ,
462: inventory_item_id,

Line 526: INSERT INTO mtl_pac_txn_cost_details

522: AND wppb.cost_group_id = p_cost_group_id
523: AND wppb.wip_entity_id = p_entity_id
524: AND NVL(wppb.line_id,-99) = decode(wppb.wip_entity_type, 4, -99, NVL(p_line_id,-99));
525: ELSE
526: INSERT INTO mtl_pac_txn_cost_details
527: (pac_period_id,
528: cost_group_id,
529: cost_type_id ,
530: inventory_item_id,

Line 571: INTO mtl_pac_txn_cost_details

567: l_stmt_num := 40;
568: INSERT ALL
569: -- Previous Level and Material cost element
570: WHEN (pl_material_temp <> 0 OR pl_material_temp_var <> 0) THEN
571: INTO mtl_pac_txn_cost_details
572: (pac_period_id,
573: cost_group_id,
574: cost_type_id,
575: inventory_item_id,

Line 610: INTO mtl_pac_txn_cost_details

606: sysdate,
607: p_login )
608: -- Previous Level and Material Overhead cost element
609: WHEN (pl_material_overhead_temp <> 0 OR pl_material_overhead_temp_var <> 0) THEN
610: INTO mtl_pac_txn_cost_details
611: (pac_period_id,
612: cost_group_id,
613: cost_type_id,
614: inventory_item_id,

Line 649: INTO mtl_pac_txn_cost_details

645: sysdate,
646: p_login )
647: -- Previous Level and Resource cost element
648: WHEN (pl_resource_temp <> 0 OR pl_resource_temp_var <> 0) THEN
649: INTO mtl_pac_txn_cost_details
650: (pac_period_id,
651: cost_group_id,
652: cost_type_id,
653: inventory_item_id,

Line 688: INTO mtl_pac_txn_cost_details

684: sysdate,
685: p_login )
686: -- Previous Level and Outside Processing cost element
687: WHEN (pl_outside_processing_temp <>0 OR pl_outside_processing_temp_var <> 0) THEN
688: INTO mtl_pac_txn_cost_details
689: (pac_period_id,
690: cost_group_id,
691: cost_type_id,
692: inventory_item_id,

Line 727: INTO mtl_pac_txn_cost_details

723: sysdate,
724: p_login )
725: -- Previous Level and Overhead cost element
726: WHEN (pl_overhead_temp <>0 OR pl_overhead_temp_var <> 0) THEN
727: INTO mtl_pac_txn_cost_details
728: (pac_period_id,
729: cost_group_id,
730: cost_type_id,
731: inventory_item_id,

Line 766: INTO mtl_pac_txn_cost_details

762: sysdate,
763: p_login )
764: -- This level and Resource Cost Element
765: WHEN (tl_resource_temp <> 0) THEN
766: INTO mtl_pac_txn_cost_details
767: (pac_period_id,
768: cost_group_id,
769: cost_type_id ,
770: inventory_item_id,

Line 803: INTO mtl_pac_txn_cost_details

799: sysdate,
800: p_login)
801: -- This Level and Outside Processing cost element
802: WHEN tl_outside_processing_temp <>0 THEN
803: INTO mtl_pac_txn_cost_details
804: (pac_period_id,
805: cost_group_id,
806: cost_type_id ,
807: inventory_item_id,

Line 840: INTO mtl_pac_txn_cost_details

836: sysdate,
837: p_login)
838: -- This Level and Overhead cost element
839: WHEN tl_overhead_temp <> 0 THEN
840: INTO mtl_pac_txn_cost_details
841: (pac_period_id,
842: cost_group_id,
843: cost_type_id ,
844: inventory_item_id,

Line 879: INTO mtl_pac_txn_cost_details

875: -- Create 0 TL Material instead of 0 PL Material when there is no non-zero cost details
876: WHEN (pl_material_temp = 0 AND pl_material_overhead_temp = 0 AND pl_resource_temp = 0 AND
877: pl_outside_processing_temp = 0 AND pl_overhead_temp = 0 AND tl_resource_temp = 0 AND
878: tl_outside_processing_temp = 0 AND tl_overhead_temp = 0) THEN
879: INTO mtl_pac_txn_cost_details
880: (pac_period_id,
881: cost_group_id,
882: cost_type_id ,
883: inventory_item_id,