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 2386: SELECT 'x' FROM mtl_system_items_kfv MTL, ahl_workorders_osp_v WO

2382: p_service_item_id IN NUMBER,
2383: p_order_type_code IN VARCHAR2
2384: )IS
2385: CURSOR val_service_item_id_inv_csr(p_service_item_id IN VARCHAR2, p_workorder_id IN NUMBER) IS
2386: SELECT 'x' FROM mtl_system_items_kfv MTL, ahl_workorders_osp_v WO
2387: WHERE MTL.inventory_item_id = p_service_item_id
2388: AND MTL.enabled_flag = G_YES_FLAG
2389: AND MTL.inventory_item_flag = G_NO_FLAG
2390: AND MTL.stock_enabled_flag = G_NO_FLAG

Line 2487: SELECT 'x' FROM mtl_system_items_kfv MTL

2483: p_service_item_id IN NUMBER,
2484: p_service_item_description IN VARCHAR2
2485: ) IS
2486: CURSOR val_service_item_desc_csr(p_service_item_id IN VARCHAR2, p_service_item_description IN VARCHAR2) IS
2487: SELECT 'x' FROM mtl_system_items_kfv MTL
2488: WHERE MTL.inventory_item_id = p_service_item_id
2489: AND MTL.DESCRIPTION = p_service_item_description;
2490: l_exist VARCHAR2(1);
2491: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_service_item_desc';

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

2517: p_workorder_id IN NUMBER,
2518: p_service_item_id IN NUMBER
2519: )IS
2520: CURSOR val_service_item_id_inv_csr(p_service_item_id IN VARCHAR2, p_workorder_id IN NUMBER) IS
2521: SELECT 'x' FROM mtl_system_items_kfv MTL, ahl_workorders WO, AHL_VISITS_B VST
2522: WHERE MTL.inventory_item_id = p_service_item_id
2523: AND MTL.enabled_flag = G_YES_FLAG
2524: AND MTL.inventory_item_flag = G_NO_FLAG
2525: AND MTL.stock_enabled_flag = G_NO_FLAG

Line 4784: mtl_system_items_kfv mtls,

4780: FROM ahl_workorders wo,
4781: ahl_visits_b vst,
4782: ahl_visit_tasks_b vts,
4783: csi_item_instances csii,
4784: mtl_system_items_kfv mtls,
4785: ahl_routes_b arb
4786: WHERE wo.workorder_id = c_workorder_id
4787: AND wo.visit_task_id = vts.visit_task_id
4788: AND vst.visit_id = vts.visit_id

Line 4873: FROM mtl_system_items_kfv

4869: --Assuming the org of service_item_id is the same as that of physical item
4870: --Alwasy set service_item_description to be derived from service_item_id if service_item_id is not null
4871: SELECT primary_uom_code, description,concatenated_segments, allow_item_desc_update_flag INTO
4872: l_temp_uom_code, l_item_description, l_svc_item_number, l_desc_update_flag
4873: FROM mtl_system_items_kfv
4874: WHERE inventory_item_id = p_x_osp_order_line_rec.service_item_id
4875: AND organization_id = p_x_osp_order_line_rec.inventory_org_id;
4876: EXCEPTION
4877: WHEN NO_DATA_FOUND THEN

Line 4911: FROM mtl_system_items_kfv

4907: FND_MSG_PUB.ADD;
4908: ELSE
4909: BEGIN
4910: SELECT concatenated_segments INTO l_inv_item_number
4911: FROM mtl_system_items_kfv
4912: WHERE inventory_item_id = p_x_osp_order_line_rec.inventory_item_id
4913: AND organization_id = p_x_osp_order_line_rec.inventory_org_id;
4914: EXCEPTION
4915: WHEN NO_DATA_FOUND THEN

Line 5338: FROM mtl_system_items_kfv

5334: primary_uom_code,
5335: serial_number_control_code,
5336: lot_control_code,
5337: comms_nl_trackable_flag
5338: FROM mtl_system_items_kfv
5339: WHERE inventory_item_id = c_inventory_item_id
5340: AND organization_id = c_inventory_org_id;
5341: l_check_physical_item check_physical_item%ROWTYPE;
5342: CURSOR check_sub_inventory(c_organization_id NUMBER, c_sub_inventory VARCHAR2) IS

Line 5435: mtl_system_items_kfv mtls,

5431: FROM ahl_workorders wo,
5432: ahl_visits_b vst,
5433: ahl_visit_tasks_b vts,
5434: csi_item_instances csii,
5435: mtl_system_items_kfv mtls,
5436: ahl_routes_b arb
5437: WHERE workorder_id = c_workorder_id
5438: AND wo.visit_task_id = vts.visit_task_id
5439: AND vst.visit_id = vts.visit_id

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

6266: --side.
6267:
6268: IF (p_x_osp_order_line_rec.service_item_id IS NOT NULL) THEN
6269: BEGIN
6270: --Assuming service_item_id is always in mtl_system_items_kfv and its organization equals that of physical item
6271: --Alwasy set service_item_description to be derived from service_item_id if service_item_id is not null
6272: --Changes made by mpothuku on 27-Mar-06 to fix the ER 4544654 and Bug 5013047
6273: SELECT description, allow_item_desc_update_flag, concatenated_segments INTO l_item_description, l_desc_update_flag, l_svc_item_number
6274: FROM mtl_system_items_kfv

Line 6274: FROM mtl_system_items_kfv

