APPS.ONT_OEXOHHSA_XMLP_PKG SQL Statements

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

Line: 8

      SELECT
        NAME
      INTO SOB_NAME
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = P_SOB_ID;

Line: 57

      SELECT
        MEANING
      INTO ACTIVITY_MEANING
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'AUTHORIZED_ACTION'
        AND LOOKUP_CODE = P_ACTIVITY;

Line: 115

      SELECT
        ORDER_NUMBER
      INTO L_ENTITY_VALUE
      FROM
        OE_ORDER_HEADERS
      WHERE HEADER_ID = OBJECT_ID;

Line: 123

        SELECT
          SUBSTRB(PARTY.PARTY_NAME
                 ,1
                 ,50)
        INTO L_ENTITY_VALUE
        FROM
          HZ_PARTIES PARTY,
          HZ_CUST_ACCOUNTS CUST_ACCT
        WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
          AND CUST_ACCT.CUST_ACCOUNT_ID = OBJECT_ID;

Line: 135

          SELECT
            DESCRIPTION
          INTO L_ENTITY_VALUE
          FROM
            MTL_SYSTEM_ITEMS_VL
          WHERE INVENTORY_ITEM_ID = OBJECT_ID
            AND NVL(ORGANIZATION_ID
             ,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
                                     ,MO_GLOBAL.GET_CURRENT_ORG_ID)
             ,0);

Line: 147

            SELECT
              SUBSTR((LOC.ADDRESS1 || ', ' || LOC.CITY || ' ' || LOC.STATE)
                    ,1
                    ,30)
            INTO L_ENTITY_VALUE
            FROM
              HZ_CUST_SITE_USES_ALL SU,
              HZ_PARTY_SITES PARTY_SITE,
              HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
              HZ_LOCATIONS LOC,
              HZ_CUST_ACCT_SITES_ALL ACCT_SITE
            WHERE SU.SITE_USE_ID = OBJECT_ID
              AND SU.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
              AND SU.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
              AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
              AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
              AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
              AND NVL(ACCT_SITE.ORG_ID
               ,-99) = NVL(LOC_ASSIGN.ORG_ID
               ,-99);

Line: 256

      SELECT
        ORDER_NUMBER
      INTO L_ENTITY_VALUE
      FROM
        OE_ORDER_HEADERS
      WHERE HEADER_ID = OBJECT_ID2;

Line: 264

        SELECT
          SUBSTRB(PARTY.PARTY_NAME
                 ,1
                 ,50)
        INTO L_ENTITY_VALUE
        FROM
          HZ_PARTIES PARTY,
          HZ_CUST_ACCOUNTS CUST_ACCT
        WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
          AND CUST_ACCT.CUST_ACCOUNT_ID = OBJECT_ID2;

Line: 276

          SELECT
            DESCRIPTION
          INTO L_ENTITY_VALUE
          FROM
            MTL_SYSTEM_ITEMS_VL
          WHERE INVENTORY_ITEM_ID = OBJECT_ID2
            AND NVL(ORGANIZATION_ID
             ,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
                                     ,MO_GLOBAL.GET_CURRENT_ORG_ID)
             ,0);

Line: 288

            SELECT
              SUBSTR((LOC.ADDRESS1 || ', ' || LOC.CITY || ' ' || LOC.STATE)
                    ,1
                    ,30)
            INTO L_ENTITY_VALUE
            FROM
              HZ_CUST_SITE_USES_ALL SU,
              HZ_PARTY_SITES PARTY_SITE,
              HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
              HZ_LOCATIONS LOC,
              HZ_CUST_ACCT_SITES_ALL ACCT_SITE
            WHERE SU.SITE_USE_ID = OBJECT_ID2
              AND SU.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
              AND SU.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
              AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
              AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
              AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
              AND NVL(ACCT_SITE.ORG_ID
               ,-99) = NVL(LOC_ASSIGN.ORG_ID
               ,-99);