APPS.OKS_OCINT_PUB dependencies on OKX_ORDER_LINES_V

Line 154: FROM okx_order_lines_v

150: IS
151: SELECT org_id, ship_from_org_id, sold_from_org_id,
152: NVL (fulfilled_quantity, 0) fqty,
153: service_reference_line_id rolineid, header_id
154: FROM okx_order_lines_v
155: WHERE id1 = (p_ordlineid);
156:
157: CURSOR check_ordline_exists (p_ordlineid NUMBER)
158: IS

Line 688: FROM okx_order_lines_v

684: IS
685: SELECT org_id, ship_from_org_id, sold_from_org_id,
686: NVL (fulfilled_quantity, 0) fqty,
687: service_reference_line_id rolineid, header_id
688: FROM okx_order_lines_v
689: WHERE id1 = (p_ordlineid);
690:
691: CURSOR l_contract_csr (p_ordlineid NUMBER)
692: IS

Line 738: FROM okx_order_lines_v

734:
735: CURSOR l_serv_ref_csr (p_ordline_id NUMBER)
736: IS
737: SELECT service_reference_type_code, service_reference_line_id
738: FROM okx_order_lines_v
739: WHERE id1 = p_ordline_id;
740:
741: CURSOR l_contract_line_csr (p_subline_id NUMBER)
742: IS

Line 4502: FROM okx_order_lines_v

4498: IS
4499: SELECT org_id, ship_from_org_id, sold_from_org_id,
4500: NVL (fulfilled_quantity, 0) fqty,
4501: service_reference_line_id rolineid, header_id
4502: FROM okx_order_lines_v
4503: WHERE id1 = (p_ordlineid);
4504:
4505: CURSOR check_ordline_exists (p_ordlineid NUMBER)
4506: IS