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.INVTVTUS dependencies on MTL_TRANSACTION_TYPES

Line 67: mtl_transaction_types mtt

63: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
64: from mtl_material_transactions mmt,
65: mfg_lookups ml,
66: mtl_txn_source_types mtst,
67: mtl_transaction_types mtt
68: where mmt.inventory_item_id = invid
69: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
70: and mmt.organization_id = orgid
71: and mmt.transaction_date >= NVL(sdate,mmt.transaction_date - 1)

Line 436: mtl_transaction_types mtt

432: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
433: from mtl_material_transactions mmt,
434: mtl_txn_source_types mtst,
435: mfg_lookups ml,
436: mtl_transaction_types mtt
437: where mmt.organization_id = orgid
438: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
439: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
440: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)

Line 482: mtl_transaction_types mtt

478: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
479: from mtl_material_transactions mmt,
480: mtl_txn_source_types mtst,
481: mfg_lookups ml,
482: mtl_transaction_types mtt
483: where mmt.organization_id = orgid
484: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
485: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
486: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)

Line 852: mtl_transaction_types mtt,

848: cratio*sum(abs(mmt.primary_quantity)),
849: round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
850: from mtl_material_transactions mmt,
851: mtl_txn_source_types mtst,
852: mtl_transaction_types mtt,
853: mfg_lookups ml
854: where mmt.inventory_item_id = invid
855: and mmt.organization_id = orgid
856: and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)

Line 1124: mtl_transaction_types mtt

1120: sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
1121: from mtl_material_transactions mmt,
1122: mtl_txn_source_types mtst,
1123: mfg_lookups ml,
1124: mtl_transaction_types mtt
1125: where mmt.organization_id = orgid
1126: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
1127: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
1128: and mmt.cost_group_id = cost_group_id

Line 1466: mtl_transaction_types mtt

1462: sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
1463: from mtl_material_transactions mmt,
1464: mtl_txn_source_types mtst,
1465: mfg_lookups ml,
1466: mtl_transaction_types mtt
1467: where mmt.organization_id = orgid
1468: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
1469: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
1470: and mmt.cost_group_id = cost_group_id