APPS.OKC_OC_INT_PRICING_PVT dependencies on OKX_QTE_PRC_ADJ_ATRBS_V

Line 90: okx_qte_prc_adj_atrbs_v

86:
87: The OKX related quote pricing views concerned are:
88: okx_qte_prc_atrbs_v
89: okx_qte_prc_adjmnts_v
90: okx_qte_prc_adj_atrbs_v
91: okx_qte_prc_adj_rlshp_v
92:
93: Flow:
94: |---OKC_OC_INT_PRICING.create_k_pricing()

Line 1699: -- cursor to get okx_qte_prc_adj_atrbs_v or

1695: l_no_data_found BOOLEAN := TRUE;
1696:
1697: i BINARY_INTEGER := 0;
1698:
1699: -- cursor to get okx_qte_prc_adj_atrbs_v or
1700: -- okx_ord_prc_adj_atrbs_v information
1701: CURSOR c_source_paav_rec(cp_q_flag IN VARCHAR2,
1702: cp_o_flag IN VARCHAR2,
1703: cp_old_pat_id IN NUMBER) IS

Line 1708: -- first query to get okx_qte_prc_adj_atrbs_v information

1704: --could be either ASO or ONT
1705: --only ONE of the following two queries in the union will be executed in
1706: --a call depending on which flag (p_q_flag or p_o_flag) is true
1707:
1708: -- first query to get okx_qte_prc_adj_atrbs_v information
1709: SELECT ----price_adjustment_id, --not needed
1710: flex_title,
1711: pricing_context,
1712: pricing_attribute,

Line 1717: FROM okx_qte_prc_adj_atrbs_v

1713: pricing_attr_value_from,
1714: pricing_attr_value_to,
1715: comparison_operator,
1716: object_version_number
1717: FROM okx_qte_prc_adj_atrbs_v
1718: WHERE cp_q_flag = OKC_API.G_TRUE
1719: AND price_adjustment_id = cp_old_pat_id
1720:
1721: UNION ALL

Line 3384: OKX_QTE_PRC_ADJ_ATRBS_V qpadj

3380: kpadj.comparison_operator
3381:
3382: FROM
3383: okc_price_adj_attribs kpadj,
3384: OKX_QTE_PRC_ADJ_ATRBS_V qpadj
3385: WHERE
3386: b_q_flag = OKC_API.g_true
3387: AND kpadj.pat_id = b_kpat_id
3388: AND qpadj.price_adjustment_id(+) = b_pat_id

Line 3431: FROM OKX_QTE_PRC_ADJ_ATRBS_V qpadj

3427: qpadj.pricing_attribute,
3428: qpadj.pricing_attr_value_from,
3429: qpadj.pricing_attr_value_to,
3430: qpadj.comparison_operator
3431: FROM OKX_QTE_PRC_ADJ_ATRBS_V qpadj
3432: WHERE b_q_flag = OKC_API.g_true
3433: AND qpadj.price_adjustment_id = b_pat_id
3434:
3435: UNION