DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 619: ,mtl_system_items_b mtl --Okx_system_items_v mtl

615: ,mtl.usage_item_flag
616: ,mtl.service_item_flag
617: ,mtl.primary_uom_code
618: FROM Okc_K_items Item
619: ,mtl_system_items_b mtl --Okx_system_items_v mtl
620: WHERE item.cle_id = p_cle_id
621: --AND mtl.id1 = item.object1_id1
622: AND mtl.inventory_item_id = item.object1_id1
623: AND mtl.organization_id = p_org_id;

Line 3640: ,mtl_system_items_b mtl --Okx_system_items_v mtl

3636: ,mtl.usage_item_flag
3637: ,mtl.service_item_flag
3638: ,mtl.primary_uom_code
3639: FROM Okc_K_items Item
3640: ,mtl_system_items_b mtl --Okx_system_items_v mtl
3641: WHERE item.cle_id = p_cle_id
3642: --AND mtl.id1 = item.object1_id1
3643: AND mtl.inventory_item_id = item.object1_id1
3644: AND mtl.organization_id = p_org_id;

Line 5417: ,mtl_system_items_b mtl --Okx_system_items_v mtl

5413: ,mtl.usage_item_flag
5414: ,mtl.service_item_flag
5415: ,mtl.primary_uom_code
5416: FROM Okc_K_items Item
5417: ,mtl_system_items_b mtl --Okx_system_items_v mtl
5418: WHERE item.cle_id = p_cle_id
5419: --AND mtl.id1 = item.object1_id1
5420: AND mtl.inventory_item_id = item.object1_id1
5421: AND mtl.organization_id = p_org_id;