Friday, December 12, 2008

R12 AR Credit Memo Creation Single Insert

INSERT INTO RA_INTERFACE_LINES_ALL
(batch_source_name,
line_type,
description,
conversion_type,
currency_code,
created_by,
creation_date,
last_updated_by,
last_update_date,
amount, trx_date,
primary_salesrep_id,
cust_trx_type_id,
orig_system_bill_customer_id,
orig_system_bill_address_id,
orig_system_sold_customer_id,
conversion_rate,
uom_code,
line_number,
interface_line_attribute1,
interface_line_attribute2,
interface_line_context,
org_id,
reference_line_id,
reference_line_context,
gl_date
)
VALUES
('LEGACY', 'LINE', 'Maintenance', 'User',
'USD', 1012015, SYSDATE, 1012015,
SYSDATE, -1000, SYSDATE, 10068,
2, 1288,
1338, 1288,
1, 'Ea', 1,
'631152680', '1',
'VISION BUILD', 204, 806412,
'VISION BUILD', SYSDATE
);

No comments: