VIEW: APPS.RCV_RECEIPT_CONFIRMATION_HDR_V

Source

View Text - Preformatted

SELECT mp1.organization_code, mp2.organization_code, rsh.receipt_source_code, rsh.shipped_date, pov.vendor_name, pvs.vendor_site_code, hzp.party_name, hl.address1, hl.address2, hl.address3, hl.address4, hl.city, hl.province, hl.county, hl.postal_code, hl.state, hl.country, rt.transaction_date, rsh.shipment_header_id, rsh.last_update_date, rsh.last_updated_by, rsh.creation_date, rsh.created_by, rsh.last_update_login, rsh.vendor_id, rsh.vendor_site_id, rsh.organization_id, rsh.shipment_num, rsh.receipt_num, hre.full_name, rsh.ship_to_location_id, hrl.location_code, rsh.bill_of_lading, rsh.packing_slip, rsh.freight_carrier_code, rsh.expected_receipt_date, rsh.employee_id, rsh.num_of_containers, rsh.waybill_airbill_num, rsh.comments, rsh.attribute_category, rsh.attribute1, rsh.attribute2, rsh.attribute3, rsh.attribute4, rsh.attribute5, rsh.attribute6, rsh.attribute7, rsh.attribute8, rsh.attribute9, rsh.attribute10, rsh.attribute11, rsh.attribute12, rsh.attribute13, rsh.attribute14, rsh.attribute15, rsh.ussgl_transaction_code, rsh.government_context, rsh.request_id, rsh.program_application_id, rsh.program_id, rsh.program_update_date, rsh.asn_type, rsh.edi_control_num, rsh.notice_creation_date, rsh.gross_weight, rsh.gross_weight_uom_code, rsh.net_weight, rsh.net_weight_uom_code, rsh.tar_weight, rsh.tar_weight_uom_code, rsh.packaging_code, rsh.carrier_method, rsh.carrier_equipment, rsh.carrier_equipment_num, rsh.carrier_equipment_alpha, rsh.special_handling_code, rsh.hazard_code, rsh.hazard_class, rsh.hazard_description, rsh.freight_terms, rsh.freight_bill_number, rsh.invoice_num, rsh.invoice_date, rsh.invoice_amount, rsh.tax_name, rsh.tax_amount, rsh.freight_amount, rsh.invoice_status_code, rsh.asn_status, rsh.currency_code, rsh.conversion_rate_type, rsh.conversion_rate, rsh.conversion_date, rsh.payment_terms_id, rsh.mrc_conversion_rate_type, rsh.mrc_conversion_date, rsh.mrc_conversion_rate, rsh.ship_to_org_id, rsh.customer_id, rsh.customer_site_id, rsh.remit_to_site_id, rsh.ship_from_location_id, rsh.wf_item_type, rsh.wf_item_key, rsh.approval_status, rsh.performance_period_from, rsh.performance_period_to, rsh.request_date FROM mtl_parameters mp1, mtl_parameters mp2, rcv_shipment_headers rsh, rcv_transactions rt, po_vendors pov, hz_parties hzp, hz_cust_accounts hzca, hz_locations hl, hz_party_sites hzps, hz_cust_acct_sites_all hzcas, hz_cust_site_uses_all hzcsu, po_vendor_sites_all pvs, hr_employees hre, hr_locations_all hrl WHERE rsh.shipment_header_id = rt.shipment_header_id AND rsh.vendor_id = pov.vendor_id (+) AND rsh.vendor_site_id = pvs.vendor_site_id (+) AND rsh.ship_to_org_id = mp1.organization_id (+) AND rsh.organization_id = mp2.organization_id (+) AND rsh.ship_to_location_id = hrl.location_id (+) AND rsh.customer_id = hzca.cust_account_id (+) AND hzca.party_id = hzp.party_id (+) AND rsh.customer_site_id = hzcsu.site_use_id (+) AND hzcsu.cust_acct_site_id = hzcas.cust_acct_site_id (+) AND hzcas.party_site_id = hzps.party_site_id (+) AND hzps.location_id = hl.location_id (+) AND rsh.employee_id = hre.employee_id (+)

View Text - HTML Formatted

