APPS.OKC_OC_INT_SALESCDT_PVT dependencies on OKX_ORD_SLS_CREDITS_V

Line 500: -- okx_ord_sls_credits_v information

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

Line 534: -- second query to get okx_ord_sls_credits_v information

530: AND b.org_id = SYS_CONTEXT('OKC_CONTEXT', 'ORG_ID')
531:
532: UNION ALL
533:
534: -- second query to get okx_ord_sls_credits_v information
535: SELECT header_id source_header_id,
536: line_id source_line_id,
537: percent,
538: salesrep_id,

Line 544: FROM okx_ord_sls_credits_v

540: TO_NUMBER(NULL),
541: sales_credit_type_id,
542: TO_CHAR(NULL),
543: TO_NUMBER(NULL) --object_version_number not present in order table
544: FROM okx_ord_sls_credits_v
545: WHERE cp_o_flag = OKC_API.G_TRUE
546: AND header_id = cp_ohr_id
547: AND ((cp_ole_id = OKC_API.G_MISS_NUM AND line_id IS NULL) OR
548: (cp_ole_id <> OKC_API.G_MISS_NUM AND line_id = cp_ole_id));

Line 605: -- okx_ord_sls_credits_v to OKC_K_SALES_CREDITS

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:
609: IF l_source_sales_credit_rec.source_header_id IS NOT NULL THEN

Line 783: OKX_ORD_SLS_CREDITS_V oscdt

779:
780: SELECT
781: oscdt.sales_credit_id SALES_CREDIT_ID -- order (header or line) sales credit ID
782: FROM
783: OKX_ORD_SLS_CREDITS_V oscdt
784: WHERE b_o_flag = OKC_API.g_true
785: AND oscdt.header_id = b_oh_id
786: AND ((b_ol_id IS NULL AND oscdt.line_id IS NULL)
787: OR (b_ol_id IS NOT NULL AND oscdt.line_id = b_ql_id));

Line 849: OKX_ORD_SLS_CREDITS_V oscdt

845: kscdt.last_update_date
846: -- kscdt.object_version_number
847: FROM
848: OKC_K_SALES_CREDITS kscdt,
849: OKX_ORD_SLS_CREDITS_V oscdt
850: -- OKX_SALESREPS_V sr
851: WHERE
852: b_o_flag = OKC_API.G_TRUE
853: AND kscdt.chr_id = b_kh_id