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.WIP_AUTOLOTPROC_PRIV dependencies on MTL_LOT_NUMBERS

Line 1065: mtl_lot_numbers mln

1061: max(mln.expiration_date),
1062: abs(round(sum(tln.primary_quantity), wip_constants.max_displayed_precision))
1063: from mtl_transaction_lot_numbers tln,
1064: mtl_material_transactions mmt,
1065: mtl_lot_numbers mln
1066: where tln.organization_id = p_orgID
1067: and tln.transaction_source_id = p_wipEntityID
1068: and tln.transaction_source_type_id = 5
1069: and tln.inventory_item_id = v_itemID

Line 1088: mtl_lot_numbers mln

1084: max(mln.expiration_date),
1085: abs(round(sum(tln.primary_quantity), wip_constants.max_displayed_precision))
1086: from mtl_transaction_lot_numbers tln,
1087: mtl_material_transactions mmt,
1088: mtl_lot_numbers mln
1089: where tln.organization_id = p_orgID
1090: and tln.transaction_source_id = p_wipEntityID
1091: and tln.transaction_source_type_id = 5
1092: and tln.inventory_item_id = v_itemID

Line 1299: from mtl_lot_numbers mln,

1295: v_supplyLocID NUMBER,
1296: v_revision VARCHAR2) is
1297: select moq.lot_number,
1298: min(mln.expiration_date)
1299: from mtl_lot_numbers mln,
1300: mtl_onhand_quantities_detail moq
1301: where moq.inventory_item_id = v_itemID
1302: and moq.organization_id = p_orgID
1303: and moq.subinventory_code = v_supplySubinv

Line 1319: from mtl_lot_numbers mln,

1315: v_supplyLocID NUMBER,
1316: v_revision VARCHAR2) is
1317: select moq.lot_number,
1318: min(mln.expiration_date)
1319: from mtl_lot_numbers mln,
1320: mtl_onhand_quantities_detail moq
1321: where moq.inventory_item_id = v_itemID
1322: and moq.organization_id = p_orgID
1323: and moq.subinventory_code = v_supplySubinv

Line 1343: mtl_lot_numbers mln ,

1339: v_supplyLocID NUMBER,
1340: v_revision VARCHAR2) is
1341: select tln.lot_number
1342: from mtl_transaction_lot_numbers tln ,
1343: mtl_lot_numbers mln ,
1344: mtl_onhand_quantities_detail moq
1345: where tln.transaction_date =
1346: ( select max(transaction_date)
1347: from mtl_material_transactions

Line 2290: mtl_lot_numbers mln

2286: mtln.primary_quantity * -1 lot_qty
2287: FROM mtl_object_genealogy mog,
2288: mtl_material_transactions mmt,
2289: mtl_transaction_lot_numbers mtln,
2290: mtl_lot_numbers mln
2291: WHERE mog.object_id = mln.gen_object_id
2292: AND mog.end_date_active IS NULL
2293: AND mog.parent_object_id = p_parentObjID
2294: AND mtln.inventory_item_id = p_item.inventory_item_id

Line 2414: mtl_lot_numbers mln

2410: SELECT mmt.revision revision
2411: FROM mtl_object_genealogy mog,
2412: mtl_material_transactions mmt,
2413: mtl_transaction_lot_numbers mtln,
2414: mtl_lot_numbers mln
2415: WHERE mog.object_id = mln.gen_object_id
2416: AND mog.end_date_active IS NULL
2417: AND mog.parent_object_id = p_parentObjID
2418: AND mtln.inventory_item_id = p_item.inventory_item_id