DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on AP_TERMS_TL

Line 242: , (SELECT ap_terms_tl.NAME

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'))
246: , (SELECT po_lookup_codes.displayed_field

Line 243: FROM ap_terms_tl

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'))
246: , (SELECT po_lookup_codes.displayed_field
247: FROM po_lookup_codes

Line 244: WHERE ap_terms_tl.term_id = h.terms_id AND

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'))
246: , (SELECT po_lookup_codes.displayed_field
247: FROM po_lookup_codes
248: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND

Line 245: ap_terms_tl.LANGUAGE = userenv('LANG'))

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'))
246: , (SELECT po_lookup_codes.displayed_field
247: FROM po_lookup_codes
248: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
249: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)