eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_OSP_ORDERS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 2365: SELECT 'x' FROM mtl_system_items_kfv MTL, ahl_workorders_osp_v WO

2361: p_service_item_id IN NUMBER,
2362: p_order_type_code IN VARCHAR2
2363: )IS
2364: CURSOR val_service_item_id_inv_csr(p_service_item_id IN VARCHAR2, p_workorder_id IN NUMBER) IS
2365: SELECT 'x' FROM mtl_system_items_kfv MTL, ahl_workorders_osp_v WO
2366: WHERE MTL.inventory_item_id = p_service_item_id
2367: AND MTL.enabled_flag = G_YES_FLAG
2368: AND MTL.inventory_item_flag = G_NO_FLAG
2369: AND MTL.stock_enabled_flag = G_NO_FLAG

Line 2466: SELECT 'x' FROM mtl_system_items_kfv MTL

2462: p_service_item_id IN NUMBER,
2463: p_service_item_description IN VARCHAR2
2464: ) IS
2465: CURSOR val_service_item_desc_csr(p_service_item_id IN VARCHAR2, p_service_item_description IN VARCHAR2) IS
2466: SELECT 'x' FROM mtl_system_items_kfv MTL
2467: WHERE MTL.inventory_item_id = p_service_item_id
2468: AND MTL.DESCRIPTION = p_service_item_description;
2469: l_exist VARCHAR2(1);
2470: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_service_item_desc';

Line 2500: SELECT 'x' FROM mtl_system_items_kfv MTL, ahl_workorders WO, AHL_VISITS_B VST

2496: p_workorder_id IN NUMBER,
2497: p_service_item_id IN NUMBER
2498: )IS
2499: CURSOR val_service_item_id_inv_csr(p_service_item_id IN VARCHAR2, p_workorder_id IN NUMBER) IS
2500: SELECT 'x' FROM mtl_system_items_kfv MTL, ahl_workorders WO, AHL_VISITS_B VST
2501: WHERE MTL.inventory_item_id = p_service_item_id
2502: AND MTL.enabled_flag = G_YES_FLAG
2503: AND MTL.inventory_item_flag = G_NO_FLAG
2504: AND MTL.stock_enabled_flag = G_NO_FLAG

Line 4442: mtl_system_items_kfv mtls,

4438: FROM ahl_workorders wo,
4439: ahl_visits_b vst,
4440: ahl_visit_tasks_b vts,
4441: csi_item_instances csii,
4442: mtl_system_items_kfv mtls,
4443: ahl_routes_b arb
4444: WHERE wo.workorder_id = c_workorder_id
4445: AND wo.visit_task_id = vts.visit_task_id
4446: AND vst.visit_id = vts.visit_id

Line 4531: FROM mtl_system_items_kfv

4527: --Assuming the org of service_item_id is the same as that of physical item
4528: --Alwasy set service_item_description to be derived from service_item_id if service_item_id is not null
4529: SELECT primary_uom_code, description,concatenated_segments, allow_item_desc_update_flag INTO
4530: l_temp_uom_code, l_item_description, l_svc_item_number, l_desc_update_flag
4531: FROM mtl_system_items_kfv
4532: WHERE inventory_item_id = p_x_osp_order_line_rec.service_item_id
4533: AND organization_id = p_x_osp_order_line_rec.inventory_org_id;
4534: EXCEPTION
4535: WHEN NO_DATA_FOUND THEN

Line 4569: FROM mtl_system_items_kfv

4565: FND_MSG_PUB.ADD;
4566: ELSE
4567: BEGIN
4568: SELECT concatenated_segments INTO l_inv_item_number
4569: FROM mtl_system_items_kfv
4570: WHERE inventory_item_id = p_x_osp_order_line_rec.inventory_item_id
4571: AND organization_id = p_x_osp_order_line_rec.inventory_org_id;
4572: EXCEPTION
4573: WHEN NO_DATA_FOUND THEN

Line 4988: FROM mtl_system_items_kfv

4984: primary_uom_code,
4985: serial_number_control_code,
4986: lot_control_code,
4987: comms_nl_trackable_flag
4988: FROM mtl_system_items_kfv
4989: WHERE inventory_item_id = c_inventory_item_id
4990: AND organization_id = c_inventory_org_id;
4991: l_check_physical_item check_physical_item%ROWTYPE;
4992: CURSOR check_sub_inventory(c_organization_id NUMBER, c_sub_inventory VARCHAR2) IS

Line 5085: mtl_system_items_kfv mtls,

5081: FROM ahl_workorders wo,
5082: ahl_visits_b vst,
5083: ahl_visit_tasks_b vts,
5084: csi_item_instances csii,
5085: mtl_system_items_kfv mtls,
5086: ahl_routes_b arb
5087: WHERE workorder_id = c_workorder_id
5088: AND wo.visit_task_id = vts.visit_task_id
5089: AND vst.visit_id = vts.visit_id

Line 5839: --Assuming service_item_id is always in mtl_system_items_kfv and its organization equals that of physical item

5835: --side.
5836:
5837: IF (p_x_osp_order_line_rec.service_item_id IS NOT NULL) THEN
5838: BEGIN
5839: --Assuming service_item_id is always in mtl_system_items_kfv and its organization equals that of physical item
5840: --Alwasy set service_item_description to be derived from service_item_id if service_item_id is not null
5841: --Changes made by mpothuku on 27-Mar-06 to fix the ER 4544654 and Bug 5013047
5842: SELECT description, allow_item_desc_update_flag, concatenated_segments INTO l_item_description, l_desc_update_flag, l_svc_item_number
5843: FROM mtl_system_items_kfv

