APPS.OKC_OC_INT_SALESCDT_PVT dependencies on OKX_QTE_SLS_CREDITS_V

Line 41: okx_qte_sls_credits_v

37:
38:
39:
40: The OKX related quote pricing views concerned are:
41: okx_qte_sls_credits_v
42:
43:
44: Flow:
45: |---OKC_OC_INT_SALESCDT_PVT.create_k_sales_credit()

Line 499: -- cursor to get okx_qte_sls_credits_v or

495: l_no_data_found BOOLEAN := TRUE;
496:
497: i BINARY_INTEGER := 0;
498:
499: -- cursor to get okx_qte_sls_credits_v or
500: -- okx_ord_sls_credits_v information
501: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
502: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
503: CURSOR c_source_sales_credit_rec (cp_q_flag IN VARCHAR2,

Line 513: -- first query to get okx_qte_sls_credits_v information

509: --could be either ASO or ONT
510: --only ONE of the following two queries in the union will be executed in
511: --a call depending on which flag (p_q_flag or p_o_flag) is true
512:
513: -- first query to get okx_qte_sls_credits_v information
514: SELECT a.quote_header_id source_header_id,
515: a.quote_line_id source_line_id,
516: a.percent,
517: b.id1 salesrep_id,

Line 523: FROM okx_qte_sls_credits_v a

519: -----employee_person_id, --obsolete column in ASO replace by resource id
520: a.sales_credit_type_id,
521: a.attribute_category_code, --new column needed in OKC
522: a.object_version_number
523: FROM okx_qte_sls_credits_v a
524: ,okx_salesreps_v b
525: WHERE cp_q_flag = OKC_API.G_TRUE
526: AND a.quote_header_id = cp_qhr_id
527: AND ((cp_qle_id = OKC_API.G_MISS_NUM AND a.quote_line_id IS NULL) OR

Line 604: -- map okx_qte_sls_credits_v or

600: i := g_sales_credit_tab.COUNT + 1;
601: FETCH c_source_sales_credit_rec INTO l_source_sales_credit_rec;
602: EXIT WHEN c_source_sales_credit_rec%NOTFOUND;
603:
604: -- map okx_qte_sls_credits_v or
605: -- okx_ord_sls_credits_v to OKC_K_SALES_CREDITS
606:
607: -- we don't need to enter the ID because it is automatically generated
608:

Line 773: OKX_QTE_SLS_CREDITS_V qscdt

769: b_o_flag VARCHAR, b_oh_id NUMBER, b_ol_id NUMBER) IS
770: SELECT
771: qscdt.sales_credit_id SALES_CREDIT_ID -- quote (header or line) sales credit ID
772: FROM
773: OKX_QTE_SLS_CREDITS_V qscdt
774: WHERE b_q_flag = OKC_API.g_true
775: AND qscdt.quote_header_id = b_qh_id
776: AND ((b_ql_id IS NULL AND qscdt.quote_line_id IS NULL)
777: OR (b_ql_id IS NOT NULL AND qscdt.quote_line_id = b_ql_id))

Line 812: OKX_QTE_SLS_CREDITS_V qscdt,

808: kscdt.last_update_date
809: -- kscdt.object_version_number
810: FROM
811: OKC_K_SALES_CREDITS kscdt,
812: OKX_QTE_SLS_CREDITS_V qscdt,
813: OKX_SALESREPS_V sr
814: WHERE
815: b_q_flag = OKC_API.G_TRUE
816: AND kscdt.chr_id = b_kh_id