View: AR_DISTRIBUTIONS_MRC_V

Product:	AR - Receivables
Description:	Accounting records for receipts in multiple reporting currencies
Implementation/DBA Data:	APPS.AR_DISTRIBUTIONS_MRC_V

View Text

SELECT MC.LINE_ID
, MC.SET_OF_BOOKS_ID
, MC.SOURCE_ID
, MC.SOURCE_TABLE
, MC.SOURCE_TYPE
, MC.CODE_COMBINATION_ID
, MC.AMOUNT_DR
, MC.AMOUNT_CR
, MC.ACCTD_AMOUNT_DR
, MC.ACCTD_AMOUNT_CR
, MC.CREATION_DATE
, MC.CREATED_BY
, MC.LAST_UPDATED_BY
, MC.LAST_UPDATE_DATE
, MC.LAST_UPDATE_LOGIN
, MC.ORG_ID
, MC.SOURCE_TABLE_SECONDARY
, MC.SOURCE_ID_SECONDARY
, MC.CURRENCY_CODE
, MC.CURRENCY_CONVERSION_RATE
, MC.CURRENCY_CONVERSION_TYPE
, MC.CURRENCY_CONVERSION_DATE
, MC.TAXABLE_ENTERED_DR
, MC.TAXABLE_ENTERED_CR
, MC.TAXABLE_ACCOUNTED_DR
, MC.TAXABLE_ACCOUNTED_CR
, MC.TAX_LINK_ID
, MC.THIRD_PARTY_ID
, MC.THIRD_PARTY_SUB_ID
, MC.REVERSED_SOURCE_ID
, MC.TAX_CODE_ID
, MC.LOCATION_SEGMENT_ID
, MC.SOURCE_TYPE_SECONDARY
, TAX_GROUP_CODE_ID
FROM AR_MC_DISTRIBUTIONS_ALL MC
WHERE NVL(MC.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)

Columns