APPS.BOM_CSTROMMA_XMLP_PKG SQL Statements

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

Line: 33

      SELECT
        NVL(MULTI_ORG_FLAG
           ,'N')
      INTO P_MULTI_ORG_FLAG
      FROM
        FND_PRODUCT_GROUPS;

Line: 52

      SELECT
        MIN(OOD.ORGANIZATION_ID)
      INTO L_IF_OU_NOT_INVORG
      FROM
        ORG_ORGANIZATION_DEFINITIONS OOD
      WHERE DECODE(P_MULTI_ORG_FLAG
            ,'Y'
            ,OOD.OPERATING_UNIT
            ,OOD.ORGANIZATION_ID) = P_OPERATING_UNIT;

Line: 63

      SELECT
        O.ORGANIZATION_NAME,
        MP.MASTER_ORGANIZATION_ID,
        MP.COST_ORGANIZATION_ID,
        NVL(MINIMUM_ACCOUNTABLE_UNIT
           ,POWER(10
                ,NVL(-PRECISION
                   ,0))),
        NVL(FC.EXTENDED_PRECISION
           ,NVL(FC.PRECISION
              ,0)),
        MCS.CATEGORY_SET_NAME,
        LU1.MEANING,
        LU2.MEANING,
        LU3.MEANING
      INTO P_ORGANIZATION,P_MASTER_ORG_ID,P_COST_ORG_ID,P_ROUND_UNIT,P_EXT_PREC,P_CAT_SET_NAME,P_SORT_BY,P_CUST_OPT_DSP,P_RPT_OPT_DSP
      FROM
        ORG_ORGANIZATION_DEFINITIONS O,
        FND_CURRENCIES FC,
        MTL_CATEGORY_SETS MCS,
        MTL_PARAMETERS MP,
        MFG_LOOKUPS LU1,
        MFG_LOOKUPS LU2,
        MFG_LOOKUPS LU3
      WHERE FC.CURRENCY_CODE = LP_CURRENCY_CODE
        AND MP.ORGANIZATION_ID = L_IF_OU_NOT_INVORG
        AND MCS.CATEGORY_SET_ID = P_CATEGORY_SET
        AND O.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
        AND LU1.LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT'
        AND LU1.LOOKUP_CODE = P_SORT_OPTION
        AND LU2.LOOKUP_TYPE = 'CST_RA_CUSTOMER_TYPE'
        AND LU2.LOOKUP_CODE = NVL(P_CUST_OPT
         ,2)
        AND LU3.LOOKUP_TYPE = 'CST_BICR_DETAIL_OPTION'
        AND LU3.LOOKUP_CODE = NVL(P_RPT_OPTION
         ,1);

Line: 106

        P_SQL_SELECT_COST_TYPE := ' NVL( temp.cogs_amount, 0 ) ';

Line: 111

        SELECT
          COST_TYPE,
          DEFAULT_COST_TYPE_ID
        INTO P_COST_TYPE,P_DEF_COST_TYPE
        FROM
          CST_COST_TYPES
        WHERE COST_TYPE_ID = P_COST_TYPE_ID;

Line: 118

        P_SQL_SELECT_COST_TYPE := ' NVL( temp.ship_quantity, 0 ) * ' || ' NVL( decode( cic1.cost_type_id, null, cic2.item_cost, cic1.item_cost ), 0 ) ';

Line: 126

      SELECT
        NAME
      INTO P_OPERATING_UNIT_NAME
      FROM
        HR_OPERATING_UNITS
      WHERE ORGANIZATION_ID = P_OPERATING_UNIT;

Line: 135

      SELECT
        MEANING
      INTO P_CONFIG_ITEM_DTLS_OPTS
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'SYS_YES_NO'
        AND LOOKUP_CODE = NVL(P_CONFIG_ITEM_DETAILS
         ,2);

Line: 146

      SELECT
        MIN(ORDER_NUMBER)
      INTO P_ORDER_NUMBER
      FROM
        OE_ORDER_HEADERS_ALL
      WHERE HEADER_ID = P_HEADER_ID;

Line: 163

        SELECT
          HP.PARTY_NAME
        INTO P_CUSTOMER_NAME
        FROM
          HZ_CUST_ACCOUNTS HCA,
          HZ_PARTIES HP
        WHERE HCA.CUST_ACCOUNT_ID = P_CUSTOMER
          AND HP.PARTY_ID = HCA.PARTY_ID;

Line: 176

        SELECT
          NAME
        INTO P_SALESREP_NAME
        FROM
          RA_SALESREPS_ALL
        WHERE SALESREP_ID = P_SALESREP
          AND DECODE(P_MULTI_ORG_FLAG
              ,'Y'
              ,NVL(ORG_ID
                 ,-999)
              ,999) = DECODE(P_MULTI_ORG_FLAG
              ,'Y'
              ,NVL(P_OPERATING_UNIT
                 ,NVL(ORG_ID
                    ,-999))
              ,999);

Line: 196

        SELECT
          MEANING
        INTO P_SALES_CHANNEL
        FROM
          SO_LOOKUPS
        WHERE LOOKUP_TYPE = 'SALES_CHANNEL'
          AND LOOKUP_CODE = P_SALES_CHANNEL_CODE;

Line: 207

        SELECT
          MEANING
        INTO P_CLASS
        FROM
          AR_LOOKUPS
        WHERE LOOKUP_TYPE = 'CUSTOMER CLASS'
          AND LOOKUP_CODE = P_CLASS_CODE;

Line: 218

        SELECT
          NAME
        INTO P_TERRITORY
        FROM
          RA_TERRITORIES
        WHERE TERRITORY_ID = P_TERRITORY_ID;

Line: 227

      SELECT
        SOB.CURRENCY_CODE
      INTO L_FCN_CURRENCY
      FROM
        GL_SETS_OF_BOOKS SOB,
        ORG_ORGANIZATION_DEFINITIONS OOD
      WHERE OOD.ORGANIZATION_ID = L_IF_OU_NOT_INVORG
        AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID;