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_TRANSACTION_LOT_NUMBERS

Line 50: MTL_TRANSACTION_LOT_NUMBERS mtln

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
54: AND mmt.transaction_id = mtln.transaction_id

Line 101: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
105: AND mmt.ORGANIZATION_ID=Org_id

Line 394: MTL_TRANSACTION_LOT_NUMBERS mtln

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
398: AND mmt.ORGANIZATION_ID=Org_id

Line 444: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
448: AND mmt.ORGANIZATION_ID=Org_id

Line 710: MTL_TRANSACTION_LOT_NUMBERS mtln

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
714: AND mmt.transaction_id = mtln.transaction_id

Line 760: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
764: AND mmt.transaction_id = mtln.transaction_id

Line 1034: MTL_TRANSACTION_LOT_NUMBERS mtln

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
1038: AND mmt.transaction_id = mtln.transaction_id

Line 1092: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
1096: AND mmt.transaction_id = mtln.transaction_id

Line 1359: MTL_TRANSACTION_LOT_NUMBERS mtln

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
1363: AND mmt.transaction_id = mtln.transaction_id

Line 1409: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
1413: AND mmt.ORGANIZATION_ID=Org_id

Line 1676: MTL_TRANSACTION_LOT_NUMBERS mtln

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
1680: AND mmt.transaction_id = mtln.transaction_id

Line 1727: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
1731: AND mmt.ORGANIZATION_ID=Org_id

Line 1998: MTL_TRANSACTION_LOT_NUMBERS mtln

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
2002: AND mmt.ORGANIZATION_ID=Org_id

Line 2052: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
2056: AND mmt.ORGANIZATION_ID=Org_id

Line 2160: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
2164: AND mmt.ORGANIZATION_ID=Org_id

Line 2189: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
2193: AND mmt1.ORGANIZATION_ID=Org_id

Line 2464: MTL_TRANSACTION_LOT_NUMBERS mtln

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
2468: AND mmt.ORGANIZATION_ID=Org_id

Line 2512: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
2516: AND mmt.ORGANIZATION_ID=Org_id

Line 2783: MTL_TRANSACTION_LOT_NUMBERS mtln

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
2787: AND mmt.ORGANIZATION_ID=Org_id

Line 2851: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
2855: AND mmt.ORGANIZATION_ID=Org_id

Line 2970: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
2974: AND mmt.ORGANIZATION_ID=Org_id

Line 3004: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
3008: AND mmt1.ORGANIZATION_ID=Org_id

Line 3286: MTL_TRANSACTION_LOT_NUMBERS mtln

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
3290: AND mmt.ORGANIZATION_ID=Org_id

Line 3356: MTL_TRANSACTION_LOT_NUMBERS mtln,

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
3360: AND mmt.ORGANIZATION_ID=Org_id