[Home] [Help]
| Product: | AR - Receivables |
|---|---|
| Description: | Deduction Assignment Details |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PS.ROWID
, DED.ROWID
, DED.ROWID
, PS.CUSTOMER_TRX_ID
, PS.CUST_TRX_TYPE_ID
, PS.CUSTOMER_ID
, DED.ASSIGNED_TO_SALESREP_ID
, DED.ASSIGNED_TO_COLLECTOR_ID
, DED.DEDUCTN_ASSGNMT_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, PS.TRX_NUMBER
, CTT.NAME
, PS.AMOUNT_DUE_REMAINING
, DECODE(ASSIGNED_TO_SALESREP_ID
, NULL
, DECODE(ASSIGNED_TO_COLLECTOR_ID
, NULL
, NULL
, COL2.NAME)
, SREP2.NAME)
, DECODE(TRANSFER_TO_SALESREP_ID
, NULL
, DECODE(TRANSFER_TO_COLLECTOR_ID
, NULL
, NULL
, COL.NAME)
, SREP.NAME)
, PS.TRX_DATE
, DECODE(PS.STATUS
, 'OP'
, 'OPEN'
, 'CL'
, 'CLOSED'
, 'PEN'
, 'PENDING'
, 'VD'
, 'VOID'
, NULL)
, DED.DEDUCTN_TEXT
, DED.DATE_ASSIGNED
, DED.TRANSFER_TO_COLLECTOR_ID
, DED.TRANSFER_TO_SALESREP_ID
, PS.GL_DATE
, PS.ORG_ID
, DED.LAST_UPDATED_BY
, DED.LAST_UPDATE_DATE
, DED.CREATED_BY
, DED.CREATION_DATE
, DED.LAST_UPDATE_LOGIN
, DED.ATTRIBUTE_CATEGORY
, DED.ATTRIBUTE1
, DED.ATTRIBUTE2
, DED.ATTRIBUTE3
, DED.ATTRIBUTE4
, DED.ATTRIBUTE5
, DED.ATTRIBUTE6
, DED.ATTRIBUTE7
, DED.ATTRIBUTE8
, DED.ATTRIBUTE9
, DED.ATTRIBUTE10
, DED.ATTRIBUTE11
, DED.ATTRIBUTE12
, DED.ATTRIBUTE13
, DED.ATTRIBUTE14
, DED.ATTRIBUTE15
FROM AR_PAYMENT_SCHEDULES PS
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, AR_COLLECTORS COL
, AR_COLLECTORS COL2
, RA_CUST_TRX_TYPES CTT
, RA_SALESREPS SREP2
, RA_SALESREPS SREP
, AR_TA_DEDN_ASSGNS DED
WHERE CTT.TYPE IN ('DM'
, 'CM')
AND CTT.ATTRIBUTE10 = 'DED'
AND PS.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND PS.CUSTOMER_TRX_ID = DED.CUSTOMER_TRX_ID(+)
AND PS.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND DED.ASSIGNED_TO_SALESREP_ID = SREP2.SALESREP_ID(+)
AND DED.ASSIGNED_TO_COLLECTOR_ID = COL2.COLLECTOR_ID(+)
AND DED.TRANSFER_TO_SALESREP_ID = SREP.SALESREP_ID(+)
AND DED.TRANSFER_TO_COLLECTOR_ID = COL.COLLECTOR_ID(+)