DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on FND_TERRITORIES

Line 205: FROM FND_TERRITORIES

201: , pvsa.address_line2
202: , pvsa.address_line3
203: , pvsa.city || ' ' || pvsa.state || ' ' || pvsa.zip
204: , ( SELECT nls_territory
205: FROM FND_TERRITORIES
206: WHERE territory_code= pvsa.country)
207: , hrloc.location_code
208: , hrloc.address_line_1
209: , hrloc.address_line_2

Line 213: FROM FND_TERRITORIES

209: , hrloc.address_line_2
210: , hrloc.address_line_3
211: , hrloc.region_1 || ' ' || hrloc.region_2 || ' ' || hrloc.postal_code
212: , ( SELECT nls_territory
213: FROM FND_TERRITORIES
214: WHERE territory_code= hrloc.country)
215: , hrloc2.location_code
216: , hrloc2.address_line_1
217: , hrloc2.address_line_2

Line 221: FROM FND_TERRITORIES

217: , hrloc2.address_line_2
218: , hrloc2.address_line_3
219: , hrloc2.region_1 || ' ' || hrloc2.region_2 || ' ' || hrloc2.postal_code
220: , ( SELECT nls_territory
221: FROM FND_TERRITORIES
222: WHERE territory_code= hrloc2.country)
223: , (SELECT po_vendors.customer_num
224: FROM po_vendors
225: WHERE po_vendors.vendor_id = h.vendor_id)