DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on PO_VENDORS

Line 236: , (SELECT po_vendors.customer_num

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)
239: , (SELECT po_vendors.segment1
240: FROM po_vendors

Line 237: FROM po_vendors

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)
239: , (SELECT po_vendors.segment1
240: FROM po_vendors
241: WHERE po_vendors.vendor_id = h.vendor_id)

Line 238: WHERE po_vendors.vendor_id = h.vendor_id)

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)
239: , (SELECT po_vendors.segment1
240: FROM po_vendors
241: WHERE po_vendors.vendor_id = h.vendor_id)
242: , (SELECT ap_terms_tl.NAME

Line 239: , (SELECT po_vendors.segment1

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)
239: , (SELECT po_vendors.segment1
240: FROM po_vendors
241: WHERE po_vendors.vendor_id = h.vendor_id)
242: , (SELECT ap_terms_tl.NAME
243: FROM ap_terms_tl

Line 240: FROM po_vendors

236: , (SELECT po_vendors.customer_num
237: FROM po_vendors
238: WHERE po_vendors.vendor_id = h.vendor_id)
239: , (SELECT po_vendors.segment1
240: FROM po_vendors
241: WHERE po_vendors.vendor_id = h.vendor_id)
242: , (SELECT ap_terms_tl.NAME
243: FROM ap_terms_tl
244: WHERE ap_terms_tl.term_id = h.terms_id AND

Line 241: WHERE po_vendors.vendor_id = h.vendor_id)

237: FROM po_vendors
238: WHERE po_vendors.vendor_id = h.vendor_id)
239: , (SELECT po_vendors.segment1
240: FROM po_vendors
241: WHERE po_vendors.vendor_id = h.vendor_id)
242: , (SELECT ap_terms_tl.NAME
243: FROM ap_terms_tl
244: WHERE ap_terms_tl.term_id = h.terms_id AND
245: ap_terms_tl.LANGUAGE = userenv('LANG'))