APPS.QA_PLAN_ELEMENT_API dependencies on MTL_SYSTEM_ITEMS_KFV

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 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