How can i Add Employee as Supplier to Main Supplier for Petty cash in Relationship In R12.2.10
In R12.1.3 We used to Create Current Employee as Supplier, then we create Main Supplier and mark them as Petty Cash Supplier as Type. Then in Contact we add DFF with Expense Report as Petty cash Account.
Once its above step done we created main Supplier go to Relationship and Add .
IN R12.2.10 Adding Employee as Supplier to Mian Supplier in Relationship .
below Query is Protecting
SELECT pv.vendor_name supplier_name,
pv.segment1 supplier_num,
hp.duns_number_c AS duns,
DECODE(pv.organization_type_lookup_code, 'INDIVIDUAL', pv.individual_1099, 'FOREIGN INDIVIDUAL', pv.individual_1099, pv.num_1099) taxpayer_id,
pv.vat_registration_num AS tax_reg_num,