DBA Data[Home] [Help]

APPS.PON_FORMS_UTIL_PVT dependencies on FND_LOOKUP_VALUES

Line 655: FND_LOOKUP_VALUES lookup_1

651: lookup_1.MEANING
652: into
653: rt_value
654: from pon_auction_headers_all ah,
655: FND_LOOKUP_VALUES lookup_1
656: where
657: ah.auction_header_id = to_number(p_id)
658: and lookup_1.LOOKUP_CODE(+) = ah.BID_VISIBILITY_CODE
659: and lookup_1.VIEW_APPLICATION_ID (+) = 0

Line 670: FND_LOOKUP_VALUES lookup_2

666: select
667: lookup_2.MEANING
668: into rt_value
669: from pon_auction_headers_all ah,
670: FND_LOOKUP_VALUES lookup_2
671: where ah.auction_header_id = to_number(p_id)
672: and lookup_2.lookup_code(+) = ah.fob_code
673: and lookup_2.LOOKUP_TYPE(+) = 'FOB'
674: and lookup_2.LANGUAGE(+) = userenv('LANG')

Line 685: FND_LOOKUP_VALUES lookup_3

681: lookup_3.MEANING
682: into
683: rt_value
684: from pon_auction_headers_all ah,
685: FND_LOOKUP_VALUES lookup_3
686: where ah.auction_header_id = to_number(p_id)
687: and lookup_3.LOOKUP_CODE(+) = ah.FREIGHT_TERMS_CODE
688: and lookup_3.lookup_type ='FREIGHT TERMS'
689: and lookup_3.LANGUAGE(+) = userenv('LANG')