APPS.OKC_OC_INT_PRICING_PVT dependencies on OKX_QTE_PRC_ADJ_RLSHP_V

Line 91: okx_qte_prc_adj_rlshp_v

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()
95: | |---get_price_attr() called twice at header level AND line level

Line 1524: -- cursor to get okx_qte_prc_adj_rlshp_v and

1520: j BINARY_INTEGER := 0;
1521: l_cle_found_flg BOOLEAN := FALSE;
1522: l_pat_id_found_flg BOOLEAN := FALSE;
1523:
1524: -- cursor to get okx_qte_prc_adj_rlshp_v and
1525: -- okx_ord_prc_adj_rlshp_v information
1526: CURSOR c_source_pacv_rec (cp_q_flag IN VARCHAR2,
1527: cp_o_flag IN VARCHAR2,
1528: cp_old_pat_id IN NUMBER) IS

Line 1533: -- first query to get okx_qte_prc_adj_rlshp_v information

1529: --could be either ASO or ONT
1530: --only ONE of the following two queries in the union will be executed in
1531: --a call depending on which flag (p_q_flag or p_o_flag) is true
1532:
1533: -- first query to get okx_qte_prc_adj_rlshp_v information
1534: SELECT ----price_adjustment_id, --not needed
1535: price_adjustment_id,
1536: rltd_price_adj_id,
1537: quote_line_id source_line_id,

Line 1539: FROM okx_qte_prc_adj_rlshp_v

1535: price_adjustment_id,
1536: rltd_price_adj_id,
1537: quote_line_id source_line_id,
1538: object_version_number
1539: FROM okx_qte_prc_adj_rlshp_v
1540: WHERE cp_q_flag = OKC_API.G_TRUE
1541: AND price_adjustment_id = cp_old_pat_id
1542:
1543: UNION ALL

Line 4276: FROM OKX_QTE_PRC_ADJ_RLSHP_V qpadj

4272: qpadj.ADJ_RELATIONSHIP_ID, --quote or order price adj rltship ID
4273: qpadj.price_adjustment_id PRICE_ADJUSTMENT_ID,
4274: qpadj.quote_shipment_id SHIPMENT_ID,
4275: qpadj.quote_line_id LINE_ID
4276: FROM OKX_QTE_PRC_ADJ_RLSHP_V qpadj
4277: WHERE b_q_flag = OKC_API.g_true
4278: AND qpadj.rltd_price_adj_id = b_pat_id
4279:
4280: UNION

Line 4302: FROM OKX_QTE_PRC_ADJ_RLSHP_V qpadj

4298: qpadj.price_adjustment_id PRICE_ADJUSTMENT_ID,
4299: qpadj.quote_shipment_id SHIPMENT_ID,
4300: qpadj.quote_line_id LINE_ID,
4301: qpadj.rltd_price_adj_id
4302: FROM OKX_QTE_PRC_ADJ_RLSHP_V qpadj
4303: WHERE b_q_flag = OKC_API.g_true
4304: AND qpadj.price_adjustment_id = b_pat_id
4305: AND ((b_ln_id IS NOT NULL AND qpadj.quote_line_id = b_ln_id) OR b_ln_id IS NULL)
4306: