View: RCV_SHIPMENT_HEADERS_MRC_V

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

View Text

SELECT PO.SHIPMENT_HEADER_ID
, MC.CONVERSION_RATE_TYPE
, MC.CONVERSION_DATE
, MC.CONVERSION_RATE
, INVOICE_AMOUNT
, TAX_AMOUNT
, FREIGHT_AMOUNT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RECEIPT_SOURCE_CODE
, VENDOR_ID
, VENDOR_SITE_ID
, ORGANIZATION_ID
, SHIPMENT_NUM
, RECEIPT_NUM
, SHIP_TO_LOCATION_ID
, BILL_OF_LADING
, PACKING_SLIP
, SHIPPED_DATE
, FREIGHT_CARRIER_CODE
, EXPECTED_RECEIPT_DATE
, EMPLOYEE_ID
, NUM_OF_CONTAINERS
, WAYBILL_AIRBILL_NUM
, COMMENTS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ASN_TYPE
, INVOICE_NUM
, INVOICE_DATE
, TAX_NAME
, CURRENCY_CODE
, PAYMENT_TERMS_ID
, INVOICE_STATUS_CODE
, EDI_CONTROL_NUM
, NOTICE_CREATION_DATE
, GROSS_WEIGHT
, GROSS_WEIGHT_UOM_CODE
, NET_WEIGHT
, NET_WEIGHT_UOM_CODE
, TAR_WEIGHT
, TAR_WEIGHT_UOM_CODE
, PACKAGING_CODE
, CARRIER_METHOD
, CARRIER_EQUIPMENT
, CARRIER_EQUIPMENT_NUM
, CARRIER_EQUIPMENT_ALPHA
, SPECIAL_HANDLING_CODE
, HAZARD_CODE
, HAZARD_CLASS
, HAZARD_DESCRIPTION
, FREIGHT_TERMS
, FREIGHT_BILL_NUMBER
, ASN_STATUS
, MRC_CONVERSION_RATE_TYPE
, MRC_CONVERSION_DATE
, MRC_CONVERSION_RATE
, SHIP_TO_ORG_ID
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, PO.REMIT_TO_SITE_ID
FROM RCV_SHIPMENT_HEADERS PO
, RCV_MC_SHIPMENT_HEADERS MC
WHERE PO.SHIPMENT_HEADER_ID = MC.SHIPMENT_HEADER_ID
AND MC.SET_OF_BOOKS_ID = NVL (TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10))
, -99)

Columns