DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_LA_COV_ASSET_UV

Line 714: FROM okl_la_cov_asset_uv

710:
711: CURSOR srv_csr (p_serv_top_line_id NUMBER) IS
712: SELECT item_id inventory_item_id,
713: SUM(service_item_qty) quantity
714: FROM okl_la_cov_asset_uv
715: WHERE serv_top_line_id = p_serv_top_line_id
716: GROUP BY item_id;
717:
718: l_lne l_lne_csr%ROWTYPE;

Line 896: FROM okl_la_cov_asset_uv

892:
893: CURSOR srv_amt_csr (p_serv_top_line_id NUMBER) IS
894: SELECT item_id inventory_item_id,
895: SUM(NVL(price_negotiated,0)) amount
896: FROM okl_la_cov_asset_uv
897: WHERE serv_top_line_id = p_serv_top_line_id
898: GROUP BY item_id;
899:
900: l_lne l_toplne_csr%ROWTYPE;