DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKS_K_ORDER_DETAILS

Line 404: FROM oks_k_order_details_v

400: markup_percent, price_list_id1, line_renewal_type,
401: link_chr_id, contact_id, site_id, email_id, phone_id, fax_id,
402: billing_profile_id --new parameter added -vigandhi (May29-02)
403: ,RENEWAL_APPROVAL_FLAG --Bug# 5173373
404: FROM oks_k_order_details_v
405: WHERE order_line_id1 = TO_CHAR (p_order_line_id);
406:
407: -- Fix for bug# 4690982
408:

Line 4144: FROM oks_k_order_details

4140: IS
4141: CURSOR l_link_csr1
4142: IS
4143: SELECT NVL (link_ord_line_id1, order_line_id1)
4144: FROM oks_k_order_details
4145: WHERE order_line_id1 = TO_CHAR (p_order_line_id);
4146:
4147: CURSOR l_link_csr_a (l_link_ord_id VARCHAR2)
4148: IS

Line 4150: FROM oks_k_order_details

4146:
4147: CURSOR l_link_csr_a (l_link_ord_id VARCHAR2)
4148: IS
4149: SELECT ID, order_line_id1, object_version_number
4150: FROM oks_k_order_details
4151: WHERE link_ord_line_id1 = l_link_ord_id AND chr_id IS NULL;
4152:
4153: CURSOR l_link_csr_b (l_link_ord_id VARCHAR2)
4154: IS

Line 4156: FROM oks_k_order_details

4152:
4153: CURSOR l_link_csr_b (l_link_ord_id VARCHAR2)
4154: IS
4155: SELECT ID, order_line_id1, object_version_number
4156: FROM oks_k_order_details
4157: WHERE order_line_id1 = l_link_ord_id AND chr_id IS NULL;
4158:
4159: l_link_rec1 l_link_csr_a%ROWTYPE;
4160: l_link_rec2 l_link_csr_b%ROWTYPE;