eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AR_XLA_ARD_RA_LINES_V

Source

View Text - Preformatted


SELECT ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , ard.SOURCE_TYPE , NULL , NULL , ard.code_combination_id , ard.AMOUNT_DR , ard.AMOUNT_CR , ard.ACCTD_AMOUNT_DR , ard.ACCTD_AMOUNT_CR , ard.ORG_ID , ard.SOURCE_TABLE_SECONDARY , ard.SOURCE_ID_SECONDARY , ard.CURRENCY_CODE , ard.CURRENCY_CONVERSION_RATE , ard.CURRENCY_CONVERSION_TYPE , ard.CURRENCY_CONVERSION_DATE , ard.TAXABLE_ENTERED_DR , ard.TAXABLE_ENTERED_CR , ard.TAXABLE_ACCOUNTED_DR , ard.TAXABLE_ACCOUNTED_CR , ard.TAX_LINK_ID , ard.THIRD_PARTY_ID , ard.THIRD_PARTY_SUB_ID , ard.REVERSED_SOURCE_ID , ard.TAX_CODE_ID , ard.LOCATION_SEGMENT_ID , ard.SOURCE_TYPE_SECONDARY , ard.TAX_GROUP_CODE_ID , ard.REF_CUSTOMER_TRX_LINE_ID , ard.REF_CUST_TRX_LINE_GL_DIST_ID , ard.REF_LINE_ID , ard.FROM_AMOUNT_DR , ard.FROM_AMOUNT_CR , ard.FROM_ACCTD_AMOUNT_DR , ard.FROM_ACCTD_AMOUNT_CR , ard.REF_ACCOUNT_CLASS , ard.ACTIVITY_BUCKET , ard.REF_DIST_CCID , ard.REF_MF_DIST_FLAG , to_number(NULL) , ra.gl_date , NULL , ard.CREATION_DATE , ard.CREATED_BY , ard.LAST_UPDATED_BY , ard.LAST_UPDATE_DATE , to_number(NULL), ra.cash_receipt_id CASH_RECEIPT_ID, ra.application_type APPLICATION_TYPE, ra.posting_control_id POSTING_CONTROL_ID FROM ar_distributions_all ard, ar_receivable_applications_all ra WHERE ra.posting_control_id <> -3 AND ard.source_table = 'RA' AND ard.source_id = ra.receivable_application_id AND ra.status IN('APP','ACC','ACTIVITY','OTHER ACC') AND ra.event_id IS NULL UNION SELECT ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , ard.SOURCE_TYPE , NULL , NULL , ard.code_combination_id , ard.AMOUNT_DR , ard.AMOUNT_CR , ard.ACCTD_AMOUNT_DR , ard.ACCTD_AMOUNT_CR , ard.ORG_ID , ard.SOURCE_TABLE_SECONDARY , ard.SOURCE_ID_SECONDARY , ard.CURRENCY_CODE , ard.CURRENCY_CONVERSION_RATE , ard.CURRENCY_CONVERSION_TYPE , ard.CURRENCY_CONVERSION_DATE , ard.TAXABLE_ENTERED_DR , ard.TAXABLE_ENTERED_CR , ard.TAXABLE_ACCOUNTED_DR , ard.TAXABLE_ACCOUNTED_CR , ard.TAX_LINK_ID , ard.THIRD_PARTY_ID , ard.THIRD_PARTY_SUB_ID , ard.REVERSED_SOURCE_ID , ard.TAX_CODE_ID , ard.LOCATION_SEGMENT_ID , ard.SOURCE_TYPE_SECONDARY , ard.TAX_GROUP_CODE_ID , ard.REF_CUSTOMER_TRX_LINE_ID , ard.REF_CUST_TRX_LINE_GL_DIST_ID , ard.REF_LINE_ID , ard.FROM_AMOUNT_DR , ard.FROM_AMOUNT_CR , ard.FROM_ACCTD_AMOUNT_DR , ard.FROM_ACCTD_AMOUNT_CR , ard.REF_ACCOUNT_CLASS , ard.ACTIVITY_BUCKET , ard.REF_DIST_CCID , ard.REF_MF_DIST_FLAG , to_number(NULL) , ra.gl_date , NULL , ard.CREATION_DATE , ard.CREATED_BY , ard.LAST_UPDATED_BY , ard.LAST_UPDATE_DATE , to_number(NULL), ra.cash_receipt_id CASH_RECEIPT_ID, ra.application_type APPLICATION_TYPE, ra.posting_control_id POSTING_CONTROL_ID FROM ar_distributions_all ard, ar_receivable_applications_all ra WHERE ra.posting_control_id <> -3 AND ard.source_table = 'RA' AND ard.source_id = ra.receivable_application_id AND ra.status IN('UNAPP','UNID') AND ra.event_id IS NULL AND EXISTS (SELECT NULL FROM xla_distribution_links lk WHERE lk.source_distribution_id_num_1 = ard.line_id AND lk.application_id = 222 AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' )

View Text - HTML Formatted

SELECT ARD.LINE_ID
, ARD.SOURCE_ID
, ARD.SOURCE_TABLE
, ARD.SOURCE_TYPE
, NULL
, NULL
, ARD.CODE_COMBINATION_ID
, ARD.AMOUNT_DR
, ARD.AMOUNT_CR
, ARD.ACCTD_AMOUNT_DR
, ARD.ACCTD_AMOUNT_CR
, ARD.ORG_ID
, ARD.SOURCE_TABLE_SECONDARY
, ARD.SOURCE_ID_SECONDARY
, ARD.CURRENCY_CODE
, ARD.CURRENCY_CONVERSION_RATE
, ARD.CURRENCY_CONVERSION_TYPE
, ARD.CURRENCY_CONVERSION_DATE
, ARD.TAXABLE_ENTERED_DR
, ARD.TAXABLE_ENTERED_CR
, ARD.TAXABLE_ACCOUNTED_DR
, ARD.TAXABLE_ACCOUNTED_CR
, ARD.TAX_LINK_ID
, ARD.THIRD_PARTY_ID
, ARD.THIRD_PARTY_SUB_ID
, ARD.REVERSED_SOURCE_ID
, ARD.TAX_CODE_ID
, ARD.LOCATION_SEGMENT_ID
, ARD.SOURCE_TYPE_SECONDARY
, ARD.TAX_GROUP_CODE_ID
, ARD.REF_CUSTOMER_TRX_LINE_ID
, ARD.REF_CUST_TRX_LINE_GL_DIST_ID
, ARD.REF_LINE_ID
, ARD.FROM_AMOUNT_DR
, ARD.FROM_AMOUNT_CR
, ARD.FROM_ACCTD_AMOUNT_DR
, ARD.FROM_ACCTD_AMOUNT_CR
, ARD.REF_ACCOUNT_CLASS
, ARD.ACTIVITY_BUCKET
, ARD.REF_DIST_CCID
, ARD.REF_MF_DIST_FLAG
, TO_NUMBER(NULL)
, RA.GL_DATE
, NULL
, ARD.CREATION_DATE
, ARD.CREATED_BY
, ARD.LAST_UPDATED_BY
, ARD.LAST_UPDATE_DATE
, TO_NUMBER(NULL)
, RA.CASH_RECEIPT_ID CASH_RECEIPT_ID
, RA.APPLICATION_TYPE APPLICATION_TYPE
, RA.POSTING_CONTROL_ID POSTING_CONTROL_ID
FROM AR_DISTRIBUTIONS_ALL ARD
, AR_RECEIVABLE_APPLICATIONS_ALL RA
WHERE RA.POSTING_CONTROL_ID <> -3
AND ARD.SOURCE_TABLE = 'RA'
AND ARD.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID
AND RA.STATUS IN('APP'
, 'ACC'
, 'ACTIVITY'
, 'OTHER ACC')
AND RA.EVENT_ID IS NULL UNION SELECT ARD.LINE_ID
, ARD.SOURCE_ID
, ARD.SOURCE_TABLE
, ARD.SOURCE_TYPE
, NULL
, NULL
, ARD.CODE_COMBINATION_ID
, ARD.AMOUNT_DR
, ARD.AMOUNT_CR
, ARD.ACCTD_AMOUNT_DR
, ARD.ACCTD_AMOUNT_CR
, ARD.ORG_ID
, ARD.SOURCE_TABLE_SECONDARY
, ARD.SOURCE_ID_SECONDARY
, ARD.CURRENCY_CODE
, ARD.CURRENCY_CONVERSION_RATE
, ARD.CURRENCY_CONVERSION_TYPE
, ARD.CURRENCY_CONVERSION_DATE
, ARD.TAXABLE_ENTERED_DR
, ARD.TAXABLE_ENTERED_CR
, ARD.TAXABLE_ACCOUNTED_DR
, ARD.TAXABLE_ACCOUNTED_CR
, ARD.TAX_LINK_ID
, ARD.THIRD_PARTY_ID
, ARD.THIRD_PARTY_SUB_ID
, ARD.REVERSED_SOURCE_ID
, ARD.TAX_CODE_ID
, ARD.LOCATION_SEGMENT_ID
, ARD.SOURCE_TYPE_SECONDARY
, ARD.TAX_GROUP_CODE_ID
, ARD.REF_CUSTOMER_TRX_LINE_ID
, ARD.REF_CUST_TRX_LINE_GL_DIST_ID
, ARD.REF_LINE_ID
, ARD.FROM_AMOUNT_DR
, ARD.FROM_AMOUNT_CR
, ARD.FROM_ACCTD_AMOUNT_DR
, ARD.FROM_ACCTD_AMOUNT_CR
, ARD.REF_ACCOUNT_CLASS
, ARD.ACTIVITY_BUCKET
, ARD.REF_DIST_CCID
, ARD.REF_MF_DIST_FLAG
, TO_NUMBER(NULL)
, RA.GL_DATE
, NULL
, ARD.CREATION_DATE
, ARD.CREATED_BY
, ARD.LAST_UPDATED_BY
, ARD.LAST_UPDATE_DATE
, TO_NUMBER(NULL)
, RA.CASH_RECEIPT_ID CASH_RECEIPT_ID
, RA.APPLICATION_TYPE APPLICATION_TYPE
, RA.POSTING_CONTROL_ID POSTING_CONTROL_ID
FROM AR_DISTRIBUTIONS_ALL ARD
, AR_RECEIVABLE_APPLICATIONS_ALL RA
WHERE RA.POSTING_CONTROL_ID <> -3
AND ARD.SOURCE_TABLE = 'RA'
AND ARD.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID
AND RA.STATUS IN('UNAPP'
, 'UNID')
AND RA.EVENT_ID IS NULL
AND EXISTS (SELECT NULL
FROM XLA_DISTRIBUTION_LINKS LK
WHERE LK.SOURCE_DISTRIBUTION_ID_NUM_1 = ARD.LINE_ID
AND LK.APPLICATION_ID = 222
AND LK.SOURCE_DISTRIBUTION_TYPE = 'AR_DISTRIBUTIONS_ALL' )