APPS.OKS_OKSNREPD_XMLP_PKG SQL Statements

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

Line: 6

      SELECT
        CS.NAME
      FROM
        CS_SYSTEMS CS,
        OKX_CUST_PROD_V CPV
      WHERE CPV.CUSTOMER_PRODUCT_ID = CUSTOMER_PRODUCT_ID_v
        AND CPV.SYSTEM_ID = CS.SYSTEM_ID;

Line: 31

      SELECT
        MTL.SEGMENT1,
        MTL.DESCRIPTION
      FROM
        MTL_SYSTEM_ITEMS_B MTL,
        CS_CUSTOMER_PRODUCTS_ALL CP
      WHERE CP.CUSTOMER_PRODUCT_ID = CUSTOMER_PRODUCT_ID_v
        AND CP.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
        AND MTL.ORGANIZATION_ID = ORGANIZATION_ID_v;

Line: 64

    SELECT
      DISTINCT
      NAME
    INTO L_REP_NAME
    FROM
      JTF_RS_SALESREPS
    WHERE SALESREP_ID = SALESREP_ID_v
      AND ORG_ID = ORG_ID_v
      AND ROWNUM < 2;

Line: 118

      P_CONTRACT_GROUP_WHERE := ' and exp.contract_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 ) ';