/* Formatted on 1/11/2012 10:31:11 PM (QP5 v5.115.810.9015) */
UPDATE XX_AP_CHECKS_11I_R12
SET R12_CURRENCY_CODE = NULL,
R12_OPERATING_UNIT = NULL,
R12_CHECK_ID = NULL,
R12_VENDOR_NAME = NULL,
R12_VENDOR_SITE_CODE = NULL,
R12_CHECK_NUMBER = NULL,
R12_CHECK_DATE = NULL,
R12_CHECK_AMOUNT = NULL,
R12_BANK_ACCT_NAME = NULL,
NO_OF_REC = NULL,
COUNT_OF_INVOICES = NULL,
STATUS = NULL --WHERE R12_CURRENCY_CODE LIKE 'R12'
UPDATE XX_AP_CHECKS_11I_R12
SET R12_CURRENCY_CODE = NULL,
R12_OPERATING_UNIT = NULL,
R12_CHECK_ID = NULL,
R12_VENDOR_NAME = NULL,
R12_VENDOR_SITE_CODE = NULL,
R12_CHECK_NUMBER = NULL,
R12_CHECK_DATE = NULL,
R12_CHECK_AMOUNT = NULL,
R12_BANK_ACCT_NAME = NULL,
NO_OF_REC = NULL,
COUNT_OF_INVOICES = NULL,
STATUS = NULL --WHERE R12_CURRENCY_CODE LIKE 'R12'
No comments:
Post a Comment