DBA Data[Home] [Help]

APPS.PO_OTM_INTEGRATION_PVT dependencies on FND_TERRITORIES

Line 892: , fnd_territories fter

888: , x_otm_doc.terms
889: FROM po_headers_archive_all poha
890: , po_vendors pov
891: , po_vendor_sites_all povs
892: , fnd_territories fter
893: , po_vendor_contacts povc
894: , hr_all_organization_units hou
895: , hr_locations_all hrl
896: , per_all_people_f ppf

Line 1655: , fnd_territories fter

1651: FROM po_headers_archive_all poha
1652: , po_releases_archive_all pora
1653: , po_vendors pov
1654: , po_vendor_sites_all povs
1655: , fnd_territories fter
1656: , po_vendor_contacts povc
1657: , hr_all_organization_units hou
1658: , hr_locations_all hrl
1659: , per_all_people_f ppf

Line 2251: l_territory_short_name FND_TERRITORIES_TL.territory_short_name%TYPE;

2247: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2248: )
2249: IS
2250:
2251: l_territory_short_name FND_TERRITORIES_TL.territory_short_name%TYPE;
2252:
2253: d_progress VARCHAR2(3);
2254: d_module CONSTANT VARCHAR2(100) := g_module_prefix || 'POPULATE_ADDRESS';
2255:

Line 2337: l_territory_short_name FND_TERRITORIES_TL.territory_short_name%TYPE;

2333: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
2334: )
2335: IS
2336:
2337: l_territory_short_name FND_TERRITORIES_TL.territory_short_name%TYPE;
2338:
2339: d_progress VARCHAR2(3);
2340: d_module CONSTANT VARCHAR2(100) := g_module_prefix || 'POPULATE_ADDRESS';
2341: