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 MFG_LOOKUPS

Line 65: mfg_lookups ml,

61: sum(1),
62: cratio*sum(abs(mmt.primary_quantity)),
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)

Line 435: mfg_lookups ml,

431: sum(abs(mmt.primary_quantity)),
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)

Line 481: mfg_lookups ml,

477: sum(abs(mmt.primary_quantity)),
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)

Line 853: mfg_lookups ml

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)
857: and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)

Line 1123: mfg_lookups ml,

1119: sum(abs(mmt.primary_quantity)),
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)

Line 1465: mfg_lookups ml,

1461: sum(abs(mmt.primary_quantity)),
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)