Oracle 11i Suppliers Single Insertion Scripts

SELECT -- vendor_interface_id ,

vendor_name,

vendor_name_alt,

segment1,

vat_registration_num,

summary_flag,

enabled_flag,

employee_id,

set_of_books_id,

vendor_type_lookup_code,

last_update_date,

last_updated_by,

last_update_login,

creation_date,

created_by

FROM PO_VENDORS

WHERE VENDOR_NAME LIKE '%Apps%';

-------------------------------------------------------------------------------------

SELECT vendor_id,

vendor_site_code,

purchasing_site_flag,

pay_site_flag,

address_line1,

address_line2,

address_line3,

address_lines_alt,

city,

state,

zip,

province,

country,

area_code,

phone,

LANGUAGE,

org_id,

invoice_currency_code,

payment_currency_code,

ship_to_location_id,

bill_to_location_id,

terms_id,

payment_method_lookup_code,

ship_via_lookup_code,

fob_lookup_code,

terms_date_basis,

vat_code,

accts_pay_code_combination_id,

prepay_code_combination_id,

future_dated_payment_ccid,

pay_group_lookup_code,

payment_priority,

pay_date_basis_lookup_code,

auto_tax_calc_flag,

auto_tax_calc_override,

address_style,

remittance_email,

match_option,

ap_tax_rounding_rule,

freight_terms_lookup_code,

amount_includes_tax_flag,

fax_area_code,

fax,

email_address,

last_update_date,

last_updated_by,

last_update_login,

creation_date,

created_by

FROM PO_VENDOR_SITES_ALL

WHERE VENDOR_ID = 3921;

-----------------------------------------------------------------------------------

SELECT vendor_site_id,

-- org_id ,

first_name,

last_name,

middle_name,

prefix,

title,

area_code,

phone,

contact_name_alt,

department,

last_update_date,

last_updated_by,

last_update_login,

creation_date,

created_by

FROM PO_VENDOR_CONTACTS

WHERE VENDOR_SITE_ID = 4715;

##################################################################

==> Inserting Into Supplier Headers <==

INSERT INTO apps.ap_suppliers_int (vendor_interface_id,

vendor_name,

vendor_name_alt,

segment1,

-- vat_registration_num ,

-- summary_flag ,

enabled_flag,

-- employee_id ,

set_of_books_id,

vendor_type_lookup_code,

last_update_date,

last_updated_by,

last_update_login,

creation_date,

created_by)

VALUES (apps.ap_suppliers_int_s.NEXTVAL,

'Mahesh',

'Prince',

999,

-- load_vendors_rec.ls_vat_registration_number,

-- 'N' ,

'Y',

-- load_vendors_rec.employee_id ,

1,

'SUPPLIER',

SYSDATE,

1007924,

1007924,

SYSDATE,

1007924);

COMMIT;

===> Inserting Into Suppliers Sites <===

INSERT INTO apps.ap_supplier_sites_int (vendor_id,

vendor_site_code,

purchasing_site_flag,

pay_site_flag,

address_line1,

address_line2,

address_line3,

address_lines_alt,

city,

state,

zip,

-- province ,

country,

area_code,

phone,

LANGUAGE,

org_id,

invoice_currency_code,

payment_currency_code,

ship_to_location_id,

bill_to_location_id,

terms_id,

payment_method_lookup_code,

-- ship_via_lookup_code ,

fob_lookup_code,

terms_date_basis,

-- vat_code ,

accts_pay_code_combination_id,

prepay_code_combination_id,

future_dated_payment_ccid,

pay_group_lookup_code,

payment_priority,

pay_date_basis_lookup_code,

auto_tax_calc_flag,

auto_tax_calc_override,

-- address_style ,

-- remittance_email ,

match_option,

ap_tax_rounding_rule,

freight_terms_lookup_code,

amount_includes_tax_flag,

fax_area_code,

fax,

email_address,

last_update_date,

last_updated_by,

last_update_login,

creation_date,

created_by)

VALUES (3938,

'MAH_SUPP_SIT',

'Y',

'Y',

'Habsiguda',

'Tharnaka',

'Sec Bad',

'Apps Associates, Hubsiguda, Hyd - 007',

'Hyderabad',

'Andrapradesh',

'500007',

-- load_sites_rec.ls_province ,

'IN',

'+91',

9876543210,

'AMERICAN',

204,

'USD',

'USD',

207,

204,

10002,

'CHECK',

-- load_sites_rec.ship_via_lookup_code ,

'Origin',

'Invoice',

-- load_sites_rec.ls_vat_code ,

12854,

12843,

25889,

'Standard',

99,

'DUE',

'N',

'N',

-- load_sites_rec.ls_address_style ,

-- load_sites_rec.ls_remittance_email ,

'P',

'N',

'Due',

'N',

050,

99887766,

'mahesh@suppliers.com',

SYSDATE,

1007924,

1007924,

SYSDATE,

1007924);

===> Inserting Into Supplier Contacts <===

INSERT INTO apps.ap_sup_site_contact_int (vendor_site_id,

org_id,

first_name,

last_name,

middle_name,

prefix,

title,

area_code,

phone,

contact_name_alt,

department,

last_update_date,

last_updated_by,

last_update_login,

creation_date,

created_by)

VALUES (4743,

204,

'Mahesh',

'Prince',

'Babu',

'Mr.',

'Sir',

040,

8787887,

'Nani',

'Action',

SYSDATE,

1007924,

1007924,

SYSDATE,

1007924);

######################################################################

SELECT apps.ap_suppliers_int_s.NEXTVAL FROM DUAL;

SELECT * FROM fnd_user WHERE user_name LIKE 'TRAINER';

-- USER ID =======> 1007924 --> FOR TRAINER

SELECT * FROM ALL_OBJECTS

WHERE OBJECT_NAME LIKE '%BOM%OPERATION%' AND OBJECT_TYPE LIKE 'TABLE';

SELECT * FROM PO_VENDORS

WHERE VENDOR_NAME LIKE '%Apps%'; --> SEGMENT1 = 20101 VENDOR_ID = 3921

SELECT * FROM PO_VENDOR_SITES_ALL ---> VENDOR_SITE_ID = 4715

WHERE VENDOR_ID = 3921;

SELECT * FROM PO_VENDOR_CONTACTS

WHERE VENDOR_SITE_ID = 4715;

SELECT * FROM AP_SUPPLIERS_INT;

SELECT * FROM AP_SUPPLIER_SITES_INT;

SELECT * FROM AP_SUP_SITE_CONTACT_INT;

SELECT apps.ap_suppliers_int_s.NEXTVAL, apps.ap_suppliers_int_s.CURRVAL

FROM DUAL;