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_ACCOUNTS

Line 74: MTL_TRANSACTION_ACCOUNTS mta

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
78: AND msi.LOT_CONTROL_CODE = 1

Line 102: MTL_TRANSACTION_ACCOUNTS mta

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

Line 418: MTL_TRANSACTION_ACCOUNTS mta

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
422: AND msi.LOT_CONTROL_CODE = 1

Line 445: MTL_TRANSACTION_ACCOUNTS mta

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

Line 734: MTL_TRANSACTION_ACCOUNTS mta

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
738: AND msi.LOT_CONTROL_CODE = 1

Line 761: MTL_TRANSACTION_ACCOUNTS mta

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

Line 1062: MTL_TRANSACTION_ACCOUNTS mta

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
1066: AND msi.LOT_CONTROL_CODE = 1

Line 1093: MTL_TRANSACTION_ACCOUNTS mta

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

Line 1383: MTL_TRANSACTION_ACCOUNTS mta

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
1387: AND msi.LOT_CONTROL_CODE = 1

Line 1410: MTL_TRANSACTION_ACCOUNTS mta

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

Line 1700: MTL_TRANSACTION_ACCOUNTS mta

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
1704: AND msi.LOT_CONTROL_CODE = 1

Line 1728: MTL_TRANSACTION_ACCOUNTS mta

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

Line 2026: MTL_TRANSACTION_ACCOUNTS mta

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
2030: AND msi.LOT_CONTROL_CODE = 1

Line 2053: MTL_TRANSACTION_ACCOUNTS mta

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

Line 2090: MTL_TRANSACTION_ACCOUNTS mta

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
2094: AND msi.LOT_CONTROL_CODE = 1

Line 2116: MTL_TRANSACTION_ACCOUNTS mta

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
2120: AND msi.LOT_CONTROL_CODE = 1

Line 2161: MTL_TRANSACTION_ACCOUNTS mta

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
2165: AND mmt.TRANSACTION_ID = mtln.TRANSACTION_ID

Line 2190: MTL_TRANSACTION_ACCOUNTS mta

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
2194: AND mmt1.TRANSACTION_ID = mtln.TRANSACTION_ID

Line 2487: MTL_TRANSACTION_ACCOUNTS mta

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
2491: AND msi.LOT_CONTROL_CODE = 1

Line 2513: MTL_TRANSACTION_ACCOUNTS mta

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

Line 2818: MTL_TRANSACTION_ACCOUNTS mta

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
2822: AND msi.LOT_CONTROL_CODE = 1

Line 2852: MTL_TRANSACTION_ACCOUNTS mta

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

Line 2895: MTL_TRANSACTION_ACCOUNTS mta

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
2899: AND msi.LOT_CONTROL_CODE = 1

Line 2926: MTL_TRANSACTION_ACCOUNTS mta

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
2930: AND msi.LOT_CONTROL_CODE = 1

Line 2971: MTL_TRANSACTION_ACCOUNTS mta

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
2975: AND mmt.TRANSACTION_ID = mtln.TRANSACTION_ID

Line 3005: MTL_TRANSACTION_ACCOUNTS mta

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
3009: AND mmt1.TRANSACTION_ID = mtln.TRANSACTION_ID

Line 3320: MTL_TRANSACTION_ACCOUNTS mta

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
3324: AND msi.LOT_CONTROL_CODE = 1

Line 3357: MTL_TRANSACTION_ACCOUNTS mta

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