[Home] [Help]
22: mmt.SUBINVENTORY_CODE,
23: mmt.LOCATOR_ID,
24: sum(mmt.PRIMARY_QUANTITY)
25: FROM MTL_MATERIAL_TRANSACTIONS mmt,
26: MTL_SYSTEM_ITEMS msi
27: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
28: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
29: AND mmt.ORGANIZATION_ID=Org_id
30: AND msi.LOT_CONTROL_CODE = 1
45: mmt.SUBINVENTORY_CODE,
46: mmt.LOCATOR_ID,
47: sum(mtln.PRIMARY_QUANTITY)
48: FROM MTL_MATERIAL_TRANSACTIONS mmt,
49: MTL_SYSTEM_ITEMS msi,
50: MTL_TRANSACTION_LOT_NUMBERS mtln
51: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
52: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
53: AND mmt.ORGANIZATION_ID=Org_id
69: mmt.SUBINVENTORY_CODE,
70: mmt.LOCATOR_ID,
71: sum(mta.BASE_TRANSACTION_VALUE)
72: FROM MTL_MATERIAL_TRANSACTIONS mmt,
73: MTL_SYSTEM_ITEMS msi,
74: MTL_TRANSACTION_ACCOUNTS mta
75: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
76: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
77: AND mmt.ORGANIZATION_ID=Org_id
96: mmt.SUBINVENTORY_CODE,
97: mmt.LOCATOR_ID,
98: sum(mta.BASE_TRANSACTION_VALUE)
99: FROM MTL_MATERIAL_TRANSACTIONS mmt,
100: MTL_SYSTEM_ITEMS msi,
101: MTL_TRANSACTION_LOT_NUMBERS mtln,
102: MTL_TRANSACTION_ACCOUNTS mta
103: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
104: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
366: mmt.SUBINVENTORY_CODE,
367: mmt.LOCATOR_ID,
368: sum(mmt.PRIMARY_QUANTITY)
369: FROM MTL_MATERIAL_TRANSACTIONS mmt,
370: MTL_SYSTEM_ITEMS msi
371: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
372: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
373: AND mmt.ORGANIZATION_ID=Org_id
374: AND msi.LOT_CONTROL_CODE = 1
389: mmt.SUBINVENTORY_CODE,
390: mmt.LOCATOR_ID,
391: sum(mtln.PRIMARY_QUANTITY)
392: FROM MTL_MATERIAL_TRANSACTIONS mmt,
393: MTL_SYSTEM_ITEMS msi,
394: MTL_TRANSACTION_LOT_NUMBERS mtln
395: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
396: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
397: AND mmt.transaction_id = mtln.transaction_id
413: mmt.SUBINVENTORY_CODE,
414: mmt.LOCATOR_ID,
415: sum(mta.BASE_TRANSACTION_VALUE)
416: FROM MTL_MATERIAL_TRANSACTIONS mmt,
417: MTL_SYSTEM_ITEMS msi,
418: MTL_TRANSACTION_ACCOUNTS mta
419: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
420: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
421: AND mmt.ORGANIZATION_ID=Org_id
439: mmt.SUBINVENTORY_CODE,
440: mmt.LOCATOR_ID,
441: sum(mta.BASE_TRANSACTION_VALUE)
442: FROM MTL_MATERIAL_TRANSACTIONS mmt,
443: MTL_SYSTEM_ITEMS msi,
444: MTL_TRANSACTION_LOT_NUMBERS mtln,
445: MTL_TRANSACTION_ACCOUNTS mta
446: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
447: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
682: mmt.SUBINVENTORY_CODE,
683: mmt.LOCATOR_ID,
684: sum(mmt.PRIMARY_QUANTITY)
685: FROM MTL_MATERIAL_TRANSACTIONS mmt,
686: MTL_SYSTEM_ITEMS msi
687: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
688: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
689: AND mmt.ORGANIZATION_ID=Org_id
690: AND msi.LOT_CONTROL_CODE = 1
705: mmt.SUBINVENTORY_CODE,
706: mmt.LOCATOR_ID,
707: sum(mtln.PRIMARY_QUANTITY)
708: FROM MTL_MATERIAL_TRANSACTIONS mmt,
709: MTL_SYSTEM_ITEMS msi,
710: MTL_TRANSACTION_LOT_NUMBERS mtln
711: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
712: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
713: AND mmt.ORGANIZATION_ID=Org_id
729: mmt.SUBINVENTORY_CODE,
730: mmt.LOCATOR_ID,
731: sum(mta.BASE_TRANSACTION_VALUE)
732: FROM MTL_MATERIAL_TRANSACTIONS mmt,
733: MTL_SYSTEM_ITEMS msi,
734: MTL_TRANSACTION_ACCOUNTS mta
735: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
736: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
737: AND mmt.ORGANIZATION_ID=Org_id
755: mmt.SUBINVENTORY_CODE,
756: mmt.LOCATOR_ID,
757: sum(mta.BASE_TRANSACTION_VALUE)
758: FROM MTL_MATERIAL_TRANSACTIONS mmt,
759: MTL_SYSTEM_ITEMS msi,
760: MTL_TRANSACTION_LOT_NUMBERS mtln,
761: MTL_TRANSACTION_ACCOUNTS mta
762: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
763: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1002: mmt.SUBINVENTORY_CODE,
1003: mmt.LOCATOR_ID,
1004: sum(mmt.PRIMARY_QUANTITY)
1005: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1006: MTL_SYSTEM_ITEMS msi
1007: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1008: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1009: AND mmt.ORGANIZATION_ID=Org_id
1010: AND msi.LOT_CONTROL_CODE = 1
1029: mmt.SUBINVENTORY_CODE,
1030: mmt.LOCATOR_ID,
1031: sum(mtln.PRIMARY_QUANTITY)
1032: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1033: MTL_SYSTEM_ITEMS msi,
1034: MTL_TRANSACTION_LOT_NUMBERS mtln
1035: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1036: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1037: AND mmt.ORGANIZATION_ID=Org_id
1057: mmt.SUBINVENTORY_CODE,
1058: mmt.LOCATOR_ID,
1059: sum(mta.BASE_TRANSACTION_VALUE)
1060: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1061: MTL_SYSTEM_ITEMS msi,
1062: MTL_TRANSACTION_ACCOUNTS mta
1063: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1064: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1065: AND mmt.ORGANIZATION_ID=Org_id
1087: mmt.SUBINVENTORY_CODE,
1088: mmt.LOCATOR_ID,
1089: sum(mta.BASE_TRANSACTION_VALUE)
1090: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1091: MTL_SYSTEM_ITEMS msi,
1092: MTL_TRANSACTION_LOT_NUMBERS mtln,
1093: MTL_TRANSACTION_ACCOUNTS mta
1094: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1095: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1331: mmt.SUBINVENTORY_CODE,
1332: mmt.LOCATOR_ID,
1333: sum(mmt.PRIMARY_QUANTITY)
1334: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1335: MTL_SYSTEM_ITEMS msi
1336: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1337: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1338: AND mmt.ORGANIZATION_ID=Org_id
1339: AND msi.LOT_CONTROL_CODE = 1
1354: mmt.SUBINVENTORY_CODE,
1355: mmt.LOCATOR_ID,
1356: sum(mtln.PRIMARY_QUANTITY)
1357: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1358: MTL_SYSTEM_ITEMS msi,
1359: MTL_TRANSACTION_LOT_NUMBERS mtln
1360: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1361: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1362: AND mmt.ORGANIZATION_ID=Org_id
1378: mmt.SUBINVENTORY_CODE,
1379: mmt.LOCATOR_ID,
1380: sum(mta.BASE_TRANSACTION_VALUE)
1381: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1382: MTL_SYSTEM_ITEMS msi,
1383: MTL_TRANSACTION_ACCOUNTS mta
1384: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1385: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1386: AND mmt.ORGANIZATION_ID=Org_id
1404: mmt.SUBINVENTORY_CODE,
1405: mmt.LOCATOR_ID,
1406: sum(mta.BASE_TRANSACTION_VALUE)
1407: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1408: MTL_SYSTEM_ITEMS msi,
1409: MTL_TRANSACTION_LOT_NUMBERS mtln,
1410: MTL_TRANSACTION_ACCOUNTS mta
1411: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1412: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1648: mmt.SUBINVENTORY_CODE,
1649: mmt.LOCATOR_ID,
1650: sum(mmt.PRIMARY_QUANTITY)
1651: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1652: MTL_SYSTEM_ITEMS msi
1653: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1654: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1655: AND mmt.ORGANIZATION_ID=Org_id
1656: AND msi.LOT_CONTROL_CODE = 1
1671: mmt.SUBINVENTORY_CODE,
1672: mmt.LOCATOR_ID,
1673: sum(mtln.PRIMARY_QUANTITY)
1674: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1675: MTL_SYSTEM_ITEMS msi,
1676: MTL_TRANSACTION_LOT_NUMBERS mtln
1677: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1678: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1679: AND mmt.ORGANIZATION_ID=Org_id
1695: mmt.SUBINVENTORY_CODE,
1696: mmt.LOCATOR_ID,
1697: sum(mta.BASE_TRANSACTION_VALUE)
1698: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1699: MTL_SYSTEM_ITEMS msi,
1700: MTL_TRANSACTION_ACCOUNTS mta
1701: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1702: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1703: AND mmt.ORGANIZATION_ID=Org_id
1722: mmt.SUBINVENTORY_CODE,
1723: mmt.LOCATOR_ID,
1724: sum(mta.BASE_TRANSACTION_VALUE)
1725: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1726: MTL_SYSTEM_ITEMS msi,
1727: MTL_TRANSACTION_LOT_NUMBERS mtln,
1728: MTL_TRANSACTION_ACCOUNTS mta
1729: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1730: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1970: mmt.SUBINVENTORY_CODE,
1971: mmt.LOCATOR_ID,
1972: sum(mmt.PRIMARY_QUANTITY)
1973: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1974: MTL_SYSTEM_ITEMS msi
1975: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1976: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1977: AND mmt.ORGANIZATION_ID=Org_id
1978: AND msi.LOT_CONTROL_CODE = 1
1993: mmt.SUBINVENTORY_CODE,
1994: mmt.LOCATOR_ID,
1995: sum(mtln.PRIMARY_QUANTITY)
1996: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1997: MTL_SYSTEM_ITEMS msi,
1998: MTL_TRANSACTION_LOT_NUMBERS mtln
1999: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2000: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2001: AND mmt.transaction_id = mtln.transaction_id
2021: mmt.SUBINVENTORY_CODE,
2022: mmt.LOCATOR_ID,
2023: sum(mta.BASE_TRANSACTION_VALUE)
2024: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2025: MTL_SYSTEM_ITEMS msi,
2026: MTL_TRANSACTION_ACCOUNTS mta
2027: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2028: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2029: AND mmt.ORGANIZATION_ID=Org_id
2047: mmt.SUBINVENTORY_CODE,
2048: mmt.LOCATOR_ID,
2049: sum(mta.BASE_TRANSACTION_VALUE)
2050: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2051: MTL_SYSTEM_ITEMS msi,
2052: MTL_TRANSACTION_LOT_NUMBERS mtln,
2053: MTL_TRANSACTION_ACCOUNTS mta
2054: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2055: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2085: mmt.SUBINVENTORY_CODE,
2086: mmt.LOCATOR_ID,
2087: sum(mta.BASE_TRANSACTION_VALUE)BASE_TRANSACTION_VALUE
2088: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2089: MTL_SYSTEM_ITEMS msi,
2090: MTL_TRANSACTION_ACCOUNTS mta
2091: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2092: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2093: AND mmt.ORGANIZATION_ID=Org_id
2111: mmt1.LOCATOR_ID,
2112: sum(mta.BASE_TRANSACTION_VALUE)BASE_TRANSACTION_VALUE
2113: FROM MTL_MATERIAL_TRANSACTIONS mmt1, --Parent Physical Txns
2114: MTL_MATERIAL_TRANSACTIONS mmt2, --Logical (Child) Txns
2115: MTL_SYSTEM_ITEMS msi,
2116: MTL_TRANSACTION_ACCOUNTS mta
2117: WHERE mmt1.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2118: AND mmt1.ORGANIZATION_ID=msi.ORGANIZATION_ID
2119: AND mmt1.ORGANIZATION_ID=Org_id
2155: mmt.SUBINVENTORY_CODE,
2156: mmt.LOCATOR_ID,
2157: sum(mta.BASE_TRANSACTION_VALUE)BASE_TRANSACTION_VALUE
2158: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2159: MTL_SYSTEM_ITEMS msi,
2160: MTL_TRANSACTION_LOT_NUMBERS mtln,
2161: MTL_TRANSACTION_ACCOUNTS mta
2162: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2163: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2184: mmt1.LOCATOR_ID,
2185: sum(mta.BASE_TRANSACTION_VALUE)BASE_TRANSACTION_VALUE
2186: FROM MTL_MATERIAL_TRANSACTIONS mmt1, --Parent Physical Txns
2187: MTL_MATERIAL_TRANSACTIONS mmt2, --Logical (Child) Txns
2188: MTL_SYSTEM_ITEMS msi,
2189: MTL_TRANSACTION_LOT_NUMBERS mtln,
2190: MTL_TRANSACTION_ACCOUNTS mta
2191: WHERE mmt1.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2192: AND mmt1.ORGANIZATION_ID=msi.ORGANIZATION_ID
2437: mmt.SUBINVENTORY_CODE,
2438: mmt.LOCATOR_ID,
2439: sum(mmt.PRIMARY_QUANTITY)
2440: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2441: MTL_SYSTEM_ITEMS msi
2442: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2443: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2444: AND mmt.ORGANIZATION_ID=Org_id
2445: AND msi.LOT_CONTROL_CODE = 1
2459: mmt.SUBINVENTORY_CODE,
2460: mmt.LOCATOR_ID,
2461: sum(mtln.PRIMARY_QUANTITY)
2462: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2463: MTL_SYSTEM_ITEMS msi,
2464: MTL_TRANSACTION_LOT_NUMBERS mtln
2465: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2466: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2467: AND mmt.transaction_id = mtln.transaction_id
2482: mmt.SUBINVENTORY_CODE,
2483: mmt.LOCATOR_ID,
2484: sum(mta.BASE_TRANSACTION_VALUE)
2485: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2486: MTL_SYSTEM_ITEMS msi,
2487: MTL_TRANSACTION_ACCOUNTS mta
2488: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2489: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2490: AND mmt.ORGANIZATION_ID=Org_id
2507: mmt.SUBINVENTORY_CODE,
2508: mmt.LOCATOR_ID,
2509: sum(mta.BASE_TRANSACTION_VALUE)
2510: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2511: MTL_SYSTEM_ITEMS msi,
2512: MTL_TRANSACTION_LOT_NUMBERS mtln,
2513: MTL_TRANSACTION_ACCOUNTS mta
2514: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2515: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2748: mmt.SUBINVENTORY_CODE,
2749: mmt.LOCATOR_ID,
2750: sum(mmt.PRIMARY_QUANTITY)
2751: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2752: MTL_SYSTEM_ITEMS msi
2753: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2754: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2755: AND mmt.ORGANIZATION_ID=Org_id
2756: AND msi.LOT_CONTROL_CODE = 1
2778: mmt.SUBINVENTORY_CODE,
2779: mmt.LOCATOR_ID,
2780: sum(mtln.PRIMARY_QUANTITY)
2781: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2782: MTL_SYSTEM_ITEMS msi,
2783: MTL_TRANSACTION_LOT_NUMBERS mtln
2784: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2785: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2786: AND mmt.transaction_id = mtln.transaction_id
2813: mmt.SUBINVENTORY_CODE,
2814: mmt.LOCATOR_ID,
2815: sum(mta.BASE_TRANSACTION_VALUE)
2816: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2817: MTL_SYSTEM_ITEMS msi,
2818: MTL_TRANSACTION_ACCOUNTS mta
2819: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2820: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2821: AND mmt.ORGANIZATION_ID=Org_id
2846: mmt.SUBINVENTORY_CODE,
2847: mmt.LOCATOR_ID,
2848: sum(mta.BASE_TRANSACTION_VALUE)
2849: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2850: MTL_SYSTEM_ITEMS msi,
2851: MTL_TRANSACTION_LOT_NUMBERS mtln,
2852: MTL_TRANSACTION_ACCOUNTS mta
2853: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2854: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2890: mmt.SUBINVENTORY_CODE,
2891: mmt.LOCATOR_ID,
2892: sum(mta.BASE_TRANSACTION_VALUE) BASE_TRANSACTION_VALUE
2893: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2894: MTL_SYSTEM_ITEMS msi,
2895: MTL_TRANSACTION_ACCOUNTS mta
2896: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2897: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2898: AND mmt.ORGANIZATION_ID=Org_id
2921: mmt1.LOCATOR_ID,
2922: sum(mta.BASE_TRANSACTION_VALUE)BASE_TRANSACTION_VALUE
2923: FROM MTL_MATERIAL_TRANSACTIONS mmt1, -- Parent Physical Txns
2924: MTL_MATERIAL_TRANSACTIONS mmt2, -- Logical (Child) Txns
2925: MTL_SYSTEM_ITEMS msi,
2926: MTL_TRANSACTION_ACCOUNTS mta
2927: WHERE mmt1.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2928: AND mmt1.ORGANIZATION_ID=msi.ORGANIZATION_ID
2929: AND mmt1.ORGANIZATION_ID=Org_id
2965: mmt.SUBINVENTORY_CODE,
2966: mmt.LOCATOR_ID,
2967: sum(mta.BASE_TRANSACTION_VALUE)BASE_TRANSACTION_VALUE
2968: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2969: MTL_SYSTEM_ITEMS msi,
2970: MTL_TRANSACTION_LOT_NUMBERS mtln,
2971: MTL_TRANSACTION_ACCOUNTS mta
2972: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
2973: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
2999: Mmt1.LOCATOR_ID,
3000: sum(mta.BASE_TRANSACTION_VALUE)BASE_TRANSACTION_VALUE
3001: FROM MTL_MATERIAL_TRANSACTIONS mmt1, --Parent Physical Txns
3002: MTL_MATERIAL_TRANSACTIONS mmt2, --Logical (Child) Txns
3003: MTL_SYSTEM_ITEMS msi,
3004: MTL_TRANSACTION_LOT_NUMBERS mtln,
3005: MTL_TRANSACTION_ACCOUNTS mta
3006: WHERE mmt1.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
3007: AND mmt1.ORGANIZATION_ID=msi.ORGANIZATION_ID
3249: mmt.SUBINVENTORY_CODE,
3250: mmt.LOCATOR_ID,
3251: sum(mmt.PRIMARY_QUANTITY)
3252: FROM MTL_MATERIAL_TRANSACTIONS mmt,
3253: MTL_SYSTEM_ITEMS msi
3254: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
3255: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
3256: AND mmt.ORGANIZATION_ID=Org_id
3257: AND msi.LOT_CONTROL_CODE = 1
3281: mmt.SUBINVENTORY_CODE,
3282: mmt.LOCATOR_ID,
3283: sum(mtln.PRIMARY_QUANTITY)
3284: FROM MTL_MATERIAL_TRANSACTIONS mmt,
3285: MTL_SYSTEM_ITEMS msi,
3286: MTL_TRANSACTION_LOT_NUMBERS mtln
3287: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
3288: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
3289: AND mmt.transaction_id = mtln.transaction_id
3315: mmt.SUBINVENTORY_CODE,
3316: mmt.LOCATOR_ID,
3317: sum(mta.BASE_TRANSACTION_VALUE)
3318: FROM MTL_MATERIAL_TRANSACTIONS mmt,
3319: MTL_SYSTEM_ITEMS msi,
3320: MTL_TRANSACTION_ACCOUNTS mta
3321: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
3322: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
3323: AND mmt.ORGANIZATION_ID=Org_id
3351: mmt.SUBINVENTORY_CODE,
3352: mmt.LOCATOR_ID,
3353: sum(mta.BASE_TRANSACTION_VALUE)
3354: FROM MTL_MATERIAL_TRANSACTIONS mmt,
3355: MTL_SYSTEM_ITEMS msi,
3356: MTL_TRANSACTION_LOT_NUMBERS mtln,
3357: MTL_TRANSACTION_ACCOUNTS mta
3358: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
3359: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID