Pricing Views

This set of views expose the Price-related data. The set consists of the views described in the following table.

Table 1. Pricing Views
View Description Interpreted Columns SQL Filename

YNA_PRICE_ITEM_DETAIL_

LIST_VW

This view exposes the data in the YFS_ITEM_PRICE_SET_DTL table.

None
CONFIGURATION/
Pricing_Item_Detail.sql
YNA_PRICE_ITEM_LIST_VW

This view exposes the data in the YFS_ITEM_PRICE_SET table.

None
CONFIGURATION/
Pricing_Item.sql
YNA_PRICE_LIST_VW

This view exposes the data in the YFS_PRICE_SET table.

None
CONFIGURATION/
Pricing_List.sql

YNA_PRICE_PROGRAM_

DETAIL_VW

This view exposes the data in the YFS_IPRICE_PROGRAM_DEFN table.

None
CONFIGURATION/
Pricing_Program_Detail.sql
YNA_PRICE_PROGRAM_VW

This view exposes the data in the YFS_PRICE_PROGRAM table.

None
CONFIGURATION/
Pricing_Program.sql