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.QA_SS_LOV_API dependencies on MTL_SYSTEM_ITEMS

Line 27: FROM mtl_system_items

23: l_rev_control_code NUMBER;
24:
25: CURSOR c IS
26: SELECT revision_qty_control_code
27: FROM mtl_system_items
28: WHERE inventory_item_id = p_item_id
29: AND organization_id = p_org_id;
30: BEGIN
31:

Line 55: FROM mtl_system_items

51: l_lot_control_code NUMBER;
52:
53: CURSOR c IS
54: SELECT lot_control_code
55: FROM mtl_system_items
56: WHERE inventory_item_id = p_item_id
57: AND organization_id = p_org_id;
58: BEGIN
59:

Line 465: FROM mtl_system_items_kfv msik, so_lines sl

461: BEGIN
462:
463:
464: /*x_lov_sql := 'SELECT to_char(sl.line_number), msik.concatenated_segments
465: FROM mtl_system_items_kfv msik, so_lines sl
466: WHERE sl.inventory_item_id = msik.inventory_item_id'; *//*
467:
468: x_lov_sql := NULL;
469:

Line 871: mtl_system_items_kfv msi

867: ORDER BY revision';
868: */
869: x_lov_sql := 'SELECT revision, QLTDATE.date_to_user(effectivity_date)
870: FROM mtl_item_revisions mir,
871: mtl_system_items_kfv msi
872: WHERE mir.inventory_item_id = msi.inventory_item_id
873: AND mir.organization_id = msi.organization_id
874: AND msi.revision_qty_control_code = 2
875: AND mir.inventory_item_id = :1

Line 1259: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp

1255:
1256: x_lov_sql :=
1257: 'SELECT cii.instance_number, cii.instance_description
1258: FROM
1259: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
1260: WHERE
1261: msib.organization_id = mp.organization_id and
1262: msib.organization_id = cii.last_vld_organization_id and
1263: msib.inventory_item_id = cii.inventory_item_id and

Line 1327: mtl_serial_numbers msn, csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp

1323: --dgupta: Start R12 EAM Integration. Bug 4345492
1324: x_lov_sql := 'SELECT
1325: distinct msn.serial_number, msn.descriptive_text
1326: FROM
1327: mtl_serial_numbers msn, csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
1328: WHERE
1329: msib.organization_id = mp.organization_id and
1330: msib.organization_id = cii.last_vld_organization_id and
1331: msib.inventory_item_id = cii.inventory_item_id and

Line 1712: FROM mtl_system_items_kfv

1708:
1709: BEGIN
1710:
1711: x_lov_sql := 'SELECT concatenated_segments, description
1712: FROM mtl_system_items_kfv
1713: WHERE organization_id = :1';
1714: --
1715: -- bug 7197055
1716: -- Added the below condition only if a value for production_line is entered

Line 1780: FROM mtl_system_items_kfv

1776:
1777: -- l_item_id := qa_flex_util.get_item_id(x_org_id, p_item);
1778:
1779: x_lov_sql := 'SELECT concatenated_segments, description
1780: FROM mtl_system_items_kfv
1781: WHERE organization_id = :1 ' ||
1782: ' and inventory_item_id in (
1783: SELECT bic.component_item_id
1784: FROM bom_inventory_components bic,

Line 1796: FROM mtl_system_items_kfv

1792: else
1793:
1794: -- show an empty list if parent item is not passed
1795: x_lov_sql := 'SELECT concatenated_segments, description
1796: FROM mtl_system_items_kfv
1797: WHERE 1 = 2
1798: ORDER BY concatenated_segments';
1799:
1800: end if;

Line 1831: from mtl_system_items_b_kfv msikfv, mtl_parameters mp

1827: BEGIN
1828:
1829: --dgupta: Start R12 EAM Integration. Bug 4345492
1830: x_lov_sql := 'select distinct msikfv.concatenated_segments, msikfv.description
1831: from mtl_system_items_b_kfv msikfv, mtl_parameters mp
1832: where msikfv.organization_id = mp.organization_id
1833: and msikfv.eam_item_type in (1,3)
1834: and mp.maint_organization_id = :1
1835: order by msikfv.concatenated_segments';

Line 1871: FROM mtl_eam_asset_activities_v meaav, mtl_system_items_b msib

1867: -- show all activities asssociated to the asset group
1868: -- If no match found or if asset group passed in is null, lov is empty
1869: /*
1870: x_lov_sql := 'SELECT meaav.activity, meaav.activity_description
1871: FROM mtl_eam_asset_activities_v meaav, mtl_system_items_b msib
1872: WHERE msib.organization_id = :1
1873: and meaav. maintenance_object_id = :2 --pass asset group inventory_item_id
1874: and (meaav.end_date_active is null or meaav.end_date_active > sysdate)
1875: and (meaav.start_date_active is null or meaav.start_date_active < sysdate)

Line 1885: mtl_system_items_b_kfv msib

1881: x_lov_sql := 'SELECT
1882: msib.concatenated_segments activity ,
1883: msib.description activity_description
1884: FROM mtl_eam_asset_activities meaav,
1885: mtl_system_items_b_kfv msib
1886: WHERE msib.organization_id = :1
1887: AND meaav.maintenance_object_id = :2 --pass asset group inventory_item_id
1888: AND (meaav.end_date_active is null
1889: OR meaav.end_date_active > sysdate)

Line 1900: FROM mtl_eam_asset_activities_v meaav, mtl_system_items_b msib

1896: -- show all activities associated to asset group and asset number
1897: -- if exact match not found, lov is empty.
1898: /*
1899: x_lov_sql := 'SELECT meaav.activity, meaav.activity_description
1900: FROM mtl_eam_asset_activities_v meaav, mtl_system_items_b msib
1901: WHERE msib.organization_id = :1
1902: and meaav.maintenance_object_id = :2 --pass asset instance_id
1903: and meaav.maintenance_object_type = 3 --serialized item
1904: and (meaav.end_date_active is null or meaav.end_date_active > sysdate)

Line 1914: mtl_system_items_b_kfv msi

1910: x_lov_sql := 'SELECT
1911: msi.concatenated_segments activity ,
1912: msi.description activity_description
1913: FROM mtl_eam_asset_activities meaa,
1914: mtl_system_items_b_kfv msi
1915: WHERE msi.organization_id = :1
1916: AND meaa.maintenance_object_id = :2 --pass asset instance_id
1917: AND meaa.maintenance_object_type = 3 --serialized item
1918: AND (meaa.end_date_active is null

Line 2081: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik

2077:
2078: BEGIN
2079:
2080: x_lov_sql := 'SELECT cii.instance_number, cii.serial_number
2081: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik
2082: WHERE cii.inventory_item_id = msik.inventory_item_id
2083: AND cii.last_vld_organization_id = msik.organization_id
2084: ORDER BY 1';
2085:

Line 2106: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik

2102: fnd_msg_pub.add();
2103: END IF;
2104:
2105: x_lov_sql := 'SELECT cii.instance_number, cii.serial_number
2106: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik
2107: WHERE cii.inventory_item_id = msik.inventory_item_id
2108: AND cii.last_vld_organization_id = msik.organization_id
2109: AND cii.inventory_item_id = :1
2110: AND trunc(sysdate) BETWEEN trunc(nvl(cii.active_start_date, sysdate))

Line 2157: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik

2153: fnd_msg_pub.add();
2154: END IF;
2155:
2156: x_lov_sql := 'SELECT cii.serial_number, msik.concatenated_segments
2157: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik
2158: WHERE cii.inventory_item_id = msik.inventory_item_id
2159: AND cii.inv_master_organization_id = msik.organization_id
2160: AND msik.inventory_item_id = :1
2161: AND trunc(sysdate) BETWEEN trunc(nvl(cii.active_start_date, sysdate))

Line 2721: FROM mtl_system_items_kfv

2717:
2718: BEGIN
2719:
2720: x_lov_sql := 'SELECT concatenated_segments, description
2721: FROM mtl_system_items_kfv
2722: WHERE organization_id = :1
2723: ORDER BY concatenated_segments';
2724:
2725: END get_bill_reference_lov;

Line 2733: FROM mtl_system_items_kfv

2729:
2730: BEGIN
2731:
2732: x_lov_sql := 'SELECT concatenated_segments, description
2733: FROM mtl_system_items_kfv
2734: WHERE organization_id = :1
2735: ORDER BY concatenated_segments';
2736:
2737: END get_routing_reference_lov;