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 3858: FROM okx_order_lines_v

3854: IS
3855: SELECT org_id, ship_from_org_id, sold_from_org_id,
3856: NVL (fulfilled_quantity, 0) fqty,
3857: service_reference_line_id rolineid, header_id
3858: FROM okx_order_lines_v
3859: WHERE id1 = (p_ordlineid);
3860:
3861: CURSOR check_ordline_exists (p_ordlineid NUMBER)
3862: IS