DBA Data[Home] [Help]

APPS.JL_ZZ_POSTBATCH SQL Statements

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

Line: 12

    UPDATE ar_cash_receipts
    SET    global_attribute1 = (SELECT name
                                FROM ar_batches
                                WHERE batch_id = p_batch_id),
           global_attribute_category = 'JL.AR.ARXRWMAI.RGW_FOLDER'
    WHERE  cash_receipt_id = p_cash_receipt_id;