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.CSTPPWAS dependencies on MTL_PAC_TXN_COST_DETAILS

Line 146: INTO mtl_pac_txn_cost_details

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

Line 185: INTO mtl_pac_txn_cost_details

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

Line 224: INTO mtl_pac_txn_cost_details

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

Line 263: INTO mtl_pac_txn_cost_details

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

Line 302: INTO mtl_pac_txn_cost_details

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

Line 341: INTO mtl_pac_txn_cost_details

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

Line 380: INTO mtl_pac_txn_cost_details

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

Line 419: INTO mtl_pac_txn_cost_details

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

Line 460: INTO mtl_pac_txn_cost_details

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

Line 528: /* INSERT INTO mtl_pac_txn_cost_details

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

Line 569: INTO mtl_pac_txn_cost_details

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

Line 608: INTO mtl_pac_txn_cost_details

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

Line 647: INTO mtl_pac_txn_cost_details

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

Line 686: INTO mtl_pac_txn_cost_details

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

Line 725: INTO mtl_pac_txn_cost_details

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

Line 764: INTO mtl_pac_txn_cost_details

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

Line 801: INTO mtl_pac_txn_cost_details

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

Line 838: INTO mtl_pac_txn_cost_details

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

Line 877: INTO mtl_pac_txn_cost_details

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

Line 966: INTO mtl_pac_txn_cost_details

962: l_stmt_num := 40;
963: INSERT ALL
964: -- Previous Level and Material cost element
965: WHEN (pl_material_temp <> 0 OR pl_material_temp_var <> 0) THEN
966: INTO mtl_pac_txn_cost_details
967: (pac_period_id,
968: cost_group_id,
969: cost_type_id,
970: inventory_item_id,

Line 1005: INTO mtl_pac_txn_cost_details

1001: sysdate,
1002: p_login )
1003: -- Previous Level and Material Overhead cost element
1004: WHEN (pl_material_overhead_temp <> 0 OR pl_material_overhead_temp_var <> 0) THEN
1005: INTO mtl_pac_txn_cost_details
1006: (pac_period_id,
1007: cost_group_id,
1008: cost_type_id,
1009: inventory_item_id,

Line 1044: INTO mtl_pac_txn_cost_details

1040: sysdate,
1041: p_login )
1042: -- Previous Level and Resource cost element
1043: WHEN (pl_resource_temp <> 0 OR pl_resource_temp_var <> 0) THEN
1044: INTO mtl_pac_txn_cost_details
1045: (pac_period_id,
1046: cost_group_id,
1047: cost_type_id,
1048: inventory_item_id,

Line 1083: INTO mtl_pac_txn_cost_details

1079: sysdate,
1080: p_login )
1081: -- Previous Level and Outside Processing cost element
1082: WHEN (pl_outside_processing_temp <>0 OR pl_outside_processing_temp_var <> 0) THEN
1083: INTO mtl_pac_txn_cost_details
1084: (pac_period_id,
1085: cost_group_id,
1086: cost_type_id,
1087: inventory_item_id,

Line 1122: INTO mtl_pac_txn_cost_details

1118: sysdate,
1119: p_login )
1120: -- Previous Level and Overhead cost element
1121: WHEN (pl_overhead_temp <>0 OR pl_overhead_temp_var <> 0) THEN
1122: INTO mtl_pac_txn_cost_details
1123: (pac_period_id,
1124: cost_group_id,
1125: cost_type_id,
1126: inventory_item_id,

Line 1161: INTO mtl_pac_txn_cost_details

1157: sysdate,
1158: p_login )
1159: -- This level and Resource Cost Element
1160: WHEN (tl_resource_temp <> 0) THEN
1161: INTO mtl_pac_txn_cost_details
1162: (pac_period_id,
1163: cost_group_id,
1164: cost_type_id ,
1165: inventory_item_id,

Line 1198: INTO mtl_pac_txn_cost_details

1194: sysdate,
1195: p_login)
1196: -- This Level and Outside Processing cost element
1197: WHEN tl_outside_processing_temp <>0 THEN
1198: INTO mtl_pac_txn_cost_details
1199: (pac_period_id,
1200: cost_group_id,
1201: cost_type_id ,
1202: inventory_item_id,

Line 1235: INTO mtl_pac_txn_cost_details

1231: sysdate,
1232: p_login)
1233: -- This Level and Overhead cost element
1234: WHEN tl_overhead_temp <> 0 THEN
1235: INTO mtl_pac_txn_cost_details
1236: (pac_period_id,
1237: cost_group_id,
1238: cost_type_id ,
1239: inventory_item_id,

Line 1274: INTO mtl_pac_txn_cost_details

1270: -- Create 0 TL Material instead of 0 PL Material when there is no non-zero cost details
1271: WHEN (pl_material_temp = 0 AND pl_material_overhead_temp = 0 AND pl_resource_temp = 0 AND
1272: pl_outside_processing_temp = 0 AND pl_overhead_temp = 0 AND tl_resource_temp = 0 AND
1273: tl_outside_processing_temp = 0 AND tl_overhead_temp = 0) THEN
1274: INTO mtl_pac_txn_cost_details
1275: (pac_period_id,
1276: cost_group_id,
1277: cost_type_id ,
1278: inventory_item_id,