Payables and Cash Management - EBS (MOSC)

MOSC Banner

Looking for CHIEF EXECUTIVE NAME/TITLE associated with Suppliers

edited Jul 17, 2019 6:59AM in Payables and Cash Management - EBS (MOSC) 4 commentsAnswered

My customer would like a report showing the SUPPLIER_NAME/NUMBER, CHIEF EXECUTIVE NAME, CHIEF EXECUTIVE TITLE based on the info seen in this path in EBS (12.0.6 in our case).  PAYABLES==>SUPPLIERS==>ORGANIZATION==>(CHIEF EXECUTIVE NAME/TITLE).  So far, I've done a search for similar column names and found these below, but, I have no idea how to tie that in to info in ap.ap_suppliers, etc...

  1* select owner, table_name, column_name from dba_tab_cols where column_name like 'CHIEF%'

SQL> /

OWNER                          TABLE_NAME

------------------------------ ------------------------------

COLUMN_NAME

------------------------------

APPS                           AMS_HZ_B2B_MAPPING_V

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