Product: | IGI - Public Sector Financials International |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGI_RA_CUSTOMER_TRX_PARTIAL_V |
SELECT DISTINCT ROW_ID
, CUSTOMER_TRX_ID
, TRX_NUMBER
, TRX_DATE
, TERM_ID
, COMPLETE_FLAG
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, INVOICE_CURRENCY_CODE
, COMMENTS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RAC_BILL_TO_CUSTOMER_NAME
, RAC_SHIP_TO_CUSTOMER_NAME
, BS_BATCH_SOURCE_NAME
, CTT_TYPE_NAME
, CTT_CLASS
, RAS_PRIMARY_SALESREP_NAME
, RAT_TERM_NAME
, CT_REFERENCE
, GD_GL_DATE
FROM RA_CUSTOMER_TRX_PARTIAL_V
WHERE EXISTS (SELECT 'X'
FROM AR_PAYMENT_SCHEDULES PAY WHERE PAY.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX_PARTIAL_V.CUSTOMER_TRX_ID AND STATUS = 'OP')