DBA Data[Home] [Help]

APPS.INV_CR_ASN_DETAILS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 650: from wms_license_plate_numbers wlpn

646: For c_lpn_actual
647: in (
648: select wlpn.license_plate_number,
649: wlpn.lpn_id
650: from wms_license_plate_numbers wlpn
651: where wlpn.lpn_id = p_rcv_transaction_rec.lpn_id
652: )
653: Loop
654:

Line 983: wms_license_plate_numbers wlpn

979: wlpc.quantity,
980: wlpc.lot_number,
981: wlpn.lpn_id
982: from wms_lpn_contents wlpc,
983: wms_license_plate_numbers wlpn
984: where wlpc.parent_lpn_id = wlpn.lpn_id
985: and wlpn.source_header_id = p_interface_transaction_rec.shipment_header_id
986: and wlpc.inventory_item_id = p_interface_transaction_rec.item_id
987: order by wlpn.license_plate_number, wlpc.lot_number