APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 759: FROM okx_system_items_v mtl

755: FROM bom_inventory_components bic --OKX_INV_COMPONENTS_V bic
756: WHERE bic.bill_sequence_id = c_bill_seq_id
757: AND EXISTS (
758: SELECT 'Component is a Warranty'
759: FROM okx_system_items_v mtl
760: WHERE mtl.id2 = okc_context.get_okc_organization_id
761: AND mtl.id1 = bic.component_item_id
762: AND mtl.vendor_warranty_flag = 'Y')
763: AND TRUNC (p_datec) >= TRUNC (bic.effectivity_date)

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 1016: From OKX_SYSTEM_ITEMS_V mtl

1012: Where bic.bill_sequence_id = C_bill_seq_id
1013: And exists
1014: (
1015: Select 'Component is a Warranty'
1016: From OKX_SYSTEM_ITEMS_V mtl
1017: Where mtl.id2 = okc_context.get_okc_organization_id
1018: And mtl.id1 = bic.component_item_id
1019: And mtl.vendor_warranty_flag = 'Y'
1020: )

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 3527: FROM okx_system_items_v

3523:
3524: CURSOR get_ship_csr
3525: IS
3526: SELECT shippable_item_flag, service_starting_delay
3527: FROM okx_system_items_v
3528: WHERE id1 = p_prod_item_id
3529: AND organization_id = okc_context.get_okc_organization_id;
3530: BEGIN
3531: okc_context.set_okc_org_context (p_org_id => p_org_id,

Line 3681: mtl_system_items_tl t --okx_system_items_v mtl

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
3685: AND b.organization_id = t.organization_id