DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 536: ,mtl_system_items_b mtl --Okx_system_items_v mtl

532: ,mtl.usage_item_flag
533: ,mtl.service_item_flag
534: ,mtl.primary_uom_code
535: FROM Okc_K_items Item
536: ,mtl_system_items_b mtl --Okx_system_items_v mtl
537: WHERE item.cle_id = p_cle_id
538: --AND mtl.id1 = item.object1_id1
539: AND mtl.inventory_item_id = item.object1_id1
540: AND mtl.organization_id = p_org_id;

Line 2356: ,mtl_system_items_b mtl --Okx_system_items_v mtl

2352: ,mtl.usage_item_flag
2353: ,mtl.service_item_flag
2354: ,mtl.primary_uom_code
2355: FROM Okc_K_items Item
2356: ,mtl_system_items_b mtl --Okx_system_items_v mtl
2357: WHERE item.cle_id = p_cle_id
2358: --AND mtl.id1 = item.object1_id1
2359: AND mtl.inventory_item_id = item.object1_id1
2360: AND mtl.organization_id = p_org_id;