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