VIEW: APPS.AR_REVENUE_ADJUSTMENTS_RA_V

Source

View Text - Preformatted

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','NR','SALESCRED_ADJ', '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 (+)

View Text - HTML Formatted

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'
, 'NR'
, 'SALESCRED_ADJ'
, '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 (+)