View: POBV_INBOUND_SHIPMENT_LINES

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POBV_INBOUND_SHIPMENT_LINES

View Text

SELECT SL.SHIPMENT_LINE_ID
, SL.LINE_NUM
, SL.QUANTITY_RECEIVED
, SL.QUANTITY_SHIPPED
, SL.NOTICE_UNIT_PRICE
, SL.SHIPMENT_UNIT_PRICE
, SL.ITEM_DESCRIPTION
, SL.COMMENTS
, SL.SHIPMENT_LINE_STATUS_CODE
, '_LA:SL.ASN_LINE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, SL.BAR_CODE_LABEL
, SL.CONTAINER_NUM
, '_LA:SL.DESTINATION_TYPE_CODE:PO_LOOKUP_CODES:DESTINATION TYPE:DISPLAYED_FIELD'
, SL.PACKING_SLIP
, '_LA:SL.SOURCE_DOCUMENT_CODE:PO_LOOKUP_CODES:SHIPMENT SOURCE DOCUMENT TYPE:DISPLAYED_FIELD'
, SL.VENDOR_ITEM_NUM
, SL.VENDOR_LOT_NUM
, SL.VENDOR_CUM_SHIPPED_QUANTITY
, SL.TRANSFER_COST
, SL.TRANSFER_PERCENTAGE
, SL.TRUCK_NUM
, RE.REASON_NAME
, SL.USSGL_TRANSACTION_CODE
, SL.SHIPMENT_HEADER_ID
, SL.ITEM_ID
, SL.ITEM_REVISION
, SL.CATEGORY_ID
, SL.PO_HEADER_ID
, SL.PO_RELEASE_ID
, SL.PO_LINE_ID
, SL.PO_LINE_LOCATION_ID
, SL.PO_DISTRIBUTION_ID
, SL.REQUISITION_LINE_ID
, SL.REQ_DISTRIBUTION_ID
, SL.ROUTING_HEADER_ID
, SL.FROM_ORGANIZATION_ID
, SL.TO_ORGANIZATION_ID
, SL.TO_SUBINVENTORY
, SL.DELIVER_TO_LOCATION_ID
, SL.DELIVER_TO_PERSON_ID
, SL.SHIP_TO_LOCATION_ID
, SL.CHARGE_ACCOUNT_ID
, SL.TRANSPORTATION_ACCOUNT_ID
, SL.UNIT_OF_MEASURE
, SL.PRIMARY_UNIT_OF_MEASURE
, SL.CREATION_DATE
, SL.CREATED_BY
, SL.LAST_UPDATE_DATE
, SL.LAST_UPDATED_BY
, SL.SECONDARY_QUANTITY_SHIPPED
, SL.SECONDARY_QUANTITY_RECEIVED
, SL.SECONDARY_UNIT_OF_MEASURE
, SL.QC_GRADE
FROM RCV_SHIPMENT_LINES SL
, MTL_TRANSACTION_REASONS RE
WHERE SL.REASON_ID = RE.REASON_ID(+) WITH READ ONLY

Columns