VIEW: APPS.AR_LINE_DEFERRAL_REASONS_V

Source

View Text - Preformatted

SELECT LC.ROWID ,LC.CUSTOMER_TRX_LINE_ID ,LC.CONTINGENCY_ID ,DR.CONTINGENCY_NAME ,DR.DESCRIPTION ,DR.NOTES ,LC.EXPIRATION_DATE ,LC.EXPIRATION_DAYS ,LC.COMPLETED_FLAG ,LC.COMPLETED_BY ,DR.EXPIRATION_EVENT_CODE ,ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('AR_EXPIRATION_EVENTS',DR.EXPIRATION_EVENT_CODE) EXPIRATION_EVENT_MEANING ,LC.EXPIRATION_EVENT_DATE ,LC.REASON_REMOVAL_DATE ,DR.REVREC_EVENT_CODE ,ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('AR_REVREC_EVENTS',DR.REVREC_EVENT_CODE) REVREC_EVENT_MEANING ,DR.POLICY_ATTACHED ,DR.START_DATE ,DR.END_DATE ,CTL.LINE_NUMBER ,CTL.CUSTOMER_TRX_ID ,CTL.INVENTORY_ITEM_ID ,MIC.CATEGORY_ID ,LC.ORG_ID FROM mtl_item_categories mic ,ar_deferral_reasons dr ,ra_customer_trx_lines_all ctl ,ar_line_conts lc WHERE lc.contingency_id = dr.contingency_id(+) AND lc.customer_trx_line_id = ctl.customer_trx_line_id AND CTL.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID(+) AND MIC.CATEGORY_SET_ID(+) = AR_REVENUE_ADJUSTMENT_PVT.CATEGORY_SET_ID AND MIC.ORGANIZATION_ID(+) = AR_REVENUE_ADJUSTMENT_PVT.INV_ORG_ID AND lc.org_id = ctl.org_id

View Text - HTML Formatted

SELECT LC.ROWID
, LC.CUSTOMER_TRX_LINE_ID
, LC.CONTINGENCY_ID
, DR.CONTINGENCY_NAME
, DR.DESCRIPTION
, DR.NOTES
, LC.EXPIRATION_DATE
, LC.EXPIRATION_DAYS
, LC.COMPLETED_FLAG
, LC.COMPLETED_BY
, DR.EXPIRATION_EVENT_CODE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('AR_EXPIRATION_EVENTS'
, DR.EXPIRATION_EVENT_CODE) EXPIRATION_EVENT_MEANING
, LC.EXPIRATION_EVENT_DATE
, LC.REASON_REMOVAL_DATE
, DR.REVREC_EVENT_CODE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('AR_REVREC_EVENTS'
, DR.REVREC_EVENT_CODE) REVREC_EVENT_MEANING
, DR.POLICY_ATTACHED
, DR.START_DATE
, DR.END_DATE
, CTL.LINE_NUMBER
, CTL.CUSTOMER_TRX_ID
, CTL.INVENTORY_ITEM_ID
, MIC.CATEGORY_ID
, LC.ORG_ID
FROM MTL_ITEM_CATEGORIES MIC
, AR_DEFERRAL_REASONS DR
, RA_CUSTOMER_TRX_LINES_ALL CTL
, AR_LINE_CONTS LC
WHERE LC.CONTINGENCY_ID = DR.CONTINGENCY_ID(+)
AND LC.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID
AND CTL.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID(+)
AND MIC.CATEGORY_SET_ID(+) = AR_REVENUE_ADJUSTMENT_PVT.CATEGORY_SET_ID
AND MIC.ORGANIZATION_ID(+) = AR_REVENUE_ADJUSTMENT_PVT.INV_ORG_ID
AND LC.ORG_ID = CTL.ORG_ID