VIEW: APPS.POBV_INBOUND_SHIPMENT_LINES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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