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_PLAN_ELEMENT_API dependencies on MTL_SYSTEM_ITEMS

Line 1251: FROM mtl_system_items_kfv msik, so_lines sl

1247: id NUMBER;
1248:
1249: CURSOR c (h_id IN VARCHAR2) IS
1250: SELECT sl.line_number
1251: FROM mtl_system_items_kfv msik, so_lines sl
1252: WHERE sl.inventory_item_id = msik.inventory_item_id
1253: AND header_id = h_id;
1254:
1255: BEGIN

Line 1609: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik

1605: id NUMBER;
1606:
1607: CURSOR c (i_num VARCHAR2) IS
1608: SELECT cii.instance_id
1609: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik
1610: WHERE cii.instance_number = i_num
1611: AND cii.last_vld_organization_id = msik.organization_id;
1612:
1613: BEGIN

Line 2922: FROM mtl_system_items_kfv msik, so_lines sl

2918: -- After Single Scan LOV
2919: wild := value;
2920:
2921: sql_string := 'SELECT to_char(sl.line_number), msik.concatenated_segments
2922: FROM mtl_system_items_kfv msik, so_lines sl
2923: WHERE sl.inventory_item_id = msik.inventory_item_id
2924: AND header_id like :1';
2925:
2926: OPEN x_ref FOR sql_string USING wild;

Line 3296: FROM mtl_item_revisions mir, mtl_system_items msi

3292: -- will have a base revision by default. But we want this sql to
3293: -- fetch revision only if the item is revision controlled. kabalakr.
3294:
3295: sql_string := 'SELECT mir.revision, mir.effectivity_date
3296: FROM mtl_item_revisions mir, mtl_system_items msi
3297: WHERE mir.inventory_item_id = :1
3298: AND mir.organization_id = :2
3299: AND mir.revision like :3
3300: AND mir.inventory_item_id = msi.inventory_item_id

Line 3394: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp

3390:
3391: sql_string := 'SELECT
3392: cii.instance_number, cii.instance_description
3393: FROM
3394: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
3395: WHERE
3396: msib.organization_id = mp.organization_id and
3397: msib.organization_id = cii.last_vld_organization_id and
3398: msib.inventory_item_id = cii.inventory_item_id and

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

3439:
3440: sql_string := 'SELECT
3441: distinct msn.serial_number, msn.descriptive_text
3442: FROM
3443: mtl_serial_numbers msn, csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
3444: WHERE
3445: msib.organization_id = mp.organization_id and
3446: msib.organization_id = cii.last_vld_organization_id and
3447: msib.inventory_item_id = cii.inventory_item_id and

Line 3867: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik

3863: -- After Single Scan LOV
3864: wild := value;
3865:
3866: sql_string := 'SELECT cii.instance_number, cii.serial_number
3867: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik
3868: WHERE cii.inventory_item_id = msik.inventory_item_id
3869: AND cii.last_vld_organization_id = msik.organization_id
3870: AND instance_number like :1
3871: ORDER BY 1';

Line 4026: FROM mtl_system_items_kfv

4022: -- After Single Scan LOV
4023: wild := value;
4024:
4025: sql_string := 'SELECT concatenated_segments, description
4026: FROM mtl_system_items_kfv
4027: WHERE organization_id = :1
4028: AND concatenated_segments like :2
4029: ORDER BY concatenated_segments';
4030:

Line 4054: FROM mtl_system_items_kfv

4050: -- After Single Scan LOV
4051: wild := value;
4052:
4053: sql_string := 'SELECT concatenated_segments, description
4054: FROM mtl_system_items_kfv
4055: WHERE organization_id = :1
4056: AND concatenated_segments like :2
4057: ORDER BY concatenated_segments';
4058:

Line 4458: FROM mtl_system_items_kfv

4454: -- After Single Scan LOV
4455: wild := value;
4456:
4457: sql_string := 'SELECT concatenated_segments, description
4458: FROM mtl_system_items_kfv
4459: WHERE organization_id = :1
4460: AND concatenated_segments like :2
4461: ORDER BY concatenated_segments';
4462:

Line 4509: FROM mtl_system_items_kfv

