DBA Data[Home] [Help]

APPS.OKC_OC_INT_SALESCDT_PVT dependencies on OKX_SALESREPS_V

Line 524: ,okx_salesreps_v b

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
528: (cp_qle_id <> OKC_API.G_MISS_NUM AND a.quote_line_id = cp_qle_id))

Line 813: OKX_SALESREPS_V sr

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
817: AND ((b_kl_id IS NULL AND kscdt.cle_id IS NULL)

Line 850: -- OKX_SALESREPS_V sr

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
854: AND ((b_kl_id IS NULL AND kscdt.cle_id IS NULL)