Wednesday, March 30, 2016

Insert Script for Open AR Transaction (Credit Memo) for R12


-------------------- For Credit Memo -----------------------------------------
INSERT
INTO Apps.ra_interface_lines_all
  (
    trx_number,
    batch_source_name,
    line_type,
    inventory_item_id,
description,
    currency_code,
    amount,
    org_id ,
    conversion_type,
    conversion_rate ,
    orig_system_bill_address_id,
    orig_system_ship_address_id,
    orig_system_bill_customer_id,
    orig_system_ship_customer_id ,
    primary_salesrep_id,
    memo_line_id,
    memo_line_name, -- (standard lines)
    creation_date,
    created_by ,
    tax_code,
    gl_date ,
    cust_trx_type_id,
    cust_trx_type_name ,
    interface_line_context,
    interface_line_attribute1,
    interface_line_attribute2,
    interface_line_attribute3,
    interface_line_attribute4
  )
  VALUES
  (
    '9996',
    'CONVERSION_GP', -- Name in ra_batch_sources_all
    'LINE',
    2256906,
'NOVASURE STERILIZED DEVICE 3 PK',
    'USD', -- Currency_code in fnd_currencies
    -100,
85 ,  -- Organization_id in hr_operating_units
    'User',
    1 ,
    125629, -- cust_acct_site_id in hz_cust_acct_sites_all
NULL, -- cust_acct_site_id in hz_cust_acct_sites_all
1321077, -- cust_account_id in hz_cust_accounts
NULL , -- cust_account_id in hz_cust_accounts
    -3, -- salesrep_id in jtf_rs_salesreps
    NULL, -- memo_line_id in ar_memo_lines_all_tl
    NULL, -- Name in ar_memo_lines_all_tl
    SYSDATE,
    1238 , -- User_Id in fnd_user
    NULL,
    SYSDATE ,
    6389, -- cust_trx_type_id in ra_cust_trx_types_all
    'GPS CORP CONV CM' ,  -- Name in ra_cust_trx_types_all
    'CONVERSION',
    '9996',
    'GENPROBE_TEST',
    'Testing',
    'Test'
  );
/


-- Submit the "Autoinvoice Master Program" Program from the respective OU

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...