Technology Stack - EBS (MOSC)

MOSC Banner

Auto Populate Contact Informaiton when User Account Number is input

edited Aug 20, 2021 11:04AM in Technology Stack - EBS (MOSC) 3 commentsAnswered

Good Morning,

I am just getting into PL/SQL and I wanted to set up my Application to automatically populate the contact fields when input that information. So far I know the following

Condition:

CUSTOMER_HEADER_BLK.CUST_ACCOUNT_NUMBER=

Action:

CUSTOMER_HEADER_BLK.CONT_PER_LAST_NAME_C=

CUSTOMER_HEADER_BLK.CONT_PER_FIRST_NAME_C=

CUSTOMER_HEADER_BLK.CONT_CONCAT_PHONE_NUMBER_C=

CUSTOMER_HEADER_BLK.CONT_EMAIL_C=

I have no clue how to tie these all together, so if I just input any account number it will pull up the contact information associated with that Account number.

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