[Home] [Help]
17: prc number := 1;
18: msgbuf varchar2(200);
19:
20: begin
21: delete from mtl_summary_temp
22: where session_id = sessionid;
23:
24: /*Bug4950410 : Added the following query to get the currency precision to round the inventory value.
25: Also rounding the net_val and abs_val based on the currency precision of the organization. */
38: /* Source Type and Txn Type Summary */
39: /* We are also storing transaction action here
40: for future use */
41: /*Bug2712883 : The insert statements having cg_id in their where clause is modified so as to include NVL's on both sides */
42: insert into mtl_summary_temp
43: (session_id,
44: summary_type,
45: transaction_source_type_name,
46: transaction_type_name,
79: group by mtst.transaction_source_type_name,
80: mtt.transaction_type_name, ml.meaning;
81:
82: /* Source Type Summary */
83: insert into mtl_summary_temp
84: (session_id,
85: summary_type,
86: transaction_source_type_name,
87: net_qty,
97: sum(mst.net_val),
98: sum(mst.num_txns),
99: sum(mst.abs_qty),
100: sum(mst.abs_val)
101: from mtl_summary_temp mst
102: where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
103: and session_id = sessionid
104: group by mst.transaction_source_type_name;
105:
103: and session_id = sessionid
104: group by mst.transaction_source_type_name;
105:
106: /* Transaction type summary */
107: insert into mtl_summary_temp
108: (session_id,
109: summary_type,
110: transaction_type_name,
111: net_qty,
121: sum(mst.net_val),
122: sum(mst.num_txns),
123: sum(mst.abs_qty),
124: sum(mst.abs_val)
125: from mtl_summary_temp mst
126: where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
127: and session_id = sessionid
128: group by mst.transaction_type_name;
129:
127: and session_id = sessionid
128: group by mst.transaction_type_name;
129:
130: /* Action Summary */
131: insert into mtl_summary_temp
132: (session_id,
133: summary_type,
134: transaction_action_name,
135: net_qty,
145: sum(mst.net_val),
146: sum(mst.num_txns),
147: sum(mst.abs_qty),
148: sum(mst.abs_val)
149: from mtl_summary_temp mst
150: where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
151: and session_id = sessionid
152: group by mst.transaction_action_name;
153:
152: group by mst.transaction_action_name;
153:
154: /* Subinventory Summary */
155: if (orgloctype = 1) then
156: insert into mtl_summary_temp
157: (session_id,
158: summary_type,
159: subinventory,
160: net_qty,
181: and mmt.transaction_action_id NOT IN (24,30,50,51,52) /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
182: group by mmt.subinventory_code;
183: else
184: /* Subinventory - Locator Summary */
185: insert into mtl_summary_temp
186: (session_id,
187: summary_type,
188: subinventory,
189: locator_id,
212: and mmt.transaction_action_id NOT IN (24,30,50,51,52) /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
213: group by mmt.subinventory_code, mmt.locator_id;
214:
215: /* Subinventory Summary */
216: insert into mtl_summary_temp
217: (session_id,
218: summary_type,
219: subinventory,
220: net_qty,
230: sum(mst.net_val),
231: sum(mst.num_txns),
232: sum(mst.abs_qty),
233: sum(mst.abs_val)
234: from mtl_summary_temp mst
235: where mst.summary_type = 'SUBINVENTORY_LOCATOR_SUMMARY'
236: and session_id = sessionid
237: group by mst.subinventory;
238: end if;
239:
240: /* subinventory cost group summary */
241: /* changes for zone/rearchitecture project */
242: /* ssia 06/02/00 */
243: insert into mtl_summary_temp
244: (session_id,
245: summary_type,
246: subinventory,
247: cost_group_id,
270: and mmt.transaction_action_id NOT IN (24,30,50,51,52) /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
271: group by mmt.subinventory_code, mmt.cost_group_id;
272:
273: /* Cost_group_summary */
274: insert into mtl_summary_temp
275: (session_id,
276: summary_type,
277: cost_group_id,
278: net_qty,
288: sum(mst.net_val),
289: sum(mst.num_txns),
290: sum(mst.abs_qty),
291: sum(mst.abs_val)
292: from mtl_summary_temp mst
293: where mst.summary_type = 'SUB_COST_GROUP_SUMMARY'
294: and session_id = sessionid
295: group by mst.cost_group_id;
296:
295: group by mst.cost_group_id;
296:
297: /* Totals Summary */
298: /* Total In */
299: insert into mtl_summary_temp
300: (session_id,
301: summary_type,
302: net_qty,
303: net_val,
320: and mmt.primary_quantity > 0
321: and mmt.transaction_action_id NOT IN (24,30,50,51,52); /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
322:
323: /* Total Out */
324: insert into mtl_summary_temp
325: (session_id,
326: summary_type,
327: net_qty,
328: net_val,
345: and mmt.primary_quantity < 0
346: and mmt.transaction_action_id NOT IN (24,30,50,51,52); /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
347:
348: /* Total Net */
349: insert into mtl_summary_temp
350: (session_id,
351: summary_type,
352: net_qty,
353: net_val,
359: sum(mst.net_qty),
360: sum(mst.net_val),
361: null,
362: 3
363: from mtl_summary_temp mst
364: where mst.summary_type='TXN_ACTION_SUMMARY'
365: and session_id = sessionid;
366: /* TXN_ACTION_SUMMARY is most likely to be a smaller
367: set of rows */
384: msgbuf varchar2(200);
385: prc number := 1;
386: cratio number := 1;
387: begin
388: delete from mtl_summary_temp where session_id = sessionid;
389:
390: /*Bug4950410 : Added the following query to get the currency precision to round the inventory value.
391: Also rounding the net_val and abs_val based on the currency precision of the organization. */
392:
403: IF catsetid IS NULL AND catid IS NULL THEN
404: /* Item, Source Type, Txn Type summary */
405: /* We are inserting transaction action as well
406: for later summarization */
407: insert into mtl_summary_temp
408: (session_id,
409: summary_type,
410: inventory_item_id,
411: organization_id,
449: mtst.transaction_source_type_name,
450: mtt.transaction_type_name,
451: ml.meaning;
452: ELSE
453: insert into mtl_summary_temp
454: (session_id,
455: summary_type,
456: inventory_item_id,
457: organization_id,
503: ml.meaning;
504: END IF;
505: -- End changes bug 3614951
506: /* Item summmary */
507: insert into mtl_summary_temp
508: (session_id,
509: summary_type,
510: inventory_item_id,
511: organization_id,
523: sum(mst.net_val),
524: sum(mst.num_txns),
525: sum(mst.abs_qty),
526: sum(mst.abs_val)
527: from mtl_summary_temp mst
528: where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
529: and session_id = sessionid
530: group by mst.inventory_item_id;
531:
529: and session_id = sessionid
530: group by mst.inventory_item_id;
531:
532: /* Item, Source Type summary */
533: insert into mtl_summary_temp
534: (session_id,
535: summary_type,
536: inventory_item_id,
537: organization_id,
551: sum(mst.net_val),
552: sum(mst.num_txns),
553: sum(mst.abs_qty),
554: sum(mst.abs_val)
555: from mtl_summary_temp mst
556: where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
557: and session_id = sessionid
558: group by mst.inventory_item_id, mst.transaction_source_type_name;
559:
557: and session_id = sessionid
558: group by mst.inventory_item_id, mst.transaction_source_type_name;
559:
560: /* Item, Txn Type summary */
561: insert into mtl_summary_temp
562: (session_id,
563: summary_type,
564: inventory_item_id,
565: organization_id,
579: sum(mst.net_val),
580: sum(mst.num_txns),
581: sum(mst.abs_qty),
582: sum(mst.abs_val)
583: from mtl_summary_temp mst
584: where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
585: and session_id = sessionid
586: group by mst.inventory_item_id, mst.transaction_type_name;
587:
585: and session_id = sessionid
586: group by mst.inventory_item_id, mst.transaction_type_name;
587:
588: /* Item, Txn action summary */
589: insert into mtl_summary_temp
590: (session_id,
591: summary_type,
592: inventory_item_id,
593: organization_id,
607: sum(mst.net_val),
608: sum(mst.num_txns),
609: sum(mst.abs_qty),
610: sum(mst.abs_val)
611: from mtl_summary_temp mst
612: where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
613: and session_id = sessionid
614: group by mst.inventory_item_id, mst.transaction_action_name;
615:
612: where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
613: and session_id = sessionid
614: group by mst.inventory_item_id, mst.transaction_action_name;
615:
616: insert into mtl_summary_temp
617: (session_id,
618: summary_type,
619: subinventory,
620: cost_group_id,
643: and mmt.transaction_action_id NOT IN (24,30,50,51,52) /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
644: group by mmt.subinventory_code, mmt.cost_group_id;
645:
646: /* Cost_group_summary */
647: insert into mtl_summary_temp
648: (session_id,
649: summary_type,
650: cost_group_id,
651: net_qty,
661: sum(mst.net_val),
662: sum(mst.num_txns),
663: sum(mst.abs_qty),
664: sum(mst.abs_val)
665: from mtl_summary_temp mst
666: where mst.summary_type = 'SUB_COST_GROUP_SUMMARY'
667: and session_id = sessionid
668: group by mst.cost_group_id;
669: -- Bug 3614951 changing the below sql to execute conditionally.
669: -- Bug 3614951 changing the below sql to execute conditionally.
670: -- Begin changes
671: IF catsetid IS NULL AND catid IS NULL THEN
672: /* Totals Summary */
673: insert into mtl_summary_temp
674: (session_id,
675: summary_type,
676: net_val,
677: num_txns,
691: and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
692: and mmt.primary_quantity > 0
693: and mmt.transaction_action_id NOT IN (24,30,50,51,52); /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
694:
695: insert into mtl_summary_temp
696: (session_id,
697: summary_type,
698: net_val,
699: num_txns,
713: and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
714: and mmt.primary_quantity < 0
715: and mmt.transaction_action_id NOT IN (24,30,50,51,52); /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
716: ELSE
717: insert into mtl_summary_temp
718: (session_id,
719: summary_type,
720: net_val,
721: num_txns,
741: and mic.organization_id = orgid)
742: and mmt.primary_quantity > 0
743: and mmt.transaction_action_id NOT IN (24,30,50,51,52); /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
744:
745: insert into mtl_summary_temp
746: (session_id,
747: summary_type,
748: net_val,
749: num_txns,
770: and mmt.primary_quantity < 0
771: and mmt.transaction_action_id NOT IN (24,30,50,51,52); /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
772: END IF;
773: -- End changes bug 3614951
774: insert into mtl_summary_temp
775: (session_id,
776: summary_type,
777: net_val,
778: num_txns,
782: 'TOTALS',
783: sum(mst.net_val),
784: null,
785: 3
786: from mtl_summary_temp mst
787: where summary_type = 'ITEM_SUMMARY'
788: and session_id = sessionid;
789: exception
790: when others then
807: cratio number := 1;
808: prc number := 1;
809: msgbuf varchar2(200);
810: begin
811: delete from mtl_summary_temp where session_id = sessionid;
812:
813: /*Bug4950410 : Added the following query to get the currency precision to round the inventory value.
814: Also rounding the net_val and abs_val based on the currency precision of the organization. */
815: select fc.precision into prc
824: cratio := inv_convert.inv_um_convert(invid,5,null, puom,uom,null,null);
825: end if;
826:
827: /* Source Type and Txn Type Summary */
828: insert into mtl_summary_temp
829: (session_id,
830: summary_type,
831: transaction_source_type_name,
832: transaction_type_name,
866: and mmt.transaction_action_id NOT IN (24,30,50,51,52) /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
867: group by mtst.transaction_source_type_name, mtt.transaction_type_name, ml.meaning;
868:
869: /* Source Type Summary */
870: insert into mtl_summary_temp
871: (session_id,
872: summary_type,
873: transaction_source_type_name,
874: net_qty,
884: sum(mst.net_val),
885: sum(mst.num_txns),
886: sum(mst.abs_qty),
887: sum(mst.abs_val)
888: from mtl_summary_temp mst
889: where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
890: and session_id = sessionid
891: group by mst.transaction_source_type_name;
892:
892:
893: /* */
894: /* Transaction type summary */
895:
896: insert into mtl_summary_temp
897: (session_id,
898: summary_type,
899: transaction_type_name,
900: net_qty,
910: sum(mst.net_val),
911: sum(mst.num_txns),
912: sum(mst.abs_qty),
913: sum(mst.abs_val)
914: from mtl_summary_temp mst
915: where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
916: and session_id = sessionid
917: group by mst.transaction_type_name;
918: /* */
917: group by mst.transaction_type_name;
918: /* */
919:
920: /* Action Summary */
921: insert into mtl_summary_temp
922: (session_id,
923: summary_type,
924: transaction_action_name,
925: net_qty,
935: sum(mst.net_val),
936: sum(mst.num_txns),
937: sum(mst.abs_qty),
938: sum(mst.abs_val)
939: from mtl_summary_temp mst
940: where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
941: and session_id = sessionid
942: group by mst.transaction_action_name;
943:
941: and session_id = sessionid
942: group by mst.transaction_action_name;
943:
944: /* cost group subinventory summary */
945: insert into mtl_summary_temp
946: (session_id,
947: summary_type,
948: subinventory,
949: cost_group_id,
974: and mmt.transaction_action_id NOT IN (24,30,50,51,52) /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
975: group by mmt.subinventory_code, mmt.cost_group_id;
976:
977: /* Cost_group_summary */
978: insert into mtl_summary_temp
979: (session_id,
980: summary_type,
981: cost_group_id,
982: net_qty,
992: sum(mst.net_val),
993: sum(mst.num_txns),
994: sum(mst.abs_qty),
995: sum(mst.abs_val)
996: from mtl_summary_temp mst
997: where mst.summary_type = 'SUB_COST_GROUP_SUMMARY'
998: and session_id = sessionid
999: group by mst.cost_group_id;
1000:
999: group by mst.cost_group_id;
1000:
1001:
1002: /* Totals */
1003: insert into mtl_summary_temp
1004: (session_id,
1005: summary_type,
1006: net_qty,
1007: net_val,
1026: and mmt.primary_quantity > 0
1027: and mmt.transaction_action_id NOT IN (24,30,50,51,52); /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
1028:
1029:
1030: insert into mtl_summary_temp
1031: (session_id,
1032: summary_type,
1033: net_qty,
1034: net_val,
1052: and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
1053: and mmt.primary_quantity < 0
1054: and mmt.transaction_action_id NOT IN (24,30,50,51,52); /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
1055:
1056: insert into mtl_summary_temp
1057: (session_id,
1058: summary_type,
1059: net_qty,
1060: net_val,
1066: sum(mst.net_qty),
1067: sum(mst.net_val),
1068: null,
1069: 3
1070: from mtl_summary_temp mst
1071: where mst.summary_type = 'TXN_ACTION_SUMMARY'
1072: and session_id = sessionid;
1073:
1074: exception
1086: IS
1087: msgbuf varchar2(200);
1088: cratio number := 1;
1089: begin
1090: delete from mtl_summary_temp where session_id = sessionid;
1091: */
1092: /* Item, Source Type, Txn Type summary */
1093: /* We are inserting transaction action as well
1094: for later summarization */
1091: */
1092: /* Item, Source Type, Txn Type summary */
1093: /* We are inserting transaction action as well
1094: for later summarization */
1095: /* insert into mtl_summary_temp
1096: (session_id,
1097: summary_type,
1098: inventory_item_id,
1099: organization_id,
1136: mtt.transaction_type_name,
1137: ml.meaning;*/
1138:
1139: /* Item, Source Type summary */
1140: /*insert into mtl_summary_temp
1141: (session_id,
1142: summary_type,
1143: inventory_item_id,
1144: organization_id,
1158: sum(mst.net_val),
1159: sum(mst.num_txns),
1160: sum(mst.abs_qty),
1161: sum(mst.abs_val)
1162: from mtl_summary_temp mst
1163: where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
1164: and session_id = sessionid
1165: group by mst.inventory_item_id, mst.transaction_source_type_name;
1166: */
1164: and session_id = sessionid
1165: group by mst.inventory_item_id, mst.transaction_source_type_name;
1166: */
1167: /* Item, Txn Type summary */
1168: /* insert into mtl_summary_temp
1169: (session_id,
1170: summary_type,
1171: inventory_item_id,
1172: organization_id,
1186: sum(mst.net_val),
1187: sum(mst.num_txns),
1188: sum(mst.abs_qty),
1189: sum(mst.abs_val)
1190: from mtl_summary_temp mst
1191: where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
1192: and session_id = sessionid
1193: group by mst.inventory_item_id, mst.transaction_type_name;
1194: */
1192: and session_id = sessionid
1193: group by mst.inventory_item_id, mst.transaction_type_name;
1194: */
1195: /* Item, Txn action summary */
1196: /* insert into mtl_summary_temp
1197: (session_id,
1198: summary_type,
1199: inventory_item_id,
1200: organization_id,
1214: sum(mst.net_val),
1215: sum(mst.num_txns),
1216: sum(mst.abs_qty),
1217: sum(mst.abs_val)
1218: from mtl_summary_temp mst
1219: where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
1220: and session_id = sessionid
1221: group by mst.inventory_item_id, mst.transaction_action_name;
1222: */
1221: group by mst.inventory_item_id, mst.transaction_action_name;
1222: */
1223: /* Subinventory Summary */
1224: /* if (orgloctype = 1) then
1225: insert into mtl_summary_temp
1226: (session_id,
1227: summary_type,
1228: subinventory,
1229: net_qty,
1248: and mmt.transaction_action_id NOT IN (24,30)
1249: group by mmt.subinventory_code;
1250: else*/
1251: /* Subinventory - Locator Summary */
1252: /* insert into mtl_summary_temp
1253: (session_id,
1254: summary_type,
1255: subinventory,
1256: locator_id,
1277: and mmt.transaction_action_id NOT IN (24,30)
1278: group by mmt.subinventory_code, mmt.locator_id;
1279: */
1280: /* Subinventory Summary */
1281: /* insert into mtl_summary_temp
1282: (session_id,
1283: summary_type,
1284: subinventory,
1285: net_qty,
1295: sum(mst.net_val),
1296: sum(mst.num_txns),
1297: sum(mst.abs_qty),
1298: sum(mst.abs_val)
1299: from mtl_summary_temp mst
1300: where mst.summary_type = 'SUBINVENTORY_LOCATOR_SUMMARY'
1301: and session_id = sessionid
1302: group by mst.subinventory;
1303: end if;
1304: */
1305: /* subinventory cost group summary */
1306: /* changes for zone/rearchitecture project */
1307: /* ssia 06/02/00 */
1308: /* insert into mtl_summary_temp
1309: (session_id,
1310: summary_type,
1311: subinventory,
1312: cost_group_id,
1333: and mmt.transaction_action_id NOT IN (24,30)
1334: group by mmt.subinventory_code, mmt.cost_group_id;
1335: */
1336: /* Cost_group_summary */
1337: /* insert into mtl_summary_temp
1338: (session_id,
1339: summary_type,
1340: cost_group_id,
1341: net_qty,
1351: sum(mst.net_val),
1352: sum(mst.num_txns),
1353: sum(mst.abs_qty),
1354: sum(mst.abs_val)
1355: from mtl_summary_temp mst
1356: where mst.summary_type = 'SUB_COST_GROUP_SUMMARY'
1357: and session_id = sessionid
1358: group by mst.cost_group_id;
1359: */
1357: and session_id = sessionid
1358: group by mst.cost_group_id;
1359: */
1360: /* Totals Summary */
1361: /* insert into mtl_summary_temp
1362: (session_id,
1363: summary_type,
1364: net_val,
1365: num_txns,
1377: and mmt.cost_group_id = cost_group_id
1378: and mmt.primary_quantity > 0
1379: and mmt.transaction_action_id NOT IN (24,30);
1380:
1381: insert into mtl_summary_temp
1382: (session_id,
1383: summary_type,
1384: net_val,
1385: num_txns,
1397: and mmt.cost_group_id = cost_group_id
1398: and mmt.primary_quantity < 0
1399: and mmt.transaction_action_id NOT IN (24,30);
1400:
1401: insert into mtl_summary_temp
1402: (session_id,
1403: summary_type,
1404: net_val,
1405: num_txns,
1409: 'TOTALS',
1410: sum(mst.net_val),
1411: null,
1412: 3
1413: from mtl_summary_temp mst
1414: where summary_type = 'ITEM_SUMMARY'
1415: and session_id = sessionid;
1416: exception
1417: when others then
1428: IS
1429: msgbuf varchar2(200);
1430: begin
1431:
1432: delete from mtl_summary_temp where session_id = sessionid;
1433: */
1434: /* Item, Source Type, Txn Type summary */
1435: /* We are inserting transaction action as well
1436: for later summarization */
1433: */
1434: /* Item, Source Type, Txn Type summary */
1435: /* We are inserting transaction action as well
1436: for later summarization */
1437: /* insert into mtl_summary_temp
1438: (session_id,
1439: summary_type,
1440: inventory_item_id,
1441: organization_id,
1478: mtt.transaction_type_name,
1479: ml.meaning;
1480: */
1481: /* Item, Source Type summary */
1482: /* insert into mtl_summary_temp
1483: (session_id,
1484: summary_type,
1485: inventory_item_id,
1486: organization_id,
1500: sum(mst.net_val),
1501: sum(mst.num_txns),
1502: sum(mst.abs_qty),
1503: sum(mst.abs_val)
1504: from mtl_summary_temp mst
1505: where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
1506: and session_id = sessionid
1507: group by mst.inventory_item_id,
1508: mst.transaction_source_type_name;
1507: group by mst.inventory_item_id,
1508: mst.transaction_source_type_name;
1509: */
1510: /* Item, Txn Type summary */
1511: /* insert into mtl_summary_temp
1512: (session_id,
1513: summary_type,
1514: inventory_item_id,
1515: organization_id,
1529: sum(mst.net_val),
1530: sum(mst.num_txns),
1531: sum(mst.abs_qty),
1532: sum(mst.abs_val)
1533: from mtl_summary_temp mst
1534: where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
1535: and session_id = sessionid
1536: group by mst.inventory_item_id,
1537: mst.transaction_type_name;
1536: group by mst.inventory_item_id,
1537: mst.transaction_type_name;
1538: */
1539: /* Item, Txn action summary */
1540: /* insert into mtl_summary_temp
1541: (session_id,
1542: summary_type,
1543: inventory_item_id,
1544: organization_id,
1558: sum(mst.net_val),
1559: sum(mst.num_txns),
1560: sum(mst.abs_qty),
1561: sum(mst.abs_val)
1562: from mtl_summary_temp mst
1563: where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
1564: and session_id = sessionid
1565: group by mst.inventory_item_id,
1566: mst.transaction_action_name;
1565: group by mst.inventory_item_id,
1566: mst.transaction_action_name;
1567: */
1568: /* Totals Summary */
1569: /* insert into mtl_summary_temp
1570: (session_id,
1571: summary_type,
1572: net_val,
1573: num_txns,
1586: and mmt.cost_group_id = nvl(cost_Group_id, mmt.cost_Group_id)
1587: and mmt.primary_quantity > 0
1588: and mmt.transaction_action_id NOT IN (24,30);
1589:
1590: insert into mtl_summary_temp
1591: (session_id,
1592: summary_type,
1593: net_val,
1594: num_txns,
1607: and mmt.cost_group_id = nvl(cost_group_id, mmt.locator_id)
1608: and mmt.primary_quantity < 0
1609: and mmt.transaction_action_id NOT IN (24,30);
1610:
1611: insert into mtl_summary_temp
1612: (session_id,
1613: summary_type,
1614: net_val,
1615: num_txns,
1619: 'TOTALS',
1620: sum(mst.net_val),
1621: null,
1622: 3
1623: from mtl_summary_temp mst
1624: where summary_type = 'ITEM_SUMMARY'
1625: and session_id = sessionid;
1626: exception
1627: when others then