APPS.OKC_OC_INT_PRICING_PVT dependencies on OKX_ORD_PRC_ADJ_RLSHP_V

Line 1525: -- okx_ord_prc_adj_rlshp_v information

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

Line 1545: -- second query to get okx_ord_prc_adj_rlshp_v information

1541: AND price_adjustment_id = cp_old_pat_id
1542:
1543: UNION ALL
1544:
1545: -- second query to get okx_ord_prc_adj_rlshp_v information
1546: SELECT --------price_adjustment_id, --not needed
1547: price_adjustment_id,
1548: rltd_price_adj_id,
1549: line_id source_line_id,

Line 1551: FROM okx_ord_prc_adj_rlshp_v

1547: price_adjustment_id,
1548: rltd_price_adj_id,
1549: line_id source_line_id,
1550: TO_NUMBER(NULL) ----object_version_number --not in order table
1551: FROM okx_ord_prc_adj_rlshp_v
1552: WHERE cp_o_flag = OKC_API.G_TRUE
1553: AND price_adjustment_id = cp_old_pat_id;
1554:
1555: l_source_pacv_rec c_source_pacv_rec%ROWTYPE;

Line 4287: FROM OKX_ORD_PRC_ADJ_RLSHP_V opadj

4283: opadj.PRICE_ADJ_ASSOC_ID, -- PRICE_ADJ_ASSOC_ID, -- quote price adj rltship ID
4284: opadj.price_adjustment_id,
4285: to_number(NULL), --qpadj.quote_shipment_id
4286: opadj.line_id
4287: FROM OKX_ORD_PRC_ADJ_RLSHP_V opadj
4288: WHERE b_o_flag = OKC_API.g_true
4289: AND opadj.rltd_price_adj_id = b_pat_id;
4290:
4291:

Line 4314: FROM OKX_ORD_PRC_ADJ_RLSHP_V opadj

4310: opadj.price_adjustment_id,
4311: to_number(NULL), --qpadj.quote_shipment_id
4312: opadj.line_id,
4313: opadj.rltd_price_adj_id
4314: FROM OKX_ORD_PRC_ADJ_RLSHP_V opadj
4315: WHERE b_o_flag = OKC_API.g_true
4316: AND opadj.price_adjustment_id = b_pat_id
4317: AND ((b_ln_id IS NOT NULL AND opadj.line_id = b_ln_id) OR b_ln_id IS NULL);
4318: