APPS.OKS_EXTWAR_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 883: FROM mtl_system_items_b_kfv b, --okx_system_items_v mtl,

879: CURSOR bom_dtls_csr
880: IS
881: SELECT bic.component_quantity, b.primary_uom_code,
882: b.coverage_schedule_id coverage_template_id
883: FROM mtl_system_items_b_kfv b, --okx_system_items_v mtl,
884: bom_inventory_components bic --okx_inv_components_v bic
885: WHERE bic.component_item_id = b.inventory_item_id
886: AND b.organization_id = okc_context.get_okc_organization_id
887: AND bic.bill_sequence_id = p_comm_bill_seq_id

Line 994: FROM mtl_system_items_b_kfv

990:
991: CURSOR get_ship_csr
992: IS
993: SELECT service_starting_delay
994: FROM mtl_system_items_b_kfv
995: WHERE inventory_item_id = p_prod_item_id
996: AND organization_id = okc_context.get_okc_organization_id;
997:
998: CURSOR get_ship_flag_csr

Line 1920: FROM mtl_system_items_b_kfv b,

1916: CURSOR l_segment_csr (p_org_id NUMBER)
1917: IS
1918: SELECT t.description NAME,
1919: b.concatenated_segments description
1920: FROM mtl_system_items_b_kfv b,
1921: mtl_system_items_tl t
1922: WHERE
1923: b.inventory_item_id = t.inventory_item_id
1924: AND b.organization_id = t.organization_id

Line 2154: mtl_system_items_b_kfv b,

2150: ol.tax_exempt_number, -- Bug#5008188 - vjramali
2151: ol.tax_exempt_reason_code,
2152: ol.tax_code, ol.tax_exempt_flag -- End Bug#5008188
2153: FROM oe_order_lines_all ol,
2154: mtl_system_items_b_kfv b,
2155: mtl_system_items_tl t
2156: WHERE ol.line_id = p_order_line_id
2157: AND b.inventory_item_id = ol.inventory_item_id
2158: AND b.inventory_item_id = t.inventory_item_id

Line 2878: From MTL_SYSTEM_ITEMS_B_KFV -- OKX_SYSTEM_ITEMS_V

2874: WHERE okl.ID = p_line_id AND okl.cle_id IS NOT NULL);
2875:
2876: /*Cursor l_serv_Csr(p_serv_id NUMBER) is
2877: Select COVERAGE_SCHEDULE_ID coverage_template_id
2878: From MTL_SYSTEM_ITEMS_B_KFV -- OKX_SYSTEM_ITEMS_V
2879: WHere INVENTORY_ITEM_ID = p_serv_id;
2880: */
2881: CURSOR l_serv_csr (p_serv_id NUMBER)
2882: IS

Line 2885: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

2881: CURSOR l_serv_csr (p_serv_id NUMBER)
2882: IS
2883: SELECT t.description NAME, b.concatenated_segments description,
2884: b.coverage_schedule_id coverage_template_id
2885: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
2886: WHERE b.inventory_item_id = t.inventory_item_id
2887: AND b.organization_id = t.organization_id
2888: AND t.LANGUAGE = USERENV ('LANG')
2889: AND b.inventory_item_id = p_serv_id

Line 3680: mtl_system_items_b_kfv b,

3676: ,
3677: b.coverage_schedule_id coverage_template_id
3678: -- mtl.coverage_template_id
3679: FROM csi_item_instances csi,
3680: mtl_system_items_b_kfv b,
3681: mtl_system_items_tl t --okx_system_items_v mtl
3682: WHERE csi.instance_id = p_cpid
3683: AND csi.inventory_item_id = b.inventory_item_id
3684: AND b.inventory_item_id = t.inventory_item_id