APPS.OKC_OC_INT_PRICING_PVT dependencies on OKX_ORD_PRC_ADJ_ATRBS_V

Line 1700: -- okx_ord_prc_adj_atrbs_v information

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
1704: --could be either ASO or ONT

Line 1723: -- second query to get okx_ord_prc_adj_atrbs_v information

1719: AND price_adjustment_id = cp_old_pat_id
1720:
1721: UNION ALL
1722:
1723: -- second query to get okx_ord_prc_adj_atrbs_v information
1724: SELECT --------price_adjustment_id, --not needed
1725: flex_title,
1726: pricing_context,
1727: pricing_attribute,

Line 1732: FROM okx_ord_prc_adj_atrbs_v

1728: pricing_attr_value_from,
1729: pricing_attr_value_to,
1730: comparison_operator,
1731: TO_NUMBER(NULL) ---object_version_number not in order table
1732: FROM okx_ord_prc_adj_atrbs_v
1733: WHERE cp_o_flag = OKC_API.G_TRUE
1734: AND price_adjustment_id = cp_old_pat_id;
1735:
1736: l_source_paav_rec c_source_paav_rec%ROWTYPE;

Line 3408: OKX_ORD_PRC_ADJ_ATRBS_V opadj

3404: kpadj.pricing_attr_value_to,
3405: kpadj.comparison_operator
3406: FROM
3407: okc_price_adj_attribs kpadj,
3408: OKX_ORD_PRC_ADJ_ATRBS_V opadj
3409: WHERE
3410: b_o_flag = OKC_API.g_true
3411: AND kpadj.pat_id = b_kpat_id
3412: AND opadj.price_adjustment_id(+) = b_pat_id

Line 3446: FROM OKX_ORD_PRC_ADJ_ATRBS_V opadj

3442: opadj.pricing_attribute,
3443: opadj.pricing_attr_value_from,
3444: opadj.pricing_attr_value_to,
3445: opadj.comparison_operator
3446: FROM OKX_ORD_PRC_ADJ_ATRBS_V opadj
3447: WHERE b_o_flag = OKC_API.g_true
3448: AND opadj.price_adjustment_id = b_pat_id;
3449:
3450: