Thursday, 19 January 2017

Find the Query of SQL of all Related Tables of Suppliers or Vendors in Oracle Apps EBS R12

SELECT *
FROM AP_SUPPLIERS
WHERE VENDOR_NAME LIKE 'D%'


select * from PO_VENDORS
WHERE VENDOR_NAME LIKE 'D%'

select * from hz_parties
where PARTY_NAME like 'Dan%'

select * from HZ_PARTY_USG_ASSIGNMENTS
where PARTY_ID = 21135

select * from HZ_ORGANIZATION_PROFILES
where PARTY_ID = 21135

select * from IBY_EXTERNAL_PAYEES_ALL
where PAYEE_PARTY_ID= 21135

select * from POS_SUPPLIER_MAPPINGS
where PARTY_ID = 21135

select * from ZX_PARTY_TAX_PROFILE
where PARTY_ID = 21135

HZ_PARTIES   
HZ_PARTY_SITES   
HZ_LOCATIONS   
HZ_PARTY_USG_ASSIGNMENTS   
HZ_ORGANIZATION_PROFILES   
IBY_EXTERNAL_PAYEES_ALL   
POS_SUPPLIER_MAPPINGS

No comments:

Post a Comment

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...