APPS.WMS_CROSS_DOCK_PVT dependencies on MTL_SYSTEM_ITEMS

Line 403: mtl_system_items msi,

399: mtrl.reference,
400: mtrl.reference_id,
401: mtrl.transaction_source_type_id
402: FROM mtl_txn_request_lines mtrl,
403: mtl_system_items msi,
404: mtl_units_of_measure muom
405: WHERE mtrl.lpn_id = l_lpn_id -- the MTRL is within the LPN
406: AND (mtrl.line_id = p_move_order_line_id OR p_move_order_line_id IS NULL)
407: AND mtrl.backorder_delivery_detail_id IS NULL -- this LPN has not crossdocked yet

Line 1672: mtl_system_items i

1668: l_loc,l_rev,l_transaction_type_id,
1669: l_transfer_lpn_id,l_cnt_lpn_id,l_prim_uom
1670: ,l_lot_control_code, l_serial_control_code
1671: FROM mtl_material_transactions_temp t,
1672: mtl_system_items i
1673: WHERE t.transaction_temp_id=l_temp_id
1674: AND t.organization_id=l_org_id
1675: AND t.organization_id =i.organization_id
1676: AND t.inventory_item_id=i.inventory_item_id;