Single_Insert_for_Open_AR_Transactions

-------------------- For Invoice -----------------------------------------
INSERT
INTO Apps.ra_interface_lines_all
  (
    trx_number,
    batch_source_name,
    line_type,
    Inventory_item_id, 
	description,
	uom_code,
	quantity_ordered,
    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 ,
    term_id,
    term_name,
    cust_trx_type_id,
    cust_trx_type_name ,
    interface_line_context,
    interface_line_attribute1,
    interface_line_attribute2,
    interface_line_attribute3,
    interface_line_attribute4
  )
  VALUES
  (
    '9997',
    'CONVERSION_GP', -- Name in ra_batch_sources_all
    'LINE',
    2256906, -- Inventory_item_id in mtl_system_items_b
	'NOVASURE STERILIZED DEVICE 3 PK',	-- Description in mtl_system_items_b
	'EA', 
	2,
    'USD', -- Currency_code in fnd_currencies
    150,	
	85 ,  -- Organization_id in hr_operating_units
    'User',	
    1 ,
    377980, -- cust_acct_site_id in hz_cust_acct_sites_all
	NULL, -- cust_acct_site_id in hz_cust_acct_sites_all
	2955128, -- 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 ,
    1010, -- term_id in ra_terms_tl
    '90 NET', -- Name in ra_terms_tl
    5396, -- cust_trx_type_id in ra_cust_trx_types_all
    'GPI CORP CONV INV' , -- Name in ra_cust_trx_types_all
    'CONVERSION', 
    '9997',
    'GENPROBE_TEST',
    'Testing',
    'Test'
  );
  
-- Submit the "Autoinvoice Master Program" Program from the respective OU
  
-------------------- 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