VIEW: APPS.AR_DISTRIBUTIONS_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)