SELECT MP1.ORGANIZATION_CODE
, MP2.ORGANIZATION_CODE
, RSH.RECEIPT_SOURCE_CODE
, RSH.SHIPPED_DATE
, POV.VENDOR_NAME
, PVS.VENDOR_SITE_CODE
, HZP.PARTY_NAME
, HL.ADDRESS1
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, HL.CITY
, HL.PROVINCE
, HL.COUNTY
, HL.POSTAL_CODE
, HL.STATE
, HL.COUNTRY
, RT.TRANSACTION_DATE
, RSH.SHIPMENT_HEADER_ID
, RSH.LAST_UPDATE_DATE
, RSH.LAST_UPDATED_BY
, RSH.CREATION_DATE
, RSH.CREATED_BY
, RSH.LAST_UPDATE_LOGIN
, RSH.VENDOR_ID
, RSH.VENDOR_SITE_ID
, RSH.ORGANIZATION_ID
, RSH.SHIPMENT_NUM
, RSH.RECEIPT_NUM
, HRE.FULL_NAME
, RSH.SHIP_TO_LOCATION_ID
, HRL.LOCATION_CODE
, RSH.BILL_OF_LADING
, RSH.PACKING_SLIP
, RSH.FREIGHT_CARRIER_CODE
, RSH.EXPECTED_RECEIPT_DATE
, RSH.EMPLOYEE_ID
, RSH.NUM_OF_CONTAINERS
, RSH.WAYBILL_AIRBILL_NUM
, RSH.COMMENTS
, RSH.ATTRIBUTE_CATEGORY
, RSH.ATTRIBUTE1
, RSH.ATTRIBUTE2
, RSH.ATTRIBUTE3
, RSH.ATTRIBUTE4
, RSH.ATTRIBUTE5
, RSH.ATTRIBUTE6
, RSH.ATTRIBUTE7
, RSH.ATTRIBUTE8
, RSH.ATTRIBUTE9
, RSH.ATTRIBUTE10
, RSH.ATTRIBUTE11
, RSH.ATTRIBUTE12
, RSH.ATTRIBUTE13
, RSH.ATTRIBUTE14
, RSH.ATTRIBUTE15
, RSH.USSGL_TRANSACTION_CODE
, RSH.GOVERNMENT_CONTEXT
, RSH.REQUEST_ID
, RSH.PROGRAM_APPLICATION_ID
, RSH.PROGRAM_ID
, RSH.PROGRAM_UPDATE_DATE
, RSH.ASN_TYPE
, RSH.EDI_CONTROL_NUM
, RSH.NOTICE_CREATION_DATE
, RSH.GROSS_WEIGHT
, RSH.GROSS_WEIGHT_UOM_CODE
, RSH.NET_WEIGHT
, RSH.NET_WEIGHT_UOM_CODE
, RSH.TAR_WEIGHT
, RSH.TAR_WEIGHT_UOM_CODE
, RSH.PACKAGING_CODE
, RSH.CARRIER_METHOD
, RSH.CARRIER_EQUIPMENT
, RSH.CARRIER_EQUIPMENT_NUM
, RSH.CARRIER_EQUIPMENT_ALPHA
, RSH.SPECIAL_HANDLING_CODE
, RSH.HAZARD_CODE
, RSH.HAZARD_CLASS
, RSH.HAZARD_DESCRIPTION
, RSH.FREIGHT_TERMS
, RSH.FREIGHT_BILL_NUMBER
, RSH.INVOICE_NUM
, RSH.INVOICE_DATE
, RSH.INVOICE_AMOUNT
, RSH.TAX_NAME
, RSH.TAX_AMOUNT
, RSH.FREIGHT_AMOUNT
, RSH.INVOICE_STATUS_CODE
, RSH.ASN_STATUS
, RSH.CURRENCY_CODE
, RSH.CONVERSION_RATE_TYPE
, RSH.CONVERSION_RATE
, RSH.CONVERSION_DATE
, RSH.PAYMENT_TERMS_ID
, RSH.MRC_CONVERSION_RATE_TYPE
, RSH.MRC_CONVERSION_DATE
, RSH.MRC_CONVERSION_RATE
, RSH.SHIP_TO_ORG_ID
, RSH.CUSTOMER_ID
, RSH.CUSTOMER_SITE_ID
, RSH.REMIT_TO_SITE_ID
, RSH.SHIP_FROM_LOCATION_ID
, RSH.WF_ITEM_TYPE
, RSH.WF_ITEM_KEY
, RSH.APPROVAL_STATUS
, RSH.PERFORMANCE_PERIOD_FROM
, RSH.PERFORMANCE_PERIOD_TO
, RSH.REQUEST_DATE
FROM MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RT
, PO_VENDORS POV
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZCA
, HZ_LOCATIONS HL
, HZ_PARTY_SITES HZPS
, HZ_CUST_ACCT_SITES_ALL HZCAS
, HZ_CUST_SITE_USES_ALL HZCSU
, PO_VENDOR_SITES_ALL PVS
, HR_EMPLOYEES HRE
, HR_LOCATIONS_ALL HRL
WHERE RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID
AND RSH.VENDOR_ID = POV.VENDOR_ID (+)
AND RSH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID (+)
AND RSH.SHIP_TO_ORG_ID = MP1.ORGANIZATION_ID (+)
AND RSH.ORGANIZATION_ID = MP2.ORGANIZATION_ID (+)
AND RSH.SHIP_TO_LOCATION_ID = HRL.LOCATION_ID (+)
AND RSH.CUSTOMER_ID = HZCA.CUST_ACCOUNT_ID (+)
AND HZCA.PARTY_ID = HZP.PARTY_ID (+)
AND RSH.CUSTOMER_SITE_ID = HZCSU.SITE_USE_ID (+)
AND HZCSU.CUST_ACCT_SITE_ID = HZCAS.CUST_ACCT_SITE_ID (+)
AND HZCAS.PARTY_SITE_ID = HZPS.PARTY_SITE_ID (+)
AND HZPS.LOCATION_ID = HL.LOCATION_ID (+)
AND RSH.EMPLOYEE_ID = HRE.EMPLOYEE_ID (+)