APPS.IBE_MINISITERUNTIME_PVT dependencies on FND_LOOKUP_VALUES

Line 584: FROM ibe_msite_information a, fnd_lookup_values b

580: AND msite_information_context = 'SHPMT_MTHD'
581: UNION -- added by JQU for validating the TAG.
582: SELECT msite_information_context, msite_information1,
583: msite_information2 -- added by YAXU for payment threshold
584: FROM ibe_msite_information a, fnd_lookup_values b
585: WHERE a.msite_id = l_msite_id
586: AND a.msite_information1 = b.lookup_code
587: AND ((b.LOOKUP_TYPE= 'CREDIT_CARD' and b.VIEW_APPLICATION_ID='660' )
588: OR (b.LOOKUP_TYPE = 'IBE_PAYMENT_TYPE'))

Line 1113: ibe_msites_b MM, ibe_msite_information MI, fnd_lookup_values FLV

1109: MM.msite_id, MI.msite_information_context,MI.msite_information1,MI.msite_information2
1110: FROM(select distinct to_number(t.column_value) as msite_id
1111: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1112: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1113: ibe_msites_b MM, ibe_msite_information MI, fnd_lookup_values FLV
1114: WHERE MM.msite_id = MI.msite_id
1115: AND MM.msite_id = v.msite_id
1116: AND MM.site_type = 'I'
1117: AND MI.msite_information1 = FLV.lookup_code