View: AR_XML_INVOICE_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_XML_INVOICE_V

View Text

SELECT D.DOCUMENT_TRANSFER_ID DOCUMENT_TRANSFER_ID
, H.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, H.TERM_ID TERM_ID
, (SELECT SUM(EXTENDED_AMOUNT)
FROM RA_CUSTOMER_TRX_LINES L
WHERE L.CUSTOMER_TRX_ID = H.CUSTOMER_TRX_ID) AMOUNT
, H.INVOICE_CURRENCY_CODE CURRENCY_CODE
, H.TRX_DATE TRX_DATE
, H.TRX_NUMBER TRX_NUMBER
, NVL(H.PURCHASE_ORDER
, 'N/A') PO_NUMBER
, T.TYPE DOCUMENT_TYPE
, RM.PAYMENT_TYPE_CODE PAYMENT_METHOD
, ORG.NAME SUPPLIER_NAME
, LOC.ECE_TP_LOCATION_CODE SUPPLIER_CODE
, SR.NAME SALESREP
, SR.EMAIL_ADDRESS SALESREP_EMAIL
, TO_CHAR(D.DOCUMENT_TRANSFER_ID) ||':'|| TO_CHAR(H.CUSTOMER_TRX_ID) REFERENCE_NUMBER
, H.SHIP_DATE_ACTUAL SHIP_DATE
, (SELECT SUM(NVL(EXTENDED_AMOUNT
, 0))
FROM RA_CUSTOMER_TRX_LINES L
WHERE L.LINE_TYPE = 'TAX' AND L.CUSTOMER_TRX_ID = H.CUSTOMER_TRX_ID) TAX_AMOUNT
, H.SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, H.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, H.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, H.BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, H.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, H.BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID
, H.REMIT_TO_ADDRESS_ID REMIT_TO_ADDRESS_ID
, AR_XML_VIEW_FUNCTIONS.HEADER_FUNCTION1(H.CUSTOMER_TRX_ID) USER1
, AR_XML_VIEW_FUNCTIONS.HEADER_FUNCTION2(H.CUSTOMER_TRX_ID) USER2
, AR_XML_VIEW_FUNCTIONS.HEADER_FUNCTION3(H.CUSTOMER_TRX_ID) USER3
, AR_XML_VIEW_FUNCTIONS.HEADER_FUNCTION4(H.CUSTOMER_TRX_ID) USER4
, AR_XML_VIEW_FUNCTIONS.HEADER_FUNCTION5(H.CUSTOMER_TRX_ID) USER5
, AR_XML_VIEW_FUNCTIONS.HEADER_FUNCTION6(H.CUSTOMER_TRX_ID) USER6
, AR_XML_VIEW_FUNCTIONS.HEADER_FUNCTION7(H.CUSTOMER_TRX_ID) USER7
, AR_XML_VIEW_FUNCTIONS.HEADER_FUNCTION8(H.CUSTOMER_TRX_ID) USER8
, AR_XML_VIEW_FUNCTIONS.HEADER_FUNCTION9(H.CUSTOMER_TRX_ID) USER9
, AR_XML_VIEW_FUNCTIONS.HEADER_FUNCTION10(H.CUSTOMER_TRX_ID) USER10
, LOC.DESCRIPTION SUPPLIER_DESCRIPTION
, LOC.ADDRESS_LINE_1 SUPPLIER_ADDRESS_LINE_1
, LOC.ADDRESS_LINE_2 SUPPLIER_ADDRESS_LINE_2
, LOC.ADDRESS_LINE_3 SUPPLIER_ADDRESS_LINE_3
, LOC.TOWN_OR_CITY SUPPLIER_TOWN_OR_CITY
, LOC.COUNTRY SUPPLIER_COUNTRY
, LOC.REGION_1 SUPPLIER_REGION1
, LOC.REGION_2 SUPPLIER_REGION2
, LOC.REGION_3 SUPPLIER_REGION3
, LOC.POSTAL_CODE SUPPLIER_POSTAL_CODE
, LOC.TELEPHONE_NUMBER_1 SUPPLIER_TELEPHONE_NUMBER_1
, LOC.TELEPHONE_NUMBER_2 SUPPLIER_TELEPHONE_NUMBER_2
, LOC.TELEPHONE_NUMBER_3 SUPPLIER_TELEPHONE_NUMBER_3
, OF_SHIP_VIA.FREIGHT_CODE FREIGHT_CODE
, OF_SHIP_VIA.DESCRIPTION FREIGHT_DESCRIPTION
, H.WAYBILL_NUMBER WAYBILL_NUMBER
FROM AR_DOCUMENT_TRANSFERS D
, RA_CUSTOMER_TRX H
, RA_CUST_TRX_TYPES T
, AR_RECEIPT_METHODS RM
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_LOCATIONS LOC
, RA_SALESREPS SR
, ORG_FREIGHT OF_SHIP_VIA
, OE_SYSTEM_PARAMETERS OS
WHERE D.SOURCE_ID = H.CUSTOMER_TRX_ID
AND H.CUST_TRX_TYPE_ID = T.CUST_TRX_TYPE_ID AND H.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID(+)
AND ORG.ORGANIZATION_ID = H.ORG_ID
AND ORG.LOCATION_ID = LOC.LOCATION_ID(+)
AND H.PRIMARY_SALESREP_ID = SR.SALESREP_ID(+)
AND H.SHIP_VIA = OF_SHIP_VIA.FREIGHT_CODE(+)
AND NVL(OF_SHIP_VIA.ORGANIZATION_ID
, OS.MASTER_ORGANIZATION_ID) = OS.MASTER_ORGANIZATION_ID

Columns