4505: -- Comp Item with WIP Job dependency.
4506: --
4507: l_sql_string :=
4508: 'SELECT concatenated_segments, description
4509: FROM mtl_system_items_kfv
4510: WHERE organization_id = :1 AND
4511: concatenated_segments like :2 AND
4512: inventory_item_id IN (
4513: SELECT inventory_item_id

Line 4526: FROM mtl_system_items_kfv

4522: -- Comp Item with Flow Production Line dependency.
4523: --
4524: l_sql_string :=
4525: 'SELECT concatenated_segments, description
4526: FROM mtl_system_items_kfv
4527: WHERE organization_id = :1 AND
4528: concatenated_segments like :2 AND
4529: inventory_item_id IN (
4530: SELECT inventory_item_id

Line 4546: FROM mtl_system_items_kfv

4542: -- Comp Item with BOM Component Dependency.
4543: --
4544: l_sql_string :=
4545: 'SELECT concatenated_segments, description
4546: FROM mtl_system_items_kfv
4547: WHERE organization_id = :1 AND
4548: concatenated_segments like :2 AND
4549: inventory_item_id IN (
4550: SELECT bic.component_item_id

Line 4591: from mtl_system_items_b_kfv msikfv, mtl_parameters mp

4587: wild := value;
4588:
4589: --dgupta: Start R12 EAM Integration. Bug 4345492
4590: sql_string := 'select distinct msikfv.concatenated_segments, msikfv.description
4591: from mtl_system_items_b_kfv msikfv, mtl_parameters mp
4592: where msikfv.organization_id = mp.organization_id
4593: and msikfv.eam_item_type in (1,3)
4594: and mp.maint_organization_id = :1
4595: and msikfv.concatenated_segments like :2

Line 4631: FROM mtl_eam_asset_activities_v meaav, mtl_system_items_b msib

4627: -- show all activities asssociated to the asset group
4628: -- If no match found or if asset group passed in is null, lov is empty
4629: /*
4630: sql_string := 'SELECT meaav.activity, meaav.activity_description
4631: FROM mtl_eam_asset_activities_v meaav, mtl_system_items_b msib
4632: WHERE msib.organization_id = :1
4633: and meaav. maintenance_object_id = :2 --pass asset group inventory_item_id
4634: and (meaav.end_date_active is null or meaav.end_date_active > sysdate)
4635: and (meaav.start_date_active is null or meaav.start_date_active < sysdate)

Line 4646: mtl_system_items_b_kfv msib

4642: sql_string := 'SELECT
4643: msib.concatenated_segments activity ,
4644: msib.description activity_description
4645: FROM mtl_eam_asset_activities meaav,
4646: mtl_system_items_b_kfv msib
4647: WHERE msib.organization_id = :1
4648: AND meaav. maintenance_object_id = :2 --pass asset group inventory_item_id
4649: AND (meaav.end_date_active is null
4650: OR meaav.end_date_active > sysdate)

Line 4664: FROM mtl_eam_asset_activities_v meaav, mtl_system_items_b msib

4660: -- show all activities associated to asset group and asset number
4661: -- if exact match not found, lov is empty.
4662: /*
4663: sql_string := 'SELECT meaav.activity, meaav.activity_description
4664: FROM mtl_eam_asset_activities_v meaav, mtl_system_items_b msib
4665: WHERE msib.organization_id = :1
4666: and meaav.maintenance_object_id = :2 --pass asset instance_id
4667: and meaav.maintenance_object_type = 3 --serialized item
4668: and (meaav.end_date_active is null or meaav.end_date_active > sysdate)

Line 4679: mtl_system_items_b_kfv msi

4675: sql_string := 'SELECT
4676: msi.concatenated_segments activity ,
4677: msi.description activity_description
4678: FROM mtl_eam_asset_activities meaa,
4679: mtl_system_items_b_kfv msi
4680: WHERE msi.organization_id = :1
4681: AND meaa.maintenance_object_id = :2 --pass asset instance_id
4682: AND meaa.maintenance_object_type = 3 --serialized item
4683: AND (meaa.end_date_active is null

Line 5009: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp

5005: id NUMBER;
5006: --rownum=1 =>better performance since all rows have same inventory_item_id
5007: CURSOR c (o_id NUMBER, a_group VARCHAR2) IS
5008: SELECT msikfv.inventory_item_id
5009: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp
5010: WHERE msikfv.organization_id = mp.organization_id
5011: and msikfv.eam_item_type in (1,3)
5012: and mp.maint_organization_id = o_id
5013: and msikfv.concatenated_segments = a_group

Line 5428: mtl_system_items msi

5424: msi.serial_number_control_code,
5425: msi.lot_control_code,
5426: msi.primary_uom_code
5427: FROM
5428: mtl_system_items msi
5429: WHERE msi.organization_id = org_id AND
5430: msi.inventory_item_id = p_item_id;
5431:
5432: cascaded_dep_elements_list VARCHAR2(32000);