FND Design Data [Home] [Help]

View: POBV_INBOUND_SHIPMENTS

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.POBV_INBOUND_SHIPMENTS
View Text

SELECT SH.SHIPMENT_HEADER_ID
, SH.SHIPMENT_NUM
, SH.RECEIPT_NUM
, SH.EXPECTED_RECEIPT_DATE
, SH.SHIPPED_DATE
, '_LA:SH.RECEIPT_SOURCE_CODE:PO_LOOKUP_CODES:SHIPMENT SOURCE TYPE:DISPLAYED_FIELD'
, SH.ASN_TYPE
, SH.CONVERSION_RATE
, SH.CONVERSION_DATE
, SH.COMMENTS
, SH.NUM_OF_CONTAINERS
, SH.BILL_OF_LADING
, SH.WAYBILL_AIRBILL_NUM
, SH.FREIGHT_AMOUNT
, SH.INVOICE_STATUS_CODE
, SH.INVOICE_AMOUNT
, SH.INVOICE_DATE
, SH.INVOICE_NUM
, SH.TAX_AMOUNT
, SH.TAX_NAME
, SH.EDI_CONTROL_NUM
, SH.NOTICE_CREATION_DATE
, SH.PACKING_SLIP
, SH.GROSS_WEIGHT
, SH.NET_WEIGHT
, SH.USSGL_TRANSACTION_CODE
, SH.VENDOR_ID
, SH.ORGANIZATION_ID
, SH.SHIP_TO_LOCATION_ID
, SH.CURRENCY_CODE
, SH.CONVERSION_RATE_TYPE
, SH.GROSS_WEIGHT_UOM_CODE
, SH.NET_WEIGHT_UOM_CODE
, SH.FREIGHT_CARRIER_CODE
, SH.EMPLOYEE_ID
, SH.PAYMENT_TERMS_ID
, SH.CREATION_DATE
, SH.CREATED_BY
, SH.LAST_UPDATE_DATE
, SH.LAST_UPDATED_BY
FROM RCV_SHIPMENT_HEADERS SH WITH READ ONLY

Columns

Name
SHIPMENT_ID
SHIPMENT_NUMBER
RECEIPT_NUMBER
EXPECTED_RECEIPT_DATE
SHIPPING_DATE
"_LA:SHIPMENT_SOURCE"
ASN_TYPE
CURRENCY_CONVERSION_RATE
CURRENCY_CONVERSION_RATE_DATE
COMMENTS
CONTAINER_QUANTITY
BILL_OF_LADING_NUMBER
WAYBILL_AIRBILL_NUMBER
FREIGHT_AMOUNT
INVOICE_STATUS
INVOICE_AMOUNT
INVOICE_DATE
INVOICE_NUMBER
TAX_AMOUNT
TAX_NAME
EDI_TXN_CONTROL_NUMBER
EDI_TXN_CREATION_DATE
PACKING_SLIP_NUMBER
SHIPMENT_GROSS_WEIGHT
SHIPMENT_NET_WEIGHT
USSGL_TRANSACTION_CODE
SUPPLIER_ID
SOURCE_ORGANIZATION_ID
SHIP_TO_LOCATION_ID
CURRENCY_CODE
CURRENCY_CONVERSION_RATE_TYPE
GROSS_WEIGHT_UNIT_OF_MEASURE
NET_WEIGHT_UNIT_OF_MEASURE
CARRIER
RECEIVER_ID
PAYMENT_TERMS_ID
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY