APPS.OKC_OC_INT_PRICING_PVT dependencies on OKX_ORD_PRC_ATRBS_V

Line 1856: -------remove later l_ont_pavv_rec okx_ord_prc_atrbs_v%ROWTYPE;

1852:
1853: l_no_data_found BOOLEAN := TRUE;
1854:
1855: ------remove later l_aso_pavv_rec okx_qte_prc_atrbs_v%ROWTYPE;
1856: -------remove later l_ont_pavv_rec okx_ord_prc_atrbs_v%ROWTYPE;
1857: i BINARY_INTEGER := 0;
1858:
1859: -- cursor to get okx_qte_prc_atrbs_v or
1860: -- okx_ord_prc_atrbs_v information

Line 1860: -- okx_ord_prc_atrbs_v information

1856: -------remove later l_ont_pavv_rec okx_ord_prc_atrbs_v%ROWTYPE;
1857: i BINARY_INTEGER := 0;
1858:
1859: -- cursor to get okx_qte_prc_atrbs_v or
1860: -- okx_ord_prc_atrbs_v information
1861: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1862: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
1863: CURSOR c_source_pavv_rec (cp_q_flag IN VARCHAR2,
1864: cp_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE,

Line 2003: -- second query to get okx_ord_prc_atrbs_v information

1999: (cp_qle_id <> OKC_API.G_MISS_NUM AND quote_line_id = cp_qle_id))
2000:
2001: UNION ALL
2002:
2003: -- second query to get okx_ord_prc_atrbs_v information
2004: SELECT header_id source_header_id,
2005: line_id source_line_id,
2006: flex_title,
2007: pricing_context,

Line 2125: FROM okx_ord_prc_atrbs_v

2121: attribute13,
2122: attribute14,
2123: attribute15,
2124: TO_NUMBER(NULL) --object_version_number not present in order table
2125: FROM okx_ord_prc_atrbs_v
2126: WHERE cp_o_flag = OKC_API.G_TRUE
2127: AND header_id = cp_ohr_id
2128: AND ((cp_ole_id = OKC_API.G_MISS_NUM AND line_id IS NULL) OR
2129: (cp_ole_id <> OKC_API.G_MISS_NUM AND line_id = cp_ole_id));

Line 2175: -- okx_ord_prc_atrbs_v to OKC_PRICE_ATT_VALUES

2171: FETCH c_source_pavv_rec INTO l_source_pavv_rec;
2172: EXIT WHEN c_source_pavv_rec%NOTFOUND;
2173:
2174: -- map okx_qte_prc_atrbs_v or
2175: -- okx_ord_prc_atrbs_v to OKC_PRICE_ATT_VALUES
2176:
2177: -- we don't need to enter the ID because it is automatically generated
2178:
2179: IF l_source_pavv_rec.source_header_id IS NOT NULL THEN--quote or order

Line 3879: OKX_ORD_PRC_ATRBS_V opattr

3875:
3876: SELECT
3877: opattr.ORDER_PRICE_ATTRIB_ID -- order header price attribute id
3878: FROM
3879: OKX_ORD_PRC_ATRBS_V opattr
3880: WHERE b_o_flag = OKC_API.G_TRUE
3881: AND opattr.header_id = b_oh_id
3882: AND (( b_ol_id IS NULL AND opattr.line_id IS NULL ) OR
3883: (b_ol_id IS NOT NULL AND opattr.line_id = b_ol_id ));