APPS.JL_ZZ_OE_LIBRARY_1_PKG SQL Statements

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

Line: 20

    SELECT SUBSTR (description, 1, 30)
    INTO   global_description
    FROM   fnd_descr_flex_contexts_vl
    WHERE  application_id = 7003
    AND    descriptive_flexfield_name  = 'JG_OE_ORDER_LINES'
    AND    descriptive_flex_context_code = v_dflx_cc
    AND    enabled_flag = 'Y'
    AND    rownum = row_number;

Line: 39

    SELECT A.global_attribute3
    INTO   def_val
    FROM   ra_cust_trx_types A,
           oe_order_types_v B
    WHERE  A.cust_trx_type_id = B.cust_trx_type_id
    AND    B.order_type_id    = p_order_type_id
    AND    rownum = row_number;