APPS.GMD_SS_APPROVAL_WF_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

      SELECT USER_NAME
      FROM FND_USER
      WHERE USER_ID = userId;

Line: 64

        select storage_plan_name
        from gmd_storage_plans_b
        where storage_plan_id = storage_id_in;

Line: 70

        select a.ss_id, a.ss_no, b.meaning, a.description, c.concatenated_segments item_no, c.description item_desc1, a.revision,
         e.organization_code ORGANIZATION_CODE, a.owner, a.NOTIFICATION_LEAD_TIME , a.NOTIFICATION_LEAD_TIME_UNIT,
         a.TESTING_GRACE_PERIOD , a.TESTING_GRACE_PERIOD_UNIT , a.MATERIAL_SOURCES_CNT,
         a.STORAGE_CONDITIONS_CNT , a.PACKAGES_CNT , a.BASE_SPEC_ID , d.SPEC_NAME, d.SPEC_VERS,
         f.organization_code LAB_ORGANIZATION_CODE , a.storage_plan_id ,
         a.SCHEDULED_START_DATE , a.SCHEDULED_END_DATE , a.REVISED_START_DATE ,
         a.REVISED_END_DATE ,  a.ACTUAL_START_DATE ,  a.ACTUAL_END_DATE ,
         a.RECOMMENDED_SHELF_LIFE , a.RECOMMENDED_SHELF_LIFE_UNIT , a.DELETE_MARK , a.LAST_UPDATED_BY
        from gmd_stability_studies a,
                gmd_Qc_status b,
                mtl_system_items_kfv c,
                gmd_specifications d,
                mtl_parameters e,
                mtl_parameters f
        where a.inventory_item_id = c.inventory_item_id
          and a.organization_id = c.organization_id
          and b.entity_type = 'STABILITY'
          and b.status_code = a.status
          and a.BASE_SPEC_ID = d.spec_id
          and a.ss_id = lSSId
      and a.organization_id = e.organization_id
      and a.lab_organization_id = f.organization_id;

Line: 97

        select user_name from fnd_user
        where user_id = owner_id_in ;

Line: 102

      SELECT meaning
      FROM gem_lookups
      WHERE lookup_type = 'GMD_QC_FREQUENCY_PERIOD'
      and   lookup_code = p_time ;

Line: 108

     select nvl( text, '')
        from wf_Resources where name = 'WF_ADMIN_ROLE'
        and language = userenv('LANG')   ;

Line: 229

          l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);

Line: 545

            ame_api.updateApprovalStatus(applicationIdIn   => applicationId,
                                         transactionIdIn   => lSSId,
                                         transactionTypeIn => transactionType,
                                         ApproverIn   => nextApprover);

Line: 615

            ame_api.updateApprovalStatus(applicationIdIn   => applicationId,
                                         transactionIdIn   => lSpecId,
                                         transactionTypeIn => transactionType,
                                         ApproverIn        => nextApprover);

Line: 632

      SELECT MEANING
      FROM GMD_QC_STATUS
      WHERE STATUS_CODE = P_STATUS_CODE
        AND ENTITY_TYPE = P_ENTITY_TYPE;

Line: 650

      SELECT MEANING
      FROM GMD_QC_STATUS
      WHERE STATUS_CODE = target_status
        AND ENTITY_TYPE = P_ENTITY_TYPE;

Line: 694

    l_parameter_list.DELETE;