Receivables - EBS (MOSC)

MOSC Banner

Changing Receipt Method LOV

edited Jan 17, 2018 12:42PM in Receivables - EBS (MOSC) 2 commentsAnswered ✓

Hi all,

I am making a form personalization to change receipt method LOV, but It does not work, could you help me, please?

Original select:

SELECT RM.NAME,

       RM.RECEIPT_METHOD_ID,

       SUBSTRB(ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING(:1, RC.CREATION_STATUS),

               1,

               80) MEANING,

       BA.BANK_ACCT_USE_ID "bank_account_id",

       SUBSTRB(CE_BANK_AND_ACCOUNT_UTIL.GET_MASKED_BANK_ACCT_NUM(CBA.BANK_ACCOUNT_ID),

               1,

               360) BANK_ACCOUNT_NUM,

       BB.BANK_NAME,

       BB.BANK_BRANCH_NAME,

       BB.BRANCH_PARTY_ID "bank_branch_id",

       CBA.CURRENCY_CODE,

       RC.CREATION_STATUS,

       RC.NAME RECEIPT_CLASS_NAME,

       RC.REMIT_FLAG,

       RC.NOTES_RECEIVABLE,

Tagged:

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