6270: --Assuming service_item_id is always in mtl_system_items_kfv and its organization equals that of physical item
6271: --Alwasy set service_item_description to be derived from service_item_id if service_item_id is not null
6272: --Changes made by mpothuku on 27-Mar-06 to fix the ER 4544654 and Bug 5013047
6273: SELECT description, allow_item_desc_update_flag, concatenated_segments INTO l_item_description, l_desc_update_flag, l_svc_item_number
6274: FROM mtl_system_items_kfv
6275: WHERE inventory_item_id = p_x_osp_order_line_rec.service_item_id
6276: AND organization_id = p_x_osp_order_line_rec.inventory_org_id;
6277: EXCEPTION
6278: WHEN NO_DATA_FOUND THEN

Line 6313: FROM mtl_system_items_kfv

6309: FND_MSG_PUB.ADD;
6310: ELSE
6311: BEGIN
6312: SELECT concatenated_segments INTO l_inv_item_number
6313: FROM mtl_system_items_kfv
6314: WHERE inventory_item_id = p_x_osp_order_line_rec.inventory_item_id
6315: AND organization_id = p_x_osp_order_line_rec.inventory_org_id;
6316: EXCEPTION
6317: WHEN NO_DATA_FOUND THEN

Line 6431: FROM mtl_system_items_kfv

6427: -- While for non tracked item, same physical item can only appear once in a given OSP order header
6428: IF (p_x_osp_order_line_rec.workorder_id IS NULL AND
6429: p_x_osp_order_line_rec.service_item_id <> l_osp_order_line_rec.service_item_id) THEN
6430: SELECT comms_nl_trackable_flag INTO l_trackable_flag
6431: FROM mtl_system_items_kfv
6432: WHERE inventory_item_id = p_x_osp_order_line_rec.inventory_item_id
6433: AND organization_id = p_x_osp_order_line_rec.inventory_org_id;
6434: /* Commented out by Jerry on 10/11/05 due to an issue found by Pavan
6435: IF (nvl(l_trackable_flag, 'N')='N') THEN

Line 6894: from mtl_system_items_kfv mtlsvc

6890: ospl.status_code, --status is not defined in the record because user can't directly change the status
6891: ospl.po_line_type_id, --no po_line_type here because it is not changeable once it is created(from a profile option)
6892: ospl.service_item_id,
6893: (select mtlsvc.concatenated_segments
6894: from mtl_system_items_kfv mtlsvc
6895: where mtlsvc.inventory_item_id = ospl.service_item_id
6896: and mtlsvc.organization_id = decode(ospl.workorder_id, null, ospl.inventory_org_id, vst.organization_id)
6897: )service_item_number,
6898: ospl.service_item_description,

Line 6921: from mtl_system_items_kfv mtli

6917: decode(ospl.workorder_id, null, ospl.inventory_item_id, vts.inventory_item_id)inventory_item_id,
6918: --Fix for the regression issue by mpothuku on 28th August 2006, changed the item_id to org_id in decode below
6919: decode(ospl.workorder_id, null, ospl.inventory_org_id, vst.organization_id) inventory_org_id,
6920: (select mtli.concatenated_segments
6921: from mtl_system_items_kfv mtli
6922: where mtli.inventory_item_id = ospl.inventory_item_id
6923: and mtli.organization_id = decode(ospl.workorder_id, null, ospl.inventory_org_id, vst.organization_id)
6924: )item_number,
6925: decode(ospl.workorder_id, null, ospl.inventory_item_uom, csiwo.unit_of_measure)inventory_item_uom,

Line 7362: FROM mtl_system_items_kfv MTL

7358:
7359: l_workorder_id NUMBER;
7360: CURSOR service_item_id_csr(p_service_item_number IN VARCHAR2, p_inventory_org_id NUMBER) IS
7361: SELECT MTL.inventory_item_id
7362: FROM mtl_system_items_kfv MTL
7363: WHERE MTL.concatenated_segments = p_service_item_number
7364: AND MTL.organization_id = p_inventory_org_id;
7365: l_service_item_id NUMBER;
7366: l_organization_id NUMBER;

Line 7396: FROM mtl_system_items_kfv MTL

7392: WHERE instance_number = p_exchange_instance_number;
7393: l_exchange_instance_id NUMBER;
7394: CURSOR physical_item_id_csr(p_item_number IN VARCHAR2, p_inventory_org_id NUMBER) IS
7395: SELECT MTL.inventory_item_id
7396: FROM mtl_system_items_kfv MTL
7397: WHERE MTL.concatenated_segments = p_item_number
7398: AND MTL.organization_id = p_inventory_org_id;
7399: l_physical_item_id NUMBER;
7400: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.convert_order_lines_val_to_id';

Line 7558: FROM mtl_system_items_kfv MTL

7554: p_organization_id IN NUMBER)
7555: IS
7556: CURSOR val_service_item_id_csr IS
7557: SELECT 'X'
7558: FROM mtl_system_items_kfv MTL
7559: WHERE MTL.inventory_item_id = p_service_item_id
7560: AND MTL.enabled_flag = G_YES_FLAG
7561: AND MTL.inventory_item_flag = G_NO_FLAG
7562: AND MTL.stock_enabled_flag = G_NO_FLAG

Line 7838: FROM MTL_SYSTEM_ITEMS_KFV

7834:
7835: --Cursor to check whether the item is trackable
7836: CURSOR c_is_trackable_item(c_inventory_item_id NUMBER, c_inventory_org_id NUMBER) IS
7837: SELECT COMMS_NL_TRACKABLE_FLAG
7838: FROM MTL_SYSTEM_ITEMS_KFV
7839: WHERE INVENTORY_ITEM_ID = c_inventory_item_id
7840: AND ORGANIZATION_ID = c_inventory_org_id;
7841:
7842: --Cursor to fetch entitlement id for a given workorder