Line 5843: FROM mtl_system_items_kfv

5839: --Assuming service_item_id is always in mtl_system_items_kfv and its organization equals that of physical item
5840: --Alwasy set service_item_description to be derived from service_item_id if service_item_id is not null
5841: --Changes made by mpothuku on 27-Mar-06 to fix the ER 4544654 and Bug 5013047
5842: SELECT description, allow_item_desc_update_flag, concatenated_segments INTO l_item_description, l_desc_update_flag, l_svc_item_number
5843: FROM mtl_system_items_kfv
5844: WHERE inventory_item_id = p_x_osp_order_line_rec.service_item_id
5845: AND organization_id = p_x_osp_order_line_rec.inventory_org_id;
5846: EXCEPTION
5847: WHEN NO_DATA_FOUND THEN

Line 5882: FROM mtl_system_items_kfv

5878: FND_MSG_PUB.ADD;
5879: ELSE
5880: BEGIN
5881: SELECT concatenated_segments INTO l_inv_item_number
5882: FROM mtl_system_items_kfv
5883: WHERE inventory_item_id = p_x_osp_order_line_rec.inventory_item_id
5884: AND organization_id = p_x_osp_order_line_rec.inventory_org_id;
5885: EXCEPTION
5886: WHEN NO_DATA_FOUND THEN

Line 5982: FROM mtl_system_items_kfv

5978: -- While for non tracked item, same physical item can only appear once in a given OSP order header
5979: IF (p_x_osp_order_line_rec.workorder_id IS NULL AND
5980: p_x_osp_order_line_rec.service_item_id <> l_osp_order_line_rec.service_item_id) THEN
5981: SELECT comms_nl_trackable_flag INTO l_trackable_flag
5982: FROM mtl_system_items_kfv
5983: WHERE inventory_item_id = p_x_osp_order_line_rec.inventory_item_id
5984: AND organization_id = p_x_osp_order_line_rec.inventory_org_id;
5985: /* Commented out by Jerry on 10/11/05 due to an issue found by Pavan
5986: IF (nvl(l_trackable_flag, 'N')='N') THEN

Line 6445: from mtl_system_items_kfv mtlsvc

6441: ospl.status_code, --status is not defined in the record because user can't directly change the status
6442: ospl.po_line_type_id, --no po_line_type here because it is not changeable once it is created(from a profile option)
6443: ospl.service_item_id,
6444: (select mtlsvc.concatenated_segments
6445: from mtl_system_items_kfv mtlsvc
6446: where mtlsvc.inventory_item_id = ospl.service_item_id
6447: and mtlsvc.organization_id = decode(ospl.workorder_id, null, ospl.inventory_org_id, vst.organization_id)
6448: )service_item_number,
6449: ospl.service_item_description,

Line 6472: from mtl_system_items_kfv mtli

6468: decode(ospl.workorder_id, null, ospl.inventory_item_id, vts.inventory_item_id)inventory_item_id,
6469: --Fix for the regression issue by mpothuku on 28th August 2006, changed the item_id to org_id in decode below
6470: decode(ospl.workorder_id, null, ospl.inventory_org_id, vst.organization_id) inventory_org_id,
6471: (select mtli.concatenated_segments
6472: from mtl_system_items_kfv mtli
6473: where mtli.inventory_item_id = ospl.inventory_item_id
6474: and mtli.organization_id = decode(ospl.workorder_id, null, ospl.inventory_org_id, vst.organization_id)
6475: )item_number,
6476: decode(ospl.workorder_id, null, ospl.inventory_item_uom, csiwo.unit_of_measure)inventory_item_uom,

Line 6913: FROM mtl_system_items_kfv MTL

6909:
6910: l_workorder_id NUMBER;
6911: CURSOR service_item_id_csr(p_service_item_number IN VARCHAR2, p_inventory_org_id NUMBER) IS
6912: SELECT MTL.inventory_item_id
6913: FROM mtl_system_items_kfv MTL
6914: WHERE MTL.concatenated_segments = p_service_item_number
6915: AND MTL.organization_id = p_inventory_org_id;
6916: l_service_item_id NUMBER;
6917: l_organization_id NUMBER;

Line 6947: FROM mtl_system_items_kfv MTL

6943: WHERE instance_number = p_exchange_instance_number;
6944: l_exchange_instance_id NUMBER;
6945: CURSOR physical_item_id_csr(p_item_number IN VARCHAR2, p_inventory_org_id NUMBER) IS
6946: SELECT MTL.inventory_item_id
6947: FROM mtl_system_items_kfv MTL
6948: WHERE MTL.concatenated_segments = p_item_number
6949: AND MTL.organization_id = p_inventory_org_id;
6950: l_physical_item_id NUMBER;
6951: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.convert_order_lines_val_to_id';

Line 7109: FROM mtl_system_items_kfv MTL

7105: p_organization_id IN NUMBER)
7106: IS
7107: CURSOR val_service_item_id_csr IS
7108: SELECT 'X'
7109: FROM mtl_system_items_kfv MTL
7110: WHERE MTL.inventory_item_id = p_service_item_id
7111: AND MTL.enabled_flag = G_YES_FLAG
7112: AND MTL.inventory_item_flag = G_NO_FLAG
7113: AND MTL.stock_enabled_flag = G_NO_FLAG