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.OPIMPXIN dependencies on MTL_MATERIAL_TRANSACTIONS

Line 25: FROM MTL_MATERIAL_TRANSACTIONS mmt,

21: mmt.REVISION,
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

Line 48: FROM MTL_MATERIAL_TRANSACTIONS mmt,

44: mtln.LOT_NUMBER,
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

Line 72: FROM MTL_MATERIAL_TRANSACTIONS mmt,

68: mmt.REVISION,
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

Line 99: FROM MTL_MATERIAL_TRANSACTIONS mmt,

95: mtln.LOT_NUMBER,
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

Line 369: FROM MTL_MATERIAL_TRANSACTIONS mmt,

365: mmt.REVISION,
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

Line 392: FROM MTL_MATERIAL_TRANSACTIONS mmt,

388: mtln.LOT_NUMBER,
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

Line 416: FROM MTL_MATERIAL_TRANSACTIONS mmt,

412: mmt.REVISION,
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

Line 442: FROM MTL_MATERIAL_TRANSACTIONS mmt,

438: mtln.LOT_NUMBER,
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

Line 685: FROM MTL_MATERIAL_TRANSACTIONS mmt,

681: mmt.REVISION,
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

Line 708: FROM MTL_MATERIAL_TRANSACTIONS mmt,

704: mtln.LOT_NUMBER,
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

Line 732: FROM MTL_MATERIAL_TRANSACTIONS mmt,

728: mmt.REVISION,
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

Line 758: FROM MTL_MATERIAL_TRANSACTIONS mmt,

754: mtln.LOT_NUMBER,
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

Line 1005: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1001: mmt.REVISION,
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

Line 1032: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1028: mtln.LOT_NUMBER,
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

Line 1060: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1056: mmt.REVISION,
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

Line 1090: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1086: mtln.LOT_NUMBER,
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

Line 1334: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1330: mmt.REVISION,
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

Line 1357: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1353: mtln.LOT_NUMBER,
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

Line 1381: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1377: mmt.REVISION,
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

Line 1407: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1403: mtln.LOT_NUMBER,
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

Line 1651: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1647: mmt.REVISION,
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

Line 1674: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1670: mtln.LOT_NUMBER,
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

Line 1698: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1694: mmt.REVISION,
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

Line 1725: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1721: mtln.LOT_NUMBER,
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

Line 1973: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1969: mmt.REVISION,
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

Line 1996: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1992: mtln.LOT_NUMBER,
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

Line 2024: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2020: mmt.REVISION,
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

Line 2050: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2046: mtln.LOT_NUMBER,
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

Line 2088: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2084: mmt.REVISION,
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

Line 2113: FROM MTL_MATERIAL_TRANSACTIONS mmt1, --Parent Physical Txns

2109: mmt1.REVISION,
2110: mmt1.SUBINVENTORY_CODE,
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

Line 2114: MTL_MATERIAL_TRANSACTIONS mmt2, --Logical (Child) Txns

2110: mmt1.SUBINVENTORY_CODE,
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

Line 2158: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2154: mtln.LOT_NUMBER,
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

Line 2186: FROM MTL_MATERIAL_TRANSACTIONS mmt1, --Parent Physical Txns

2182: mtln.LOT_NUMBER,
2183: mmt1.SUBINVENTORY_CODE,
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

Line 2187: MTL_MATERIAL_TRANSACTIONS mmt2, --Logical (Child) Txns

2183: mmt1.SUBINVENTORY_CODE,
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

Line 2440: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2436: mmt.REVISION,
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

Line 2462: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2458: mtln.LOT_NUMBER,
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

Line 2485: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2481: mmt.REVISION,
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

Line 2510: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2506: mtln.LOT_NUMBER,
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

Line 2751: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2747: mmt.REVISION,
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

Line 2781: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2777: mtln.LOT_NUMBER,
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

Line 2816: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2812: mmt.REVISION,
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

Line 2849: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2845: mtln.LOT_NUMBER,
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

Line 2893: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2889: mmt.REVISION,
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

Line 2923: FROM MTL_MATERIAL_TRANSACTIONS mmt1, -- Parent Physical Txns

2919: mmt1.REVISION,
2920: mmt1.SUBINVENTORY_CODE,
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

Line 2924: MTL_MATERIAL_TRANSACTIONS mmt2, -- Logical (Child) Txns

2920: mmt1.SUBINVENTORY_CODE,
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

Line 2968: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2964: mtln.LOT_NUMBER,
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

Line 3001: FROM MTL_MATERIAL_TRANSACTIONS mmt1, --Parent Physical Txns

2997: mtln.LOT_NUMBER,
2998: Mmt1.SUBINVENTORY_CODE,
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

Line 3002: MTL_MATERIAL_TRANSACTIONS mmt2, --Logical (Child) Txns

2998: Mmt1.SUBINVENTORY_CODE,
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

Line 3252: FROM MTL_MATERIAL_TRANSACTIONS mmt,

3248: mmt.REVISION,
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

Line 3284: FROM MTL_MATERIAL_TRANSACTIONS mmt,

3280: mtln.LOT_NUMBER,
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

Line 3318: FROM MTL_MATERIAL_TRANSACTIONS mmt,

3314: mmt.REVISION,
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

Line 3354: FROM MTL_MATERIAL_TRANSACTIONS mmt,

3350: mtln.LOT_NUMBER,
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