AP_SUPPLIERS MASTER DETAILS QUERY:- ***************************************** select a.SEGMENT1 vendor_code, b.VENDOR_ID, a.VENDOR_NAME, b.VENDOR_SITE_ID, (select organization_id from hr_operating_units where organization_id=b.ORG_ID )ou_id, (select name from hr_operating_units where organization_id=b.ORG_ID )operating_name, b.VENDOR_SITE_CODE, (b.ADDRESS_LINE1||b.ADDRESS_LINE2||b.ADDRESS_LINE3||b.CITY||b.STATE||b.ZIP) address, null GST_REGISTRATION_NO, c.PAN_NO, b.state from ap_suppliers a, ap_supplier_sites_All b, JAI_AP_TDS_VENDOR_HDRS c, JAI_CMN_VENDOR_SITES d where a.vendor_id=b.vendor_id and b.VENDOR_ID=c.vendor_id(+) and b.VENDOR_SITE_ID=c.VENDOR_SITE_ID(+) and b.VENDOR_ID=d.vendor_id(+) and b.VENDOR_SITE_ID=d.VENDOR_SITE_ID(+) AND (NVL(A.ENABLED_FLAG,'N')='Y' OR NVL(D.INACTIVE_FLAG,'N') <> 'N') and b.INACTIVE_DATE is null and a.end_date_active is null AND A.SEGMENT1 = 'PRMAAA1' order by a.VENDOR_NAME,b.VENDOR_SITE_CODE,b.ORG_ID AR_CUSTOMERS MASTER DETAILS QUERY:- ********************************************** select hp.party_number customer_number, hca.cust_account_id customer_id, hp.party_name customer_name, hca.account_number customer_account_number, hcas.org_id ou_id, (select name from hr_operating_units where organization_id = hcas.org_id) operating_unit_name, HCAS.PARTY_SITE_ID CUSTOMER_SITE_ID, HPS.PARTY_SITE_NUMBER CUSTOMER_SITE_NUMBER, ( HL.ADDRESS1 || HL.ADDRESS2 || HL.ADDRESS3 || HL.ADDRESS4 || HL.CITY || HL.POSTAL_CODE) ADDRESS, NULL GST_REGISTRATION_NO, jac.PAN_NO PAN_NO, hl.state, HP.PARTY_TYPE CUSTOMER_TYPE from hz_cust_acct_sites_all hcas, hz_cust_accounts_all hca, hz_parties hp, hz_party_sites hps, hz_locations hl, JAI_CMN_CUS_ADDRESSES jac where 1=1 --and hca.account_number = 'RDAAAG2' and hca.cust_account_id = hcas.cust_account_id and hca.party_id = hp.party_id and hcas.party_site_id = hps.party_site_id and hca.party_id = hps.party_id and hps.location_id = hl.location_id and jac.address_id(+) = hcas.CUST_ACCT_SITE_ID order by customer_name
Comments
Tags: AP_SUPPLIERS, AR_CUSTOMERS, Oracle Apps R12, Query, QUERY IN ORACLE APPS R12