DBA Data[Home] [Help]

APPS.PON_FORMS_UTIL_PVT dependencies on FND_LOOKUP_VALUES

Line 662: FND_LOOKUP_VALUES lookup_1

658: lookup_1.MEANING
659: into
660: rt_value
661: from pon_auction_headers_all ah,
662: FND_LOOKUP_VALUES lookup_1
663: where
664: ah.auction_header_id = to_number(p_id)
665: and lookup_1.LOOKUP_CODE(+) = ah.BID_VISIBILITY_CODE
666: and lookup_1.VIEW_APPLICATION_ID (+) = 0

Line 677: FND_LOOKUP_VALUES lookup_2

673: select
674: lookup_2.MEANING
675: into rt_value
676: from pon_auction_headers_all ah,
677: FND_LOOKUP_VALUES lookup_2
678: where ah.auction_header_id = to_number(p_id)
679: and lookup_2.lookup_code(+) = ah.fob_code
680: and lookup_2.LOOKUP_TYPE(+) = 'FOB'
681: and lookup_2.LANGUAGE(+) = userenv('LANG')

Line 692: FND_LOOKUP_VALUES lookup_3

688: lookup_3.MEANING
689: into
690: rt_value
691: from pon_auction_headers_all ah,
692: FND_LOOKUP_VALUES lookup_3
693: where ah.auction_header_id = to_number(p_id)
694: and lookup_3.LOOKUP_CODE(+) = ah.FREIGHT_TERMS_CODE
695: and lookup_3.lookup_type ='FREIGHT TERMS'
696: and lookup_3.LANGUAGE(+) = userenv('LANG')