SELECT ffvs.flex_value_set_id, ffvs.flex_value_set_name, ffvs.description set_description, ffvs.validation_type, ffvt.value_column_name, ffvt.meaning_column_name, ffvt.id_column_name, ffvt.application_table_name, ffvt.additional_where_clause FROM apps.fnd_flex_value_sets ffvs, apps.fnd_flex_validation_tables ffvt WHERE ffvs.flex_value_set_id = ffvt.flex_value_set_id AND ffvs.flex_value_set_name LIKE 'IBY_YES_NO';
This blog is for Oracle Ebs, Fusion and OIC Techno- Functional People. I am sharing my work experience through this blog.
Friday, 5 January 2018
Oracle apps Valueset details Query
Subscribe to:
Post Comments (Atom)
AP Invoice Notes related Table details in Oracle Fusion
What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...
-
P2P CYCLE: INVENTORY=> REQUIESTITION=> RFQ=> QUOTATION=> QUOTATION ANALYSIS=> PURCHASE ORDER =>...
-
Order to Cash (O2C) Cycle with in Oracle Apps Enter the Sales Order Book the Sales Order Launch Pick Release Ship Confirm Create In...
-
---------- 1) Below given query can be used TO get concatenated Gl code combinations segment AND its description USING API GL_FLEXFIELDS_PK...
No comments:
Post a Comment