APPS.QA_PLAN_ELEMENT_API dependencies on QA_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 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