APPS.IBE_MINISITERUNTIME_PVT dependencies on FND_LOOKUP_VALUES

Line 319: FROM ibe_msite_information a, fnd_lookup_values b

315: AND msite_information_context = 'SHPMT_MTHD'
316: UNION -- added by JQU for validating the TAG.
317: SELECT msite_information_context, msite_information1,
318: msite_information2 -- added by YAXU for payment threshold
319: FROM ibe_msite_information a, fnd_lookup_values b
320: WHERE a.msite_id = l_msite_id
321: AND a.msite_information1 = b.lookup_code
322: AND ((b.LOOKUP_TYPE= 'CREDIT_CARD' and b.VIEW_APPLICATION_ID='660' )
323: OR (b.LOOKUP_TYPE = 'IBE_PAYMENT_TYPE'))

Line 848: ibe_msites_b MM, ibe_msite_information MI, fnd_lookup_values FLV

844: MM.msite_id, MI.msite_information_context,MI.msite_information1,MI.msite_information2
845: FROM(select distinct to_number(t.column_value) as msite_id
846: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
847: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
848: ibe_msites_b MM, ibe_msite_information MI, fnd_lookup_values FLV
849: WHERE MM.msite_id = MI.msite_id
850: AND MM.msite_id = v.msite_id
851: AND MM.site_type = 'I'
852: AND MI.msite_information1 = FLV.lookup_code