[Home] [Help]
85: --<
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:
1192: --------------l_no_data_found BOOLEAN := TRUE;
1193:
1194: i BINARY_INTEGER := 0;
1195:
1196: --cursor to get okx_qte_prc_adjmnts_v or
1197: -- okx_ord_prc_adjmnts_v information
1198: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1199: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
1200: CURSOR c_source_patv_rec (cp_q_flag IN VARCHAR2,
1206: --could be either ASO or ONT
1207: --only ONE of the following two queries in the union will be executed in
1208: --a call depending on which flag (p_q_flag or p_o_flag) is true
1209:
1210: -- first query to get okx_qte_prc_adjmnts_v information
1211: SELECT --parent_adjustment_id, --not used
1212: pa.price_adjustment_id price_adjustment_id,
1213: pa.quote_header_id source_header_id,
1214: pa.quote_line_id source_line_id,
1266: pa.attribute13 attribute13,
1267: pa.attribute14 attribute14,
1268: pa.attribute15 attribute15,
1269: pa.rebate_transaction_type_code rebate_transaction_type_code
1270: FROM okx_qte_prc_adjmnts_v pa,
1271: qp_list_lines ql,
1272: qp_list_headers_b qh
1273: WHERE cp_q_flag = OKC_API.G_TRUE
1274: AND pa.quote_header_id = cp_qhr_id
2393: b_o_flag VARCHAR, b_oh_id NUMBER, b_ol_id NUMBER) IS
2394: SELECT
2395: qpadj.PRICE_ADJUSTMENT_ID -- quote(header or line) price adj ID
2396: FROM
2397: OKX_QTE_PRC_ADJMNTS_V qpadj
2398: WHERE
2399: b_q_flag = OKC_API.G_TRUE
2400: AND qpadj.quote_header_id = b_qh_id
2401: AND ((b_ql_id IS NULL AND qpadj.quote_line_id IS NULL) OR
2485: kpadj.rebate_transaction_type_code,
2486: kpadj.creation_date
2487: FROM
2488: OKC_PRICE_ADJUSTMENTS kpadj,
2489: OKX_QTE_PRC_ADJMNTS_V qpadj
2490: WHERE
2491: b_q_flag = OKC_API.g_true
2492: AND (kpadj.chr_id = b_kh_id)
2493: AND ((b_kl_id IS NULL and kpadj.cle_id IS NULL ) OR (b_kl_id IS NOT NULL AND kpadj.cle_id = b_kl_id))