View: AR_TA_PAYMENTS_INTERFACE_REM_V

View Text

SELECT TRANSMISSION_RECORD_ID
, RECORD_TYPE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, BATCH_NAME
, CPG_ORIG_BATCH_NAME
, CHECK_NUMBER
, CPG_REASSOCIATION_TRACE_NUM
, ITEM_NUMBER
, CURRENCY_CODE
, INVOICE1
, AMOUNT_APPLIED1
, LOCKBOX_NUMBER
, CPG_ORIG_LOCKBOX_NUMBER
, CPG_PURCHASE_ORDER_NUMBER
, GL_DATE
, CPG_CUSTOMER_REF_NUMBER
, CPG_TRANSACTION_DATE
, CPG_SHIP_TO_LOCATION_NUMBER
, CPG_ORIGINAL_TRX_NUMBER
, CPG_ASSOCIATION_FLAG
, CPG_TRX_HANDLING_CODE
, CPG_CUST_DEDUCTION_REASON_CODE
, INVOICE1_INSTALLMENT
, OVERFLOW_SEQUENCE
, OVERFLOW_INDICATOR
, ORG_ID
, TRANSMISSION_ID
, TRANSMISSION_REQUEST_ID
, STATUS
FROM AR_PAYMENTS_INTERFACE_ALL
WHERE RECORD_TYPE=6
AND NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR ( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR (USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR ( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR (USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns