DBA Data[Home] [Help]

APPS.BOM_BOMRDRSO_XMLP_PKG SQL Statements

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

Line: 12

      SELECT
        BOOKS.CURRENCY_CODE,
        ORG.ORGANIZATION_NAME,
        LU.MEANING
      INTO L_CURRENCY_CODE,L_ORG_NAME,L_DTL_SUM_CHAR
      FROM
        GL_SETS_OF_BOOKS BOOKS,
        ORG_ORGANIZATION_DEFINITIONS ORG,
        MFG_LOOKUPS LU
      WHERE ORG.ORGANIZATION_ID = P_ORG_ID
        AND BOOKS.SET_OF_BOOKS_ID = ORG.SET_OF_BOOKS_ID
        AND LU.LOOKUP_CODE = P_DETAIL_OR_SUMMARY
        AND LU.LOOKUP_TYPE = 'CST_RPT_DETAIL_OPTION';