DBA Data[Home] [Help]

APPS.WMS_OVERPICK dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 75: FROM mtl_material_transactions_temp

71:
72: -- get input parameters for quantity tree
73: SELECT organization_id, subinventory_code, locator_id, inventory_item_id, revision, lot_number
74: INTO l_org_id, l_sub, l_loc_id, l_item_id, l_revision, l_lot
75: FROM mtl_material_transactions_temp
76: WHERE transaction_temp_id = p_temp_id;
77:
78: SELECT lot_control_code, revision_qty_control_code, serial_number_control_code, primary_uom_code
79: INTO l_lot_control_code, l_revision_qty_control_code, l_serial_number_control_code, l_primary_uom