VIEW: APPS.IEX_DEL_V

Source

View Text - Preformatted

SELECT DLN.PARTY_CUST_ID CUSTOMER_ID , DLN.DELINQUENCY_ID DELINQUENCY_ID , DLN.CUST_ACCOUNT_ID CUST_ACCOUNT_ID , DLN.TRANSACTION_ID TRANSACTION_ID , DLN.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID , DLN.BANKRUPTCY_ID BANKRUPTCY_ID , DLN.WRITEOFF_ID WRITEOFF_ID , DLN.REPOSSESSION_ID REPOSSESSION_ID , DLN.LITIGATION_ID LITIGATION_ID , DLN.CASE_ID , 0 AMOUNT , APS.INVOICE_CURRENCY_CODE AMOUNT_UNIT , DLN.OPEN_CLOSE_STATUS OPEN_CLOSE_STATUS , DLN.STATUS STATUS , ABL.REPORT_HEADING1||ABL.REPORT_HEADING2 AGING_BUCKET , DLN.CASE_ID CASE_NUMBER , OP_UNIT.NAME OPERATING_UNIT FROM HR_OPERATING_UNITS OP_UNIT , IEX_DELINQUENCIES_STAGE_V DLN , AR_AGING_BUCKET_LINES_VL ABL , AR_PAYMENT_SCHEDULES APS WHERE DLN.ORG_ID = OP_UNIT.ORGANIZATION_ID ( + ) AND DLN.AGING_BUCKET_LINE_ID = ABL.AGING_BUCKET_LINE_ID ( + ) AND DLN.PAYMENT_SCHEDULE_ID = APS.payment_schedule_id

View Text - HTML Formatted

SELECT DLN.PARTY_CUST_ID CUSTOMER_ID
, DLN.DELINQUENCY_ID DELINQUENCY_ID
, DLN.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, DLN.TRANSACTION_ID TRANSACTION_ID
, DLN.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, DLN.BANKRUPTCY_ID BANKRUPTCY_ID
, DLN.WRITEOFF_ID WRITEOFF_ID
, DLN.REPOSSESSION_ID REPOSSESSION_ID
, DLN.LITIGATION_ID LITIGATION_ID
, DLN.CASE_ID
, 0 AMOUNT
, APS.INVOICE_CURRENCY_CODE AMOUNT_UNIT
, DLN.OPEN_CLOSE_STATUS OPEN_CLOSE_STATUS
, DLN.STATUS STATUS
, ABL.REPORT_HEADING1||ABL.REPORT_HEADING2 AGING_BUCKET
, DLN.CASE_ID CASE_NUMBER
, OP_UNIT.NAME OPERATING_UNIT
FROM HR_OPERATING_UNITS OP_UNIT
, IEX_DELINQUENCIES_STAGE_V DLN
, AR_AGING_BUCKET_LINES_VL ABL
, AR_PAYMENT_SCHEDULES APS
WHERE DLN.ORG_ID = OP_UNIT.ORGANIZATION_ID ( + )
AND DLN.AGING_BUCKET_LINE_ID = ABL.AGING_BUCKET_LINE_ID ( + )
AND DLN.PAYMENT_SCHEDULE_ID = APS.PAYMENT_SCHEDULE_ID