Receivables - EBS (MOSC)

MOSC Banner

Standard / MISC Receipt

edited Feb 12, 2018 4:00AM in Receivables - EBS (MOSC) 1 commentAnswered

Dear All,

I'm trying to create a query to get some data about the receipt but i didn't know where the type is stored :

type : standard / Miscellaneous can you please check the query and help me to find where this type is stored :

SELECT

distinct

cba.BANK_ACCOUNT_NUM AR_BANK_ACCOUNT_NUM ,

CBA.BANK_ACCOUNT_NAME AR_BANK_ACCOUNT_NAME,

CBA.currency_code AR_currency_code,

ARA.AMOUNT AR_AMOUNT,

ARA.RECEIPT_DATE AR_RECEIPT_DATE,

ARA.RECEIPT_NUMBER AR_RECEIPT_NUMBER,

ARA.CURRENCY_CODE AR_CURRENCY_CODE,

CRH.status AR_status,

ARA.TYPE AR_type,

ARA.ORG_ID AR_org_id,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center