APPS.GMD_MBR_UTIL_PKG SQL Statements

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

Line: 11

      SELECT activity_factor
      FROM   gmd_recipe_orgn_activities
      WHERE RECIPE_ID       = P_RECIPE_ID
        AND ROUTINGSTEP_ID  = P_ROUTINGSTEP_ID
        AND OPRN_LINE_ID    = P_OPRN_LINE_ID
        AND ORGANIZATION_ID = substrb(P_DOCUMENT_ID,instrb(P_DOCUMENT_ID,'-',1,1)+1,
                                     decode(instrb(P_DOCUMENT_ID,'-',1,2),0,
                                            length(substrb(P_DOCUMENT_ID,instrb(P_DOCUMENT_ID,'-',1,1)+1)),
                                            instrb(P_DOCUMENT_ID,'-',1,2)-(instrb(P_DOCUMENT_ID,'-',1,1)+1)));

Line: 51

       SELECT MIN_CAPACITY
             ,MAX_CAPACITY
             ,PROCESS_UM
             ,USAGE_UOM
             ,RESOURCE_USAGE
             ,PROCESS_QTY
       FROM gmd_recipe_orgn_resources
       WHERE
             ORGANIZATION_ID = substrb(P_DOCUMENT_ID,instrb(P_DOCUMENT_ID,'-',1,1)+1,
                                     decode(instrb(P_DOCUMENT_ID,'-',1,2),0,
                                            length(substrb(P_DOCUMENT_ID,instrb(P_DOCUMENT_ID,'-',1,1)+1)),
                                            instrb(P_DOCUMENT_ID,'-',1,2)-(instrb(P_DOCUMENT_ID,'-',1,1)+1)))
         AND RECIPE_ID       = P_RECIPE_ID
         AND ROUTINGSTEP_ID  = P_ROUTINGSTEP_ID
         AND OPRN_LINE_ID    = P_OPRN_LINE_ID
         AND RESOURCES       = P_RESOURCES ;

Line: 69

    SELECT
           MIN_CAPACITY
          ,MAX_CAPACITY
          ,CAPACITY_UM
    FROM CR_RSRC_DTL
    WHERE  RESOURCES  = P_RESOURCES
      AND  ORGANIZATION_ID = substrb(P_DOCUMENT_ID,instrb(P_DOCUMENT_ID,'-',1,1)+1,
                                     decode(instrb(P_DOCUMENT_ID,'-',1,2),0,
                                            length(substrb(P_DOCUMENT_ID,instrb(P_DOCUMENT_ID,'-',1,1)+1)),
                                            instrb(P_DOCUMENT_ID,'-',1,2)-(instrb(P_DOCUMENT_ID,'-',1,1)+1)));

Line: 145

    SELECT SAMPLING_PLAN_ID
    from  gmd_wip_spec_vrs
    WHERE SPEC_VR_ID = l_spec_vr_id;

Line: 149

     SELECT REVISION
     from fm_matl_dtl
     where FORMULALINE_ID = P_FORMULALINE_ID;

Line: 215

    SELECT TARGET_VALUE,MINIMUM_VALUE,MAXIMUM_VALUE
    FROM   	gmd_recipe_process_parameters
    WHERE    recipe_id = p_recipe_id
      AND    organization_id = substrb(P_DOCUMENT_ID,instrb(P_DOCUMENT_ID,'-',1,1)+1,
                                     decode(instrb(P_DOCUMENT_ID,'-',1,2),0,
                                            length(substrb(P_DOCUMENT_ID,instrb(P_DOCUMENT_ID,'-',1,1)+1)),
                                            instrb(P_DOCUMENT_ID,'-',1,2)-(instrb(P_DOCUMENT_ID,'-',1,1)+1)))
      AND    routingstep_id = p_ROUTINGSTEP_ID
      AND    oprn_line_id = p_OPRN_LINE_ID
      AND    resources = p_resource
      AND    parameter_id = P_PARAMETER_ID ;

Line: 228

     SELECT PARAMETER_NAME
     FROM GMP_PROCESS_PARAMETERS
     WHERE PARAMETER_ID = P_PARAMETER_ID;