APPS.QA_PLAN_ELEMENT_API dependencies on CSI_ITEM_INSTANCES

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 3486: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp

3482:
3483: sql_string := 'SELECT
3484: cii.instance_number, cii.instance_description
3485: FROM
3486: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
3487: WHERE
3488: msib.organization_id = mp.organization_id and
3489: msib.organization_id = cii.last_vld_organization_id and
3490: msib.inventory_item_id = cii.inventory_item_id and

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

3531:
3532: sql_string := 'SELECT
3533: distinct msn.serial_number, msn.descriptive_text
3534: FROM
3535: mtl_serial_numbers msn, csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
3536: WHERE
3537: msib.organization_id = mp.organization_id and
3538: msib.organization_id = cii.last_vld_organization_id and
3539: msib.inventory_item_id = cii.inventory_item_id and

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 5157: FROM csi_item_instances cii

5153: --Instance Number was already validated for eam restrictions
5154: --Following sql returns 1 row as there is unique index on instance_number
5155: CURSOR c (i_num VARCHAR2) IS
5156: SELECT cii.instance_id
5157: FROM csi_item_instances cii
5158: WHERE cii.instance_number = i_num;
5159:
5160: BEGIN
5161:

Line 5181: FROM csi_item_instances cii

5177: id NUMBER;
5178: --Asset Group and Asset Number were already validated for eam restrictions
5179: CURSOR c (org_id NUMBER, asset_group VARCHAR2) IS
5180: SELECT cii.instance_id
5181: FROM csi_item_instances cii
5182: WHERE cii.inventory_item_id = p_asset_group_id
5183: AND cii.serial_number = p_asset_number; --inv id and serial num combo is unique
5184:
5185: BEGIN