APPS.BOM_CSTGMSBK_XMLP_PKG SQL Statements

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

Line: 76

      SELECT
        FND_DATE.DATE_TO_CHARDT(SYSDATE)
      INTO P_SYSTEM_DATE
      FROM
        DUAL;

Line: 83

      SELECT
        FND_DATE.DATE_TO_CHARDATE(TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_FROM)))
      INTO P_DATE_FROM_FORMATTING
      FROM
        DUAL;

Line: 90

      SELECT
        FND_DATE.DATE_TO_CHARDATE(TRUNC(FND_DATE.CANONICAL_TO_DATE(P_DATE_TO)))
      INTO P_DATE_TO_FORMATTING
      FROM
        DUAL;

Line: 97

      SELECT
        FC.EXTENDED_PRECISION,
        GSOB.CURRENCY_CODE
      INTO CP_PRECISION_VAL,CP_CURRENCY_CODE
      FROM
        GL_SETS_OF_BOOKS GSOB,
        ORG_ORGANIZATION_DEFINITIONS OOD,
        FND_CURRENCIES FC
      WHERE OOD.ORGANIZATION_ID = P_ORG_ID
        AND OOD.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
        AND FC.CURRENCY_CODE = GSOB.CURRENCY_CODE;

Line: 110

      SELECT
        FRV.RESPONSIBILITY_NAME,
        FND_DATE.DATE_TO_CHARDT(FCR.REQUEST_DATE),
        FAV.APPLICATION_NAME,
        FU.USER_NAME
      INTO CP_RESPONSIBILITY,CP_REQUEST_TIME,CP_APPLICATION,CP_REQUESTED_BY
      FROM
        FND_CONCURRENT_REQUESTS FCR,
        FND_RESPONSIBILITY_VL FRV,
        FND_APPLICATION_VL FAV,
        FND_USER FU
      WHERE FCR.REQUEST_ID = P_CONC_REQUEST_ID
        AND FCR.RESPONSIBILITY_APPLICATION_ID = FRV.APPLICATION_ID
        AND FCR.RESPONSIBILITY_ID = FRV.RESPONSIBILITY_ID
        AND FRV.APPLICATION_ID = FAV.APPLICATION_ID
        AND FU.USER_ID = FCR.REQUESTED_BY;

Line: 127

    SELECT
      MEANING
    INTO CP_INCLUDE_COST
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_CODE = P_INCLUDE_ITEM_COST
      AND LOOKUP_TYPE = 'YES_NO';

Line: 134

    SELECT
      MEANING
    INTO CP_DETAIL
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_CODE = P_DETAIL
      AND LOOKUP_TYPE = 'INV_BOOK_DETAIL';

Line: 142

      SELECT
        ABC_CLASS_NAME
      INTO CP_ABC_CLASS_NAME
      FROM
        MTL_ABC_CLASSES
      WHERE ABC_CLASS_ID = P_ABC_CLASS_ID;

Line: 150

      SELECT
        ASSIGNMENT_GROUP_NAME
      INTO CP_ABC_GROUP_NAME
      FROM
        MTL_ABC_ASSIGNMENT_GROUPS
      WHERE ASSIGNMENT_GROUP_ID = P_ABC_GROUP_ID;

Line: 158

      SELECT
        CATEGORY_SET_NAME
      INTO CP_CATEGORY_SET_NAME
      FROM
        MTL_CATEGORY_SETS
      WHERE CATEGORY_SET_ID = P_CATEGORY_SET_ID;

Line: 239

    SELECT
      count(*)
    INTO COUNT_ROWS
    FROM
      CST_MGD_MSTR_BOOK_TEMP;