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 995: FROM mtl_system_items_b_kfv

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

Line 1924: FROM mtl_system_items_b_kfv b,

1920: CURSOR l_segment_csr (p_org_id NUMBER)
1921: IS
1922: SELECT t.description NAME,
1923: b.concatenated_segments description
1924: FROM mtl_system_items_b_kfv b,
1925: mtl_system_items_tl t
1926: WHERE
1927: b.inventory_item_id = t.inventory_item_id
1928: AND b.organization_id = t.organization_id

Line 2159: mtl_system_items_b_kfv b,

2155: ol.tax_exempt_reason_code,
2156: ol.tax_code, ol.tax_exempt_flag, -- End Bug#5008188
2157: b.contract_item_type_code ----Added for ER 16039680
2158: FROM oe_order_lines_all ol,
2159: mtl_system_items_b_kfv b,
2160: mtl_system_items_tl t
2161: WHERE ol.line_id = p_order_line_id
2162: AND b.inventory_item_id = ol.inventory_item_id
2163: AND b.inventory_item_id = t.inventory_item_id

Line 2924: From MTL_SYSTEM_ITEMS_B_KFV -- OKX_SYSTEM_ITEMS_V

2920: WHERE okl.ID = p_line_id AND okl.cle_id IS NOT NULL);
2921:
2922: /*Cursor l_serv_Csr(p_serv_id NUMBER) is
2923: Select COVERAGE_SCHEDULE_ID coverage_template_id
2924: From MTL_SYSTEM_ITEMS_B_KFV -- OKX_SYSTEM_ITEMS_V
2925: WHere INVENTORY_ITEM_ID = p_serv_id;
2926: */
2927: CURSOR l_serv_csr (p_serv_id NUMBER)
2928: IS

Line 2931: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

2927: CURSOR l_serv_csr (p_serv_id NUMBER)
2928: IS
2929: SELECT t.description NAME, b.concatenated_segments description,
2930: b.coverage_schedule_id coverage_template_id
2931: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
2932: WHERE b.inventory_item_id = t.inventory_item_id
2933: AND b.organization_id = t.organization_id
2934: AND t.LANGUAGE = USERENV ('LANG')
2935: AND b.inventory_item_id = p_serv_id

Line 3726: mtl_system_items_b_kfv b,

3722: ,
3723: b.coverage_schedule_id coverage_template_id
3724: -- mtl.coverage_template_id
3725: FROM csi_item_instances csi,
3726: mtl_system_items_b_kfv b,
3727: mtl_system_items_tl t --okx_system_items_v mtl
3728: WHERE csi.instance_id = p_cpid
3729: AND csi.inventory_item_id = b.inventory_item_id
3730: AND b.inventory_item_id = t.inventory_item_id