View: AR_LINE_DEFERRAL_REASONS_V

Product:	AR - Receivables
Description:	(Release 12 Only )
Implementation/DBA Data:	APPS.AR_LINE_DEFERRAL_REASONS_V

View Text

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

Columns