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 1071: mtl_lot_numbers mln

1067: max(mln.expiration_date),
1068: abs(round(sum(tln.primary_quantity), wip_constants.max_displayed_precision))
1069: from mtl_transaction_lot_numbers tln,
1070: mtl_material_transactions mmt,
1071: mtl_lot_numbers mln
1072: where tln.organization_id = p_orgID
1073: and tln.transaction_source_id = p_wipEntityID
1074: and tln.transaction_source_type_id = 5
1075: and tln.inventory_item_id = v_itemID

Line 1094: mtl_lot_numbers mln

1090: max(mln.expiration_date),
1091: abs(round(sum(tln.primary_quantity), wip_constants.max_displayed_precision))
1092: from mtl_transaction_lot_numbers tln,
1093: mtl_material_transactions mmt,
1094: mtl_lot_numbers mln
1095: where tln.organization_id = p_orgID
1096: and tln.transaction_source_id = p_wipEntityID
1097: and tln.transaction_source_type_id = 5
1098: and tln.inventory_item_id = v_itemID

Line 1308: from mtl_lot_numbers mln,

1304: v_supplyLocID NUMBER,
1305: v_revision VARCHAR2) is
1306: select moq.lot_number,
1307: min(mln.expiration_date)
1308: from mtl_lot_numbers mln,
1309: mtl_onhand_quantities_detail moq
1310: where moq.inventory_item_id = v_itemID
1311: and moq.organization_id = p_orgID
1312: and moq.subinventory_code = v_supplySubinv

Line 1328: from mtl_lot_numbers mln,

1324: v_supplyLocID NUMBER,
1325: v_revision VARCHAR2) is
1326: select moq.lot_number,
1327: min(mln.expiration_date)
1328: from mtl_lot_numbers mln,
1329: mtl_onhand_quantities_detail moq
1330: where moq.inventory_item_id = v_itemID
1331: and moq.organization_id = p_orgID
1332: and moq.subinventory_code = v_supplySubinv

Line 1352: mtl_lot_numbers mln ,

1348: v_supplyLocID NUMBER,
1349: v_revision VARCHAR2) is
1350: select tln.lot_number
1351: from mtl_transaction_lot_numbers tln ,
1352: mtl_lot_numbers mln ,
1353: mtl_onhand_quantities_detail moq
1354: where tln.transaction_date =
1355: ( select max(transaction_date)
1356: from mtl_material_transactions

Line 2361: mtl_lot_numbers mln

2357: mtln.primary_quantity * -1 lot_qty
2358: FROM mtl_object_genealogy mog,
2359: mtl_material_transactions mmt,
2360: mtl_transaction_lot_numbers mtln,
2361: mtl_lot_numbers mln
2362: WHERE mog.object_id = mln.gen_object_id
2363: AND mog.end_date_active IS NULL
2364: AND mog.parent_object_id = p_parentObjID
2365: AND mtln.inventory_item_id = p_item.inventory_item_id

Line 2485: mtl_lot_numbers mln

2481: SELECT mmt.revision revision
2482: FROM mtl_object_genealogy mog,
2483: mtl_material_transactions mmt,
2484: mtl_transaction_lot_numbers mtln,
2485: mtl_lot_numbers mln
2486: WHERE mog.object_id = mln.gen_object_id
2487: AND mog.end_date_active IS NULL
2488: AND mog.parent_object_id = p_parentObjID
2489: AND mtln.inventory_item_id = p_item.inventory_item_id