APPS.OKS_CONTRACTS_PUB dependencies on OKX_SYSTEM_ITEMS_V

Line 3473: FROM okx_system_items_v

3469: WHERE id = p_header_id;
3470:
3471: CURSOR l_template_csr (p_srv_id NUMBER, p_orgid NUMBER) IS
3472: SELECT coverage_template_id
3473: FROM okx_system_items_v
3474: WHERE id1 = p_srv_id
3475: AND organization_id = p_orgid;
3476:
3477:

Line 4615: From OKX_SYSTEM_ITEMS_V MTL

4611:
4612: Cursor l_mtl_csr(p_inventory_id Number, p_organization_id Number) Is
4613: Select MTL.SERVICE_ITEM_FLAG
4614: ,MTL.USAGE_ITEM_FLAG
4615: From OKX_SYSTEM_ITEMS_V MTL
4616: Where MTL.id1 = p_Inventory_id
4617: And MTL.Organization_id = p_organization_id;
4618:
4619: l_mtl_rec l_mtl_csr%rowtype;

Line 5332: From OKX_SYSTEM_ITEMS_V MTL

5328: Select MTL.Name
5329: ,MTL.Description
5330: ,MTL.Primary_UOM_Code
5331: ,MTL.Service_starting_delay
5332: From OKX_SYSTEM_ITEMS_V MTL
5333: Where MTL.id1 = p_Inventory_id
5334: And MTL.Organization_id = okc_context.get_okc_organization_id;
5335:
5336: l_line_dtl_rec l_line_csr%rowtype;