APPS.QA_PLAN_ELEMENT_API dependencies on CSI_ITEM_INSTANCES

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

4955: --Instance Number was already validated for eam restrictions
4956: --Following sql returns 1 row as there is unique index on instance_number
4957: CURSOR c (i_num VARCHAR2) IS
4958: SELECT cii.instance_id
4959: FROM csi_item_instances cii
4960: WHERE cii.instance_number = i_num;
4961:
4962: BEGIN
4963:

Line 4983: FROM csi_item_instances cii

4979: id NUMBER;
4980: --Asset Group and Asset Number were already validated for eam restrictions
4981: CURSOR c (org_id NUMBER, asset_group VARCHAR2) IS
4982: SELECT cii.instance_id
4983: FROM csi_item_instances cii
4984: WHERE cii.inventory_item_id = p_asset_group_id
4985: AND cii.serial_number = p_asset_number; --inv id and serial num combo is unique
4986:
4987: BEGIN