DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on FND_TERRITORIES

Line 218: FROM FND_TERRITORIES

214: , pvsa.address_line2
215: , pvsa.address_line3
216: , pvsa.city || ' ' || pvsa.state || ' ' || pvsa.zip
217: , ( SELECT nls_territory
218: FROM FND_TERRITORIES
219: WHERE territory_code= pvsa.country)
220: , hrloc.location_code
221: , hrloc.address_line_1
222: , hrloc.address_line_2

Line 226: FROM FND_TERRITORIES

222: , hrloc.address_line_2
223: , hrloc.address_line_3
224: , hrloc.region_1 || ' ' || hrloc.region_2 || ' ' || hrloc.postal_code
225: , ( SELECT nls_territory
226: FROM FND_TERRITORIES
227: WHERE territory_code= hrloc.country)
228: , hrloc2.location_code
229: , hrloc2.address_line_1
230: , hrloc2.address_line_2

Line 234: FROM FND_TERRITORIES

230: , hrloc2.address_line_2
231: , hrloc2.address_line_3
232: , hrloc2.region_1 || ' ' || hrloc2.region_2 || ' ' || hrloc2.postal_code
233: , ( SELECT nls_territory
234: FROM FND_TERRITORIES
235: WHERE territory_code= hrloc2.country)
236: , (SELECT po_vendors.customer_num
237: FROM po_vendors
238: WHERE po_vendors.vendor_id = h.vendor_id)