FND Design Data [Home] [Help]

View: POBV_INBOUND_SHIPMENT_LINES

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.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

Name
SHIPMENT_LINE_ID
LINE_NUMBER
RECEIVED_QUANTITY
SHIPPED_QUANTITY
EDI_UNIT_PRICE
SHIPMENT_UNIT_PRICE
ITEM_DESCRIPTION
COMMENTS
SHIPMENT_LINE_STATUS
"_LA:ASN_LINE_FLAG"
BAR_CODE_LABEL
CONTAINER_NUMBER
"_LA:DESTINATION_TYPE"
PACKING_SLIP_NUMBER
"_LA:SOURCE_DOCUMENT_TYPE"
SUPPLIER_ITEM_NUMBER
SUPPLIER_LOT_NUMBER
SUPPLIER_SHIPPED_QUANTITY
TRANSFER_COST
TRANSFER_PERCENTAGE
TRUCK_NUMBER
TRANSACTION_REASON_NAME
USSGL_TRANSACTION_CODE
SHIPMENT_ID
ITEM_ID
ITEM_REVISION
CATEGORY_ID
PURCHASE_ORDER_ID
PO_RELEASE_ID
PO_LINE_ID
PO_SHIPMENT_ID
PO_DISTRIBUTION_ID
REQUISITION_LINE_ID
REQ_DISTRIBUTION_ID
RECEIVING_ROUTING_ID
SOURCE_ORGANIZATION_ID
DESTINATION_ORGANIZATION_ID
DESTINATION_SUBINVENTORY
DELIVER_TO_LOCATION_ID
DELIVER_TO_PERSON_ID
SHIP_TO_LOCATION_ID
CHARGE_ACCOUNT_ID
TRANSPORTATION_ACCOUNT_ID
SHIPMENT_UNIT_OF_MEASURE
PRIMARY_UNIT_OF_MEASURE
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY
SECONDARY_QUANTITY_SHIPPED
SECONDARY_QUANTITY_RECEIVED
SECONDARY_UNIT_OF_MEASURE
QC_GRADE