APPS.OKC_OC_INT_PRICING_PVT dependencies on OKX_ORD_PRC_ADJMNTS_V

Line 1197: -- okx_ord_prc_adjmnts_v information

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,
1201: cp_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE,

Line 1282: UNION ALL -- second query to get okx_ord_prc_adjmnts_v information

1278: AND pa.modifier_header_id = qh.list_header_id
1279: AND pa.modifier_line_id = ql.list_line_id
1280: AND ( pa.applied_flag IS NULL OR pa.applied_flag = 'Y' ) -- Bug 2801279
1281:
1282: UNION ALL -- second query to get okx_ord_prc_adjmnts_v information
1283:
1284: SELECT ------price_adjustment_id, --not used
1285: pa.price_adjustment_id,
1286: pa.header_id source_header_id,

Line 1340: FROM okx_ord_prc_adjmnts_v pa,

1336: pa.attribute13,
1337: pa.attribute14,
1338: pa.attribute15,
1339: pa.rebate_transaction_type_code
1340: FROM okx_ord_prc_adjmnts_v pa,
1341: qp_list_lines ql,
1342: qp_list_headers_b qh
1343: WHERE cp_o_flag = OKC_API.G_TRUE
1344: AND pa.header_id = cp_ohr_id

Line 2409: OKX_ORD_PRC_ADJMNTS_V opadj

2405:
2406: SELECT
2407: PRICE_ADJUSTMENT_ID -- quote(header or line) price adj ID
2408: FROM
2409: OKX_ORD_PRC_ADJMNTS_V opadj
2410: WHERE
2411: b_o_flag = OKC_API.G_TRUE
2412: AND opadj.header_id = b_oh_id
2413: AND ((b_ol_id IS NULL AND opadj.line_id IS NULL) OR

Line 2569: OKX_ORD_PRC_ADJMNTS_V opadj

2565: kpadj.rebate_transaction_type_code,
2566: kpadj.creation_date
2567: FROM
2568: OKC_PRICE_ADJUSTMENTS kpadj,
2569: OKX_ORD_PRC_ADJMNTS_V opadj
2570: WHERE
2571: b_o_flag = OKC_API.g_true
2572: AND (kpadj.chr_id = b_kh_id)
2573: 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))