View: AR_TRX_REP_ITF_V

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

View Text

SELECT RX.ROWID ROW_ID
, RX.REQUEST_ID REQUEST_ID
, RX.CREATED_BY CREATED_BY
, RX.CREATION_DATE CREATION_DATE
, RX.LAST_UPDATED_BY LAST_UPDATED_BY
, RX.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RX.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RX.ORGANIZATION_NAME ORGANIZATION_NAME
, RX.FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, RX.TRX_NUMBER TRX_NUMBER
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('INV/CM'
, TRX_TYPES.TYPE) TRX_CLASS
, TRX_TYPES.NAME TRX_TYPE
, RX.CONS_BILL_NUMBER CONS_BILL_NUMBER
, RX.TRX_DATE TRX_DATE
, SUBSTRB(SHIP_TO_PARTY.PARTY_NAME
, 1
, 50) SHIP_TO_CUSTOMER_NAME
, DECODE(SHIP_TO_PARTY.PARTY_TYPE
, 'ORGANIZATION'
, SHIP_TO_PARTY.ORGANIZATION_NAME_PHONETIC
, NULL) SHIP_TO_CUSTOMER_NAME_PHONETIC
, SHIP_TO.ACCOUNT_NUMBER SHIP_TO_CUSTOMER_NUMBER
, SHIP_TO_SITE.LOCATION SHIP_TO_CUSTOMER_SITE
, SUBSTRB(BILL_TO_PARTY.PARTY_NAME
, 1
, 50) BILL_TO_CUSTOMER_NAME
, DECODE(BILL_TO_PARTY.PARTY_TYPE
, 'ORGANIZATION'
, BILL_TO_PARTY.ORGANIZATION_NAME_PHONETIC
, NULL) BILL_TO_CUSTOMER_NAME_PHONETIC
, BILL_TO.ACCOUNT_NUMBER BILL_TO_CUSTOMER_NUMBER
, BILL_TO_SITE.LOCATION BILL_TO_CUSTOMER_SITE
, RX.TRX_CURRENCY TRX_CURRENCY
, RX.EXCHANGE_RATE EXCHANGE_RATE
, RX.EXCHANGE_DATE EXCHANGE_DATE
, RX.EXCHANGE_TYPE EXCHANGE_TYPE
, RX.RECEIVABLES_GL_DATE RECEIVABLES_GL_DATE
, RX.REC_ACCOUNT REC_ACCOUNT
, RX.REC_ACCOUNT_DESC REC_ACCOUNT_DESC
, RX.REC_BALANCE REC_BALANCE
, RX.REC_BALANCE_DESC REC_BALANCE_DESC
, RX.REC_NATACCT REC_NATACCT
, RX.REC_NATACCT_DESC REC_NATACCT_DESC
, RX.REC_POSTABLE_FLAG REC_POSTABLE_FLAG
, TERMS.NAME PAYMENT_TERMS
, RX.TRX_DUE_DATE TRX_DUE_DATE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO'
, NVL(BILL_TO_SITE.TAX_HEADER_LEVEL_FLAG
, NVL(BILL_TO.TAX_HEADER_LEVEL_FLAG
, RX.TAX_HEADER_LEVEL_FLAG))) TAX_CALCULATION_LEVEL
, DOC_SEQ.NAME DOC_SEQUENCE_NAME
, RX.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, RX.TRX_AMOUNT TRX_AMOUNT
, RX.TRX_ACCTD_AMOUNT TRX_ACCTD_AMOUNT
, METHODS.NAME PAYMENT_METHOD
, BA.NAME BATCH_NAME
, BAS.NAME BATCH_SOURCE
FROM AR_TRANSACTIONS_REP_ITF RX
, RA_TERMS TERMS
, FND_DOCUMENT_SEQUENCES DOC_SEQ
, HZ_CUST_ACCOUNTS SHIP_TO
, HZ_PARTIES SHIP_TO_PARTY
, HZ_CUST_ACCOUNTS BILL_TO
, HZ_PARTIES BILL_TO_PARTY
, HZ_CUST_SITE_USES_ALL SHIP_TO_SITE
, HZ_CUST_SITE_USES_ALL BILL_TO_SITE
, RA_CUST_TRX_TYPES_ALL TRX_TYPES
, AR_RECEIPT_METHODS METHODS
, RA_BATCHES_ALL BA
, RA_BATCH_SOURCES_ALL BAS
WHERE RX.SHIP_TO_CUSTOMER_ID = SHIP_TO.CUST_ACCOUNT_ID(+)
AND SHIP_TO.PARTY_ID = SHIP_TO_PARTY.PARTY_ID(+) AND RX.SHIP_TO_SITE_USE_ID = SHIP_TO_SITE.SITE_USE_ID(+) AND RX.BILL_TO_CUSTOMER_ID = BILL_TO.CUST_ACCOUNT_ID
AND BILL_TO.PARTY_ID = BILL_TO_PARTY.PARTY_ID AND RX.BILL_TO_SITE_USE_ID = BILL_TO_SITE.SITE_USE_ID AND RX.CUST_TRX_TYPE_ID = TRX_TYPES.CUST_TRX_TYPE_ID AND RX.TERM_ID = TERMS.TERM_ID(+) AND RX.DOC_SEQUENCE_ID = DOC_SEQ.DOC_SEQUENCE_ID(+) AND RX.RECEIPT_METHOD_ID = METHODS.RECEIPT_METHOD_ID(+) AND NVL(RX.ORG_ID
, -99) = NVL(TRX_TYPES.ORG_ID
, -99) AND RX.BATCH_ID = BA.BATCH_ID(+)
AND RX.BATCH_SOURCE_ID = BAS.BATCH_SOURCE_ID(+)
AND NVL(RX.ORG_ID
, -99) = NVL(BAS.ORG_ID
, -99)

Columns