FND Design Data [Home] [Help]

Table: OZF_DENORM_QUERIES

Product: OZF - Trade Management
Description: This table stores the SQL Queries for the Market and Product Eligibilities. The Queries for Market eligibilites shalll select the party_id and the Queries for Product Eligibilites shall select the inventory_item_id. Quries are seeded ou
Implementation/DBA Data: TableOZF.OZF_DENORM_QUERIES
Primary Key: OZF_DENORM_QUERIES_PK
  1. ColumnDENORM_QUERY_ID
Primary Key: OZF_DENORM_QUERIES_UK1
  1. ColumnQUERY_FOR
  2. ColumnCONTEXT
  3. ColumnATTRIBUTE