APPS.OE_COMMITMENT_UTIL SQL Statements

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

Line: 38

    SELECT  oe.commitment_id
    ,	    ra.trx_number
    ,	    ra.start_date_commitment
    ,	    ra.end_date_commitment

    INTO    x_commitment_id
    ,       x_commitment_number
    ,       x_commitment_start_date
    ,       x_commitment_end_date

    FROM    oe_order_lines oe
    ,	    ra_customer_trx_all ra

    WHERE   oe.commitment_id = ra.customer_trx_id
    AND     line_id = p_line_id
    ;