[Home] [Help]
1154: GL_SETS_OF_BOOKS gl,
1155: AR_SYSTEM_PARAMETERS_all sys,
1156: -- Added for the bug#8538945 by PNAVEENK
1157: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr
1158: HZ_PARTY_SITES PARTY_SITE,
1159: HZ_LOCATIONS LOC
1160: -- end for the bug#8538945
1161: WHERE
1162: P_MODE = 'CP'
1407: -- hz_party_preferences party_pref, -- Commented for bug13452739
1408: fnd_territories_tl fnd_terr,
1409: hz_cust_site_uses_all site_uses,
1410: hz_cust_acct_sites_all acct_site,
1411: hz_party_sites party_site,
1412: hz_locations loc
1413: WHERE
1414: party_site.location_id = loc.location_id
1415: and acct_site.party_site_id = party_site.party_site_id
1772: GL_SETS_OF_BOOKS gl,
1773: AR_SYSTEM_PARAMETERS_all sys,
1774: -- Added for the bug#8538945 by PNAVEENK
1775: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr
1776: HZ_PARTY_SITES PARTY_SITE,
1777: HZ_LOCATIONS LOC
1778: -- end for the bug#8538945
1779: WHERE
1780: trx_summ.reference_1 = '1'
2044: hz_party_preferences party_pref,
2045: fnd_territories_tl fnd_terr,
2046: hz_cust_site_uses_all site_uses,
2047: hz_cust_acct_sites_all acct_site,
2048: hz_party_sites party_site,
2049: hz_locations loc
2050: WHERE
2051: party_site.location_id = loc.location_id
2052: and acct_site.party_site_id = party_site.party_site_id
4819: loc.postal_code postal_code
4820: FROM
4821: hz_cust_site_uses_all hcsua,
4822: hz_cust_acct_sites_all hcasa,
4823: hz_party_sites hps,
4824: hz_locations loc
4825: WHERE
4826: hcsua.cust_acct_site_id=hcasa.cust_acct_site_id
4827: and hcasa.party_site_id=hps.party_site_id
9628: GL_SETS_OF_BOOKS gl,
9629: AR_SYSTEM_PARAMETERS_all sys,
9630: -- Added for the bug#8538945 by PNAVEENK
9631: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr
9632: HZ_PARTY_SITES PARTY_SITE,
9633: HZ_LOCATIONS LOC
9634: -- end for the bug#8538945
9635: WHERE trx_summ.reference_1 = '1'
9636: -- Added for the bug#8538945 by PNAVEENK