APPS.OPIMPXWI dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1274: MTL_TRANSACTION_LOT_NUMBERS mtln

1270: mmt.LOCATOR_ID,
1271: sum(mtln.PRIMARY_QUANTITY)
1272: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1273: MTL_SYSTEM_ITEMS msi,
1274: MTL_TRANSACTION_LOT_NUMBERS mtln
1275: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1276: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1277: AND mmt.ORGANIZATION_ID=Org_id
1278: AND msi.LOT_CONTROL_CODE = 2

Line 1995: MTL_TRANSACTION_LOT_NUMBERS mtln,

1991: decode(msi.LOT_CONTROL_CODE,2,nvl(mtln.LOT_NUMBER,'-99'),NULL) LOT_NUMBER, --bug 4561628 Forward ported
1992: mmt.SUBINVENTORY_CODE,
1993: mmt.LOCATOR_ID
1994: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1995: MTL_TRANSACTION_LOT_NUMBERS mtln,
1996: mtl_system_items msi
1997: WHERE mmt.ORGANIZATION_ID=Org_id
1998: AND mmt.transaction_date >= Trunc(p_from_date)
1999: AND mmt.transaction_id = mtln.transaction_id (+)

Line 2112: MTL_TRANSACTION_LOT_NUMBERS mtln

2108: -- mochawla 10/29/2003. filtered out logical transactions from net quantity
2109: SELECT sum(mtln.primary_quantity)
2110: INTO net_transacted_quantity
2111: FROM mtl_material_transactions mmt,
2112: MTL_TRANSACTION_LOT_NUMBERS mtln
2113: WHERE mmt.INVENTORY_ITEM_ID = l_item_id
2114: AND mmt.ORGANIZATION_ID = Org_id
2115: AND Nvl(mmt.subinventory_code,-999) = Nvl(l_subinventory,-999)
2116: AND nvl(REVISION,-999) = nvl(l_revision,-999)

Line 2134: MTL_TRANSACTION_LOT_NUMBERS mtln

2130: -- mochawla 10/29/2003. filtered out logical transactions from quantity
2131: SELECT sum(mtln.primary_quantity)
2132: INTO from_date_transacted_quantity
2133: FROM mtl_material_transactions mmt,
2134: MTL_TRANSACTION_LOT_NUMBERS mtln
2135: WHERE mmt.INVENTORY_ITEM_ID = l_item_id
2136: AND mmt.ORGANIZATION_ID = Org_id
2137: AND Nvl(mmt.subinventory_code,-999) = Nvl(l_subinventory,-999)
2138: AND nvl(REVISION,-999) = nvl(l_revision,-999)