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

Line 1223: -- the mtl_lot_numbers table from the mtl_transactions_lot_temp. So for misc.receipts into

1219: -- For transactions based on mmtt
1220: -- obtain item and lot information from mmtt and mtlt
1221: -- Fix bug 2308273: Miscellaneous receipt(13) is calling label printing through TM
1222: -- but when label printing is called, the TM has not processed the LOT information into
1223: -- the mtl_lot_numbers table from the mtl_transactions_lot_temp. So for misc.receipts into
1224: -- a new lot, the lot number detailed information is taken from the mtl_transactions_lot_temp
1225: -- since the mtl_lot_numbers doesn't have the Lot number yet.
1226: CURSOR mmtt_material_receipt_cur IS
1227: SELECT mmtt.inventory_item_id

Line 1225: -- since the mtl_lot_numbers doesn't have the Lot number yet.

1221: -- Fix bug 2308273: Miscellaneous receipt(13) is calling label printing through TM
1222: -- but when label printing is called, the TM has not processed the LOT information into
1223: -- the mtl_lot_numbers table from the mtl_transactions_lot_temp. So for misc.receipts into
1224: -- a new lot, the lot number detailed information is taken from the mtl_transactions_lot_temp
1225: -- since the mtl_lot_numbers doesn't have the Lot number yet.
1226: CURSOR mmtt_material_receipt_cur IS
1227: SELECT mmtt.inventory_item_id
1228: , mmtt.organization_id
1229: , mtlt.lot_number

Line 1876: , mtl_lot_numbers mln

1872: , l_subinventory_code subinventory_code
1873: , wilk.concatenated_segments LOCATOR
1874: -- milk.concatenated_segments LOCATOR -- Modified for bug # 5015415
1875: FROM mtl_system_items_vl msik --Bug 5302715 changed from kfv to vl
1876: , mtl_lot_numbers mln
1877: , mtl_material_statuses_vl mmsvl
1878: , po_hazard_classes poh
1879: , mtl_parameters mp
1880: /*Commented for bug# 6334460 start

Line 2584: -- the mtl_lot_numbers table from the mtl_transactions_lot_temp. So for misc.receipts into

2580: -- CLOSE wdd_material_cur;
2581: END IF;
2582: -- Fix bug 2308273: Miscellaneous receipt(13) is calling label printing through TM
2583: -- but when label printing is called, the TM has not processed the LOT information into
2584: -- the mtl_lot_numbers table from the mtl_transactions_lot_temp. So for misc.receipts into
2585: -- a new lot, the lot number detailed information is taken from the mtl_transactions_lot_temp.
2586:
2587: -- Bug 3823140, For WIP Completion(26), it also needs to get the new lot information from MTLT. Therefore, it also uses cursor mmtt_material_receipt_cur.
2588: -- Commented out the use of wip_material_cur