VIEW: APPS.RCV_SHIPMENT_HEADERS_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)