APPS.OKS_OKSCODET_XMLP_PKG SQL Statements

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

Line: 16

      SELECT
        MEANING
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'OKC_ROLE'
        AND LOOKUP_CODE = RLE_CODE;

Line: 34

      SELECT
        PARTY_NUMBER || '-' || NAME
      FROM
        OKX_PARTIES_V
      WHERE ID1 = OBJECT1_ID1;

Line: 40

      SELECT
        NAME
      FROM
        OKX_ORGANIZATION_DEFS_V
      WHERE ORGANIZATION_TYPE = 'OPERATING_UNIT'
        AND INFORMATION_TYPE = 'Operating Unit Information'
        AND ID1 = OBJECT1_ID1;

Line: 104

      SELECT
        XP.NAME,
        XP.CURRENT_SERIAL_NUMBER,
        XP.REFERENCE_NUMBER,
        XP.QUANTITY,
        XP.PRICING_ATTRIBUTE3,
        XP.PRICING_ATTRIBUTE4,
        XP.PRICING_ATTRIBUTE5,
        XP.SYSTEM_ID
      FROM
        OKC_K_ITEMS IT,
        OKX_CUSTOMER_PRODUCTS_V XP
      WHERE IT.CLE_ID = CL_ID
        AND IT.JTOT_OBJECT1_CODE = 'OKX_CUSTPROD'
        AND XP.ID1 = IT.OBJECT1_ID1
        AND XP.ID2 = IT.OBJECT1_ID2;

Line: 121

      SELECT
        NAME
      FROM
        OKX_SYSTEMS_V
      WHERE ID1 = CN_SYSTEM_ID
        AND ID2 = '#';

Line: 153

      SELECT
        LTRIM(RTRIM(NAME))
      FROM
        OKC_LINE_STYLES_V
      WHERE ID = SL_LSE_ID;

Line: 159

      SELECT
        NAME,
        DESCRIPTION
      FROM
        OKC_K_ITEMS IT,
        OKX_SYSTEM_ITEMS_V XI
      WHERE IT.CLE_ID = SL_ID
        AND XI.ID1 = IT.OBJECT1_ID1
        AND XI.ID2 = IT.OBJECT1_ID2;

Line: 214

      P_CONTRACT_GROUP_WHERE := ' and hr1.id in ( select INCLUDED_CHR_ID from okc_k_grpings
                                                                                    start with CGP_PARENT_ID = :p_contract_group
                                                                                    connect by CGP_PARENT_ID = PRIOR INCLUDED_CGP_ID ) ';