VIEW: APPS.ARBV_CREDIT_MEMO_ARS

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ CT.CUSTOMER_TRX_ID , /* REGULAR ATTRIBUTES */ CT.TRX_NUMBER , CT.DOC_SEQUENCE_VALUE , CT.TRX_DATE , CT.EXCHANGE_RATE , CT.EXCHANGE_RATE_TYPE , CT.EXCHANGE_DATE , '_LA:CT.COMPLETE_FLAG:AR_LOOKUPS:YES/NO:MEANING' , '_LA:CT.STATUS_TRX:AR_LOOKUPS:INVOICE_TRX_STATUS:MEANING' , CT.PURCHASE_ORDER , CT.PURCHASE_ORDER_DATE , CT.PURCHASE_ORDER_REVISION , CT.CUSTOMER_REFERENCE , '_LA:CT.FINANCE_CHARGES:AR_LOOKUPS:YES/NO:MEANING' , CT.TERM_DUE_DATE , '_LA:CT.DEFAULT_TAX_EXEMPT_FLAG:AR_LOOKUPS:TAX_CONTROL_FLAG:MEANING' , CT.SHIP_VIA , CT.SHIP_DATE_ACTUAL , CT.WAYBILL_NUMBER , '_LA:CT.FOB_POINT:AR_LOOKUPS:FOB:MEANING' , '_LA:CT.EDI_PROCESSED_FLAG:AR_LOOKUPS:YES/NO:MEANING' , CT.PRINTING_ORIGINAL_DATE , CT.PRINTING_LAST_PRINTED , '_LA:CT.PRINTING_PENDING:AR_LOOKUPS:YES/NO:MEANING' , CT.PRINTING_COUNT , CT.ORIG_SYSTEM_BATCH_NAME , /* IDS */ CT.BATCH_ID , CT.TERM_ID , CT.BILL_TO_CONTACT_ID , CT.SHIP_TO_CONTACT_ID , CT.SOLD_TO_CONTACT_ID , CT.BILL_TO_CUSTOMER_ID , CT.SHIP_TO_CUSTOMER_ID , CT.SOLD_TO_CUSTOMER_ID , CT.PAYING_CUSTOMER_ID , CT.PREVIOUS_CUSTOMER_TRX_ID , CT.CUST_TRX_TYPE_ID , CT.PRIMARY_SALESREP_ID , CT.BILL_TO_SITE_USE_ID , CT.SHIP_TO_SITE_USE_ID , CT.SOLD_TO_SITE_USE_ID , CT.PAYING_SITE_USE_ID , CT.REMIT_TO_ADDRESS_ID , CT.CUSTOMER_BANK_ACCOUNT_ID , CT.RECEIPT_METHOD_ID , CT.ORG_ID , /* WHO COLUMNS */ CT.LAST_UPDATE_DATE , CT.LAST_UPDATED_BY , CT.CREATION_DATE , CT.CREATED_BY FROM RA_CUSTOMER_TRX CT, RA_CUST_TRX_TYPES CTT WHERE CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID AND ((CT.CUST_TRX_TYPE_ID IS NULL) OR (CT.CUST_TRX_TYPE_ID IS NOT NULL AND NVL(CT.ORG_ID, -12345) = NVL(CTT.ORG_ID, -12345))) AND CTT.TYPE = 'CM' AND CT.PREVIOUS_CUSTOMER_TRX_ID IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ CT.CUSTOMER_TRX_ID
, /* REGULAR ATTRIBUTES */ CT.TRX_NUMBER
, CT.DOC_SEQUENCE_VALUE
, CT.TRX_DATE
, CT.EXCHANGE_RATE
, CT.EXCHANGE_RATE_TYPE
, CT.EXCHANGE_DATE
, '_LA:CT.COMPLETE_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CT.STATUS_TRX:AR_LOOKUPS:INVOICE_TRX_STATUS:MEANING'
, CT.PURCHASE_ORDER
, CT.PURCHASE_ORDER_DATE
, CT.PURCHASE_ORDER_REVISION
, CT.CUSTOMER_REFERENCE
, '_LA:CT.FINANCE_CHARGES:AR_LOOKUPS:YES/NO:MEANING'
, CT.TERM_DUE_DATE
, '_LA:CT.DEFAULT_TAX_EXEMPT_FLAG:AR_LOOKUPS:TAX_CONTROL_FLAG:MEANING'
, CT.SHIP_VIA
, CT.SHIP_DATE_ACTUAL
, CT.WAYBILL_NUMBER
, '_LA:CT.FOB_POINT:AR_LOOKUPS:FOB:MEANING'
, '_LA:CT.EDI_PROCESSED_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, CT.PRINTING_ORIGINAL_DATE
, CT.PRINTING_LAST_PRINTED
, '_LA:CT.PRINTING_PENDING:AR_LOOKUPS:YES/NO:MEANING'
, CT.PRINTING_COUNT
, CT.ORIG_SYSTEM_BATCH_NAME
, /* IDS */ CT.BATCH_ID
, CT.TERM_ID
, CT.BILL_TO_CONTACT_ID
, CT.SHIP_TO_CONTACT_ID
, CT.SOLD_TO_CONTACT_ID
, CT.BILL_TO_CUSTOMER_ID
, CT.SHIP_TO_CUSTOMER_ID
, CT.SOLD_TO_CUSTOMER_ID
, CT.PAYING_CUSTOMER_ID
, CT.PREVIOUS_CUSTOMER_TRX_ID
, CT.CUST_TRX_TYPE_ID
, CT.PRIMARY_SALESREP_ID
, CT.BILL_TO_SITE_USE_ID
, CT.SHIP_TO_SITE_USE_ID
, CT.SOLD_TO_SITE_USE_ID
, CT.PAYING_SITE_USE_ID
, CT.REMIT_TO_ADDRESS_ID
, CT.CUSTOMER_BANK_ACCOUNT_ID
, CT.RECEIPT_METHOD_ID
, CT.ORG_ID
, /* WHO COLUMNS */ CT.LAST_UPDATE_DATE
, CT.LAST_UPDATED_BY
, CT.CREATION_DATE
, CT.CREATED_BY
FROM RA_CUSTOMER_TRX CT
, RA_CUST_TRX_TYPES CTT
WHERE CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND ((CT.CUST_TRX_TYPE_ID IS NULL) OR (CT.CUST_TRX_TYPE_ID IS NOT NULL
AND NVL(CT.ORG_ID
, -12345) = NVL(CTT.ORG_ID
, -12345)))
AND CTT.TYPE = 'CM'
AND CT.PREVIOUS_CUSTOMER_TRX_ID IS NOT NULL WITH READ ONLY