Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AR_REVENUE_ADJUSTMENTS_RA_V |
SELECT RA.REVENUE_ADJUSTMENT_ID
, RA.REVENUE_ADJUSTMENT_NUMBER
, RA.CUSTOMER_TRX_ID
, RA.APPLICATION_DATE
, RA.FROM_SALESREP_ID
, ARPT_SQL_FUNC_UTIL.GET_SALESREP_NAME_NUMBER(RA.FROM_SALESREP_ID
, 'NAME'
, RA.ORG_ID)
, RA.TO_SALESREP_ID
, ARPT_SQL_FUNC_UTIL.GET_SALESREP_NAME_NUMBER(RA.TO_SALESREP_ID
, 'NAME'
, RA.ORG_ID)
, RA.TYPE
, AL_AT.MEANING
, RA.SALES_CREDIT_TYPE
, AL_SCT.MEANING
, RA.AMOUNT_MODE
, AL_AM.MEANING
, RA.AMOUNT
, RA.PERCENT
, RA.LINE_SELECTION_MODE
, AL_LSM.MEANING
, RA.FROM_CATEGORY_ID
, RA.TO_CATEGORY_ID
, RA.FROM_INVENTORY_ITEM_ID
, RA.TO_INVENTORY_ITEM_ID
, RA.FROM_CUST_TRX_LINE_ID
, RA.TO_CUST_TRX_LINE_ID
, RA.GL_DATE
, RA.REASON_CODE
, AL_RC.MEANING
, RA.COMMENTS
, RA.STATUS
, RA.CREATION_DATE
, RA.CREATED_BY
, RA.LAST_UPDATE_DATE
, RA.LAST_UPDATED_BY
, RA.LAST_UPDATE_LOGIN
, RA.ATTRIBUTE_CATEGORY
, RA.ATTRIBUTE1
, RA.ATTRIBUTE2
, RA.ATTRIBUTE3
, RA.ATTRIBUTE4
, RA.ATTRIBUTE5
, RA.ATTRIBUTE6
, RA.ATTRIBUTE7
, RA.ATTRIBUTE8
, RA.ATTRIBUTE9
, RA.ATTRIBUTE10
, RA.ATTRIBUTE11
, RA.ATTRIBUTE12
, RA.ATTRIBUTE13
, RA.ATTRIBUTE14
, RA.ATTRIBUTE15
, RA.PROGRAM_APPLICATION_ID
, RA.PROGRAM_ID
, RA.PROGRAM_UPDATE_DATE
, RA.REQUEST_ID
, RA.ORG_ID
, RA.FROM_SALESGROUP_ID
, FROM_GROUP.GROUP_NAME
, RA.TO_SALESGROUP_ID
, TO_GROUP.GROUP_NAME
FROM AR_LOOKUPS AL_AT
, AR_LOOKUPS AL_RC
, AR_LOOKUPS AL_SCT
, AR_LOOKUPS AL_AM
, AR_LOOKUPS AL_LSM
, JTF_RS_GROUPS_VL FROM_GROUP
, JTF_RS_GROUPS_VL TO_GROUP
, AR_REVENUE_ADJUSTMENTS RA
WHERE RA.TYPE = AL_AT.LOOKUP_CODE
AND AL_AT.LOOKUP_TYPE = 'REV_ADJ_TYPE'
AND RA.REASON_CODE = AL_RC.LOOKUP_CODE
AND AL_RC.LOOKUP_TYPE = DECODE(RA.TYPE
, 'SA'
, 'SALESCRED_ADJ_REASON'
, 'REV_ADJ_REASON')
AND RA.SALES_CREDIT_TYPE = AL_SCT.LOOKUP_CODE(+)
AND AL_SCT.LOOKUP_TYPE(+) = 'REV_ADJ_SALES_CREDIT_TYPE'
AND RA.AMOUNT_MODE = AL_AM.LOOKUP_CODE
AND AL_AM.LOOKUP_TYPE = 'REV_ADJ_AMOUNT_MODE'
AND RA.LINE_SELECTION_MODE = AL_LSM.LOOKUP_CODE
AND AL_LSM.LOOKUP_TYPE = 'REV_ADJ_LINE_SELECT_MODE'
AND RA.FROM_SALESGROUP_ID = FROM_GROUP.GROUP_ID (+)
AND RA.TO_SALESGROUP_ID = TO_GROUP.GROUP_ID (+)