VIEW: APPS.POBV_INBOUND_SHIPMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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