DBA Data[Home] [Help]

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on FND_TERRITORIES_TL

Line 298: fnd_territories_tl fnd_terr,

294: hz_cust_accounts acc,
295: hz_parties party,
296: jtf_objects_b objb,
297: hz_contact_points phone,
298: fnd_territories_tl fnd_terr,
299: hz_cust_site_uses_all site_uses,
300: hz_customer_profiles prf,
301: ar_collectors ac,
302: GL_SETS_OF_BOOKS gl,

Line 560: fnd_territories_tl fnd_terr,

556: hz_cust_accounts acc,
557: hz_parties party,
558: jtf_objects_b objb,
559: hz_contact_points phone,
560: fnd_territories_tl fnd_terr,
561: hz_cust_site_uses_all site_uses,
562: hz_customer_profiles prf,
563: ar_collectors ac,
564: GL_SETS_OF_BOOKS gl,

Line 825: fnd_territories_tl fnd_terr,

821: hz_cust_accounts acc,
822: hz_parties party,
823: jtf_objects_b objb,
824: hz_contact_points phone,
825: fnd_territories_tl fnd_terr,
826: hz_customer_profiles prf,
827: ar_collectors ac,
828: GL_SETS_OF_BOOKS gl,
829: AR_SYSTEM_PARAMETERS_all sys

Line 1083: fnd_territories_tl fnd_terr,

1079: hz_cust_accounts acc,
1080: hz_parties party,
1081: jtf_objects_b objb,
1082: hz_contact_points phone,
1083: fnd_territories_tl fnd_terr,
1084: hz_customer_profiles prf,
1085: ar_collectors ac,
1086: GL_SETS_OF_BOOKS gl,
1087: AR_SYSTEM_PARAMETERS_all sys

Line 1332: fnd_territories_tl fnd_terr,

1328: hz_cust_accounts acc,
1329: hz_parties party,
1330: jtf_objects_b objb,
1331: hz_contact_points phone,
1332: fnd_territories_tl fnd_terr,
1333: hz_customer_profiles prf,
1334: ar_collectors ac,
1335: GL_SETS_OF_BOOKS gl,
1336: AR_SYSTEM_PARAMETERS_all sys

Line 1572: fnd_territories_tl fnd_terr,

1568: hz_cust_accounts acc,
1569: hz_parties party,
1570: jtf_objects_b objb,
1571: hz_contact_points phone,
1572: fnd_territories_tl fnd_terr,
1573: hz_customer_profiles prf,
1574: ar_collectors ac,
1575: GL_SETS_OF_BOOKS gl,
1576: AR_SYSTEM_PARAMETERS_all sys

Line 1701: fnd_territories_tl fnd_terr

1697: party.postal_code postal_code
1698: FROM
1699: hz_parties party,
1700: iex_dln_uwq_summary ids,
1701: fnd_territories_tl fnd_terr
1702: WHERE
1703: party.party_id = ids.party_id
1704: AND party.country = fnd_terr.territory_code(+)
1705: AND fnd_terr.LANGUAGE(+) = userenv('LANG')

Line 3488: fnd_territories_tl fnd_terr,

3484: FROM ar_trx_bal_summary trx_summ,
3485: hz_cust_accounts acc,
3486: hz_parties party,
3487: jtf_objects_b objb,
3488: fnd_territories_tl fnd_terr,
3489: hz_cust_site_uses_all site_uses,
3490: GL_SETS_OF_BOOKS gl,
3491: AR_SYSTEM_PARAMETERS_all sys
3492: WHERE trx_summ.reference_1 = '1'

Line 4719: fnd_territories_tl fnd_terr,

4715: FROM ar_trx_bal_summary trx_summ,
4716: hz_cust_accounts acc,
4717: hz_parties party,
4718: jtf_objects_b objb,
4719: fnd_territories_tl fnd_terr,
4720: GL_SETS_OF_BOOKS gl,
4721: AR_SYSTEM_PARAMETERS_all sys
4722: WHERE
4723: trx_summ.reference_1 = '1'

Line 5946: fnd_territories_tl fnd_terr,

5942: FROM ar_trx_bal_summary trx_summ,
5943: hz_cust_accounts acc,
5944: hz_parties party,
5945: jtf_objects_b objb,
5946: fnd_territories_tl fnd_terr,
5947: GL_SETS_OF_BOOKS gl,
5948: AR_SYSTEM_PARAMETERS_all sys
5949: WHERE trx_summ.reference_1 = '1'
5950: AND trx_summ.cust_account_id = acc.cust_account_id