APPS.JE_ES_MODELO_EXT_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 71: , hz_cust_site_uses_all HCSU

67: FROM hz_cust_acct_sites_all HCAS
68: , hz_party_sites HPS
69: , hr_locations HL
70: , fnd_territories FT
71: , hz_cust_site_uses_all HCSU
72: WHERE HCAS.cust_acct_site_id = p_customer_address_id
73: AND HPS.party_site_id = HCAS.party_site_id
74: AND HL.location_id = HPS.location_id
75: AND HL.country(+) = FT.territory_code

Line 110: , hz_cust_site_uses_all HCSU

106: LTRIM(HL.address3||'Z','1234567890')) - 1) numero FROM hz_cust_acct_sites_all HCAS
107: , hz_party_sites HPS
108: , hz_locations HL
109: , fnd_territories FT
110: , hz_cust_site_uses_all HCSU
111: WHERE HCAS.cust_acct_site_id = p_customer_address_id
112: AND HPS.party_site_id = HCAS.party_site_id
113: AND HL.location_id = HPS.location_id
114: AND HL.country(+) = FT.territory_code

Line 165: , hz_cust_site_uses_all HCSU

161: , hz_cust_acct_sites_all HCAS
162: , hz_party_sites HPS
163: , hr_locations HL
164: , fnd_territories FT
165: , hz_cust_site_uses_all HCSU
166: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
167: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id
168: AND JZVTD.extract_source_ledger = 'AR'
169: AND JZVRS.source = 'AR'

Line 621: , hz_cust_site_uses_all HCSU

617: , hz_cust_acct_sites_all HCAS
618: , hz_party_sites HPS
619: , hz_locations HL
620: , fnd_territories FT
621: , hz_cust_site_uses_all HCSU
622: WHERE JVGT.jg_info_n3 = p_customer_id
623: AND HCAS.cust_acct_site_id = JVGT.jg_info_n2
624: AND HPS.party_site_id = HCAS.party_site_id
625: AND HL.location_id = HPS.location_id

Line 654: , hz_cust_site_uses_all HCSU

650: --, hz_cust_acct_sites_all HCAS
651: --, hz_party_sites HPS
652: --, hz_locations HL
653: --, fnd_territories FT
654: , hz_cust_site_uses_all HCSU
655: WHERE JVGT.billing_trading_partner_id = p_customer_id
656: --AND HCAS.cust_acct_site_id = JVGT.billing_tp_address_id
657: --AND HPS.party_site_id = HCAS.party_site_id
658: --AND HL.location_id = HPS.location_id

Line 1992: ,', hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca ' );

1988:
1989: lc_jgzz_modelo_query :=
1990: REPLACE( lc_jgzz_modelo_query
1991: , '$MODELO_TABLE_LIST$'
1992: ,', hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca ' );
1993:
1994:
1995: lc_jgzz_modelo_query :=
1996: REPLACE( lc_jgzz_modelo_query

Line 2061: ,', hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca ' );

2057:
2058: lc_jgzz_modelo_query :=
2059: REPLACE( lc_jgzz_modelo_query
2060: , '$MODELO_TABLE_LIST$'
2061: ,', hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca ' );
2062:
2063:
2064: lc_jgzz_modelo_query :=
2065: REPLACE( lc_jgzz_modelo_query