DBA Data[Home] [Help]

APPS.WMS_CROSS_DOCK_PVT dependencies on MTL_SYSTEM_ITEMS

Line 177: mtl_system_items msi,

173: mtrl.reference,
174: mtrl.reference_id,
175: mtrl.transaction_source_type_id
176: FROM mtl_txn_request_lines mtrl,
177: mtl_system_items msi,
178: mtl_units_of_measure muom
179: WHERE mtrl.lpn_id = l_lpn_id -- the MTRL is within the LPN
180: AND (mtrl.line_id = p_move_order_line_id OR p_move_order_line_id IS NULL)
181: AND mtrl.backorder_delivery_detail_id IS NULL -- this LPN has not crossdocked yet

Line 1391: mtl_system_items i

1387: l_loc,l_rev,l_transaction_type_id,
1388: l_transfer_lpn_id,l_cnt_lpn_id,l_prim_uom
1389: ,l_lot_control_code, l_serial_control_code
1390: FROM mtl_material_transactions_temp t,
1391: mtl_system_items i
1392: WHERE t.transaction_temp_id=l_temp_id
1393: AND t.organization_id=l_org_id
1394: AND t.organization_id =i.organization_id
1395: AND t.inventory_item_id=i.inventory_item_id;