APPS.QA_PLAN_ELEMENT_API dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1256: FROM mtl_system_items_kfv msik, so_lines sl

1252: -- bug 16214422
1253: /*
1254: CURSOR c (h_id IN VARCHAR2) IS
1255: SELECT sl.line_number
1256: FROM mtl_system_items_kfv msik, so_lines sl
1257: WHERE sl.inventory_item_id = msik.inventory_item_id
1258: AND header_id = h_id;
1259: */
1260:

Line 1628: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik

1624: id NUMBER;
1625:
1626: CURSOR c (i_num VARCHAR2) IS
1627: SELECT cii.instance_id
1628: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik
1629: WHERE cii.instance_number = i_num
1630: AND cii.last_vld_organization_id = msik.organization_id;
1631:
1632: BEGIN

Line 2973: FROM mtl_system_items_kfv msik, so_lines sl

2969: -- After Single Scan LOV
2970: wild := value;
2971:
2972: sql_string := 'SELECT to_char(sl.line_number), msik.concatenated_segments
2973: FROM mtl_system_items_kfv msik, so_lines sl
2974: WHERE sl.inventory_item_id = msik.inventory_item_id
2975: AND header_id like :1';
2976:
2977: OPEN x_ref FOR sql_string USING wild;

Line 3999: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik

3995: -- After Single Scan LOV
3996: wild := value;
3997:
3998: sql_string := 'SELECT cii.instance_number, cii.serial_number
3999: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik
4000: WHERE cii.inventory_item_id = msik.inventory_item_id
4001: AND cii.last_vld_organization_id = msik.organization_id
4002: AND instance_number like :1
4003: ORDER BY 1';

Line 4030: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik

4026:
4027: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
4028:
4029: sql_string := 'SELECT cii.instance_number, cii.serial_number
4030: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik
4031: WHERE cii.inventory_item_id = msik.inventory_item_id
4032: AND cii.last_vld_organization_id = msik.organization_id
4033: AND cii.inventory_item_id = :1
4034: AND trunc(sysdate) BETWEEN trunc(nvl(cii.active_start_date, sysdate))

Line 4063: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik

4059:
4060: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
4061:
4062: sql_string := 'SELECT cii.serial_number, msik.concatenated_segments
4063: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik
4064: WHERE cii.inventory_item_id = msik.inventory_item_id
4065: AND cii.inv_master_organization_id = msik.organization_id
4066: AND msik.inventory_item_id = :1
4067: AND cii.serial_number like :2

Line 4224: FROM mtl_system_items_kfv

4220: -- After Single Scan LOV
4221: wild := value;
4222:
4223: sql_string := 'SELECT concatenated_segments, description
4224: FROM mtl_system_items_kfv
4225: WHERE organization_id = :1
4226: AND concatenated_segments like :2
4227: ORDER BY concatenated_segments';
4228:

Line 4252: FROM mtl_system_items_kfv

4248: -- After Single Scan LOV
4249: wild := value;
4250:
4251: sql_string := 'SELECT concatenated_segments, description
4252: FROM mtl_system_items_kfv
4253: WHERE organization_id = :1
4254: AND concatenated_segments like :2
4255: ORDER BY concatenated_segments';
4256:

Line 4656: FROM mtl_system_items_kfv

4652: -- After Single Scan LOV
4653: wild := value;
4654:
4655: sql_string := 'SELECT concatenated_segments, description
4656: FROM mtl_system_items_kfv
4657: WHERE organization_id = :1
4658: AND concatenated_segments like :2
4659: ORDER BY concatenated_segments';
4660:

Line 4707: FROM mtl_system_items_kfv

4703: -- Comp Item with WIP Job dependency.
4704: --
4705: l_sql_string :=
4706: 'SELECT concatenated_segments, description
4707: FROM mtl_system_items_kfv
4708: WHERE organization_id = :1 AND
4709: concatenated_segments like :2 AND
4710: inventory_item_id IN (
4711: SELECT inventory_item_id

Line 4724: FROM mtl_system_items_kfv

4720: -- Comp Item with Flow Production Line dependency.
4721: --
4722: l_sql_string :=
4723: 'SELECT concatenated_segments, description
4724: FROM mtl_system_items_kfv
4725: WHERE organization_id = :1 AND
4726: concatenated_segments like :2 AND
4727: inventory_item_id IN (
4728: SELECT inventory_item_id

Line 4744: FROM mtl_system_items_kfv

4740: -- Comp Item with BOM Component Dependency.
4741: --
4742: l_sql_string :=
4743: 'SELECT concatenated_segments, description
4744: FROM mtl_system_items_kfv
4745: WHERE organization_id = :1 AND
4746: concatenated_segments like :2 AND
4747: inventory_item_id IN (
4748: SELECT bic.component_item_id