APPS.OPI_OPM_COMMON_PKG SQL Statements

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

Line: 13

           SELECT orgn_code
             FROM ic_whse_mst
            WHERE whse_code = l_whse_code;

Line: 18

            SELECT b.orgn_code,c.GL_COST_MTHD
            FROM   ic_whse_mst a, sy_orgn_mst b, GL_PLCY_MST c
            WHERE  a.whse_code = l_whse_code
            AND    a.orgn_code = b.orgn_code
            AND    b.co_code = c.co_code;

Line: 69

           SELECT rate_type_code
             FROM gl_srce_mst
            WHERE TRANS_SOURCE_TYPE=5;

Line: 129

           SELECT rate_type_code
             FROM gl_srce_mst
            WHERE TRANS_SOURCE_TYPE=5;

Line: 178

                  SELECT  SUM(DECODE(Base_Currency,Billing_Currency,
                             Extended_price,
                             Decode(mul_div_sign,0,Extended_price*Exchange_Rate,
                             Extended_price/Exchange_Rate)))
                    FROM op_ordr_dtl
                  WHERE  order_id = P_order_id
                    AND  line_status >= 20;

Line: 215

            SELECT b.CO_CODE,c.GL_COST_MTHD
            FROM   sy_orgn_mst b, GL_PLCY_MST c
            WHERE  b.orgn_code = l_orgn_code
            AND    b.co_code = c.co_code;

Line: 235

         SELECT CO_CODE into l_co_code
          FROM  SY_ORGN_MST
          WHERE ORGN_CODE=p_ORGN_CODE;

Line: 239

            SELECT NOMINAL_COST into l_rsrc_cost
             FROM  CM_RSRC_DTL a,CM_CLDR_DTL b,CM_CLDR_HDR c
             WHERE a.ORGN_CODE=p_ORGN_CODE
               AND a.CALENDAR_CODE=b.CALENDAR_CODE
               AND a.PERIOD_CODE=b.PERIOD_CODE
               AND a.COST_MTHD_CODE=l_cost_mthd
               AND a.USAGE_UM=p_usage_uom
               AND a.RESOURCES=p_resource
               AND p_transaction_date between b.start_date and b.end_date
               AND b.CALENDAR_CODE=c.CALENDAR_CODE
               AND c.cost_mthd_code= l_cost_mthd
               AND c.co_code=l_co_code;