DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on OKX_SYSTEM_ITEMS_V

Line 334: From OKX_SYSTEM_ITEMS_V MTL

330: Select MTL.Name
331: ,MTL.Description
332: ,MTL.Primary_UOM_Code
333: ,MTL.Service_starting_delay
334: From OKX_SYSTEM_ITEMS_V MTL
335: Where MTL.id1 = p_Inventory_id
336: And MTL.Organization_id = okc_context.get_okc_organization_id;
337:
338: Cursor l_org_csr (p_line_id Number) Is

Line 3665: FROM okx_system_items_v mtl,

3661:
3662: CURSOR svc_desc_csr (p_svc_line_id NUMBER)
3663: IS
3664: SELECT MTL.Name,MTL.Description
3665: FROM okx_system_items_v mtl,
3666: okc_k_items oki
3667: WHERE mtl.id1 = oki.object1_id1
3668: AND mtl.organization_id = oki.object1_id2
3669: AND oki.cle_id = p_svc_line_id;