APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITE_INFORMATION

Line 313: FROM ibe_msite_information

309:
310: -- For payment method, credit card type, and shipment method
311: OPEN x_pm_cc_sm_cur FOR SELECT msite_information_context, msite_information1,
312: msite_information2 -- added by YAXU for payment threshold
313: FROM ibe_msite_information
314: WHERE msite_id = l_msite_id
315: AND msite_information_context = 'SHPMT_MTHD'
316: UNION -- added by JQU for validating the TAG.
317: SELECT msite_information_context, msite_information1,

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 329: FROM ibe_msite_information a, iby_creditcard_issuers_b cc

325: AND b.language=userenv('lang')
326: UNION
327: SELECT msite_information_context, msite_information1,
328: msite_information2
329: FROM ibe_msite_information a, iby_creditcard_issuers_b cc
330: WHERE a.msite_id = l_msite_id
331: AND a.msite_information1 = cc.card_issuer_code
332: ORDER BY msite_information_context;
333:

Line 831: -- (from ibe_msite_information table)

827: AND MM.site_type = 'I'
828: ORDER BY MM.msite_id;
829:
830: -- Payment method, credit card type and shipment method assocation
831: -- (from ibe_msite_information table)
832: OPEN x_pm_cc_sm_cur FOR SELECT /*+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) */
833: MM.msite_id, MI.msite_information_context, MI.msite_information1,MI.msite_information2
834: FROM(select distinct to_number(t.column_value) as msite_id
835: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

Line 837: ibe_msites_b MM, ibe_msite_information MI

833: MM.msite_id, MI.msite_information_context, MI.msite_information1,MI.msite_information2
834: FROM(select distinct to_number(t.column_value) as msite_id
835: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
836: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
837: ibe_msites_b MM, ibe_msite_information MI
838: WHERE MM.msite_id = MI.msite_id
839: AND MM.msite_id = v.msite_id
840: AND MM.site_type = 'I'
841: AND MI.msite_information_context = 'SHPMT_MTHD'

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

Line 863: ibe_msites_b MM, ibe_msite_information MI, iby_creditcard_issuers_b cci

859: MM.msite_id, MI.msite_information_context,MI.msite_information1,MI.msite_information2
860: FROM(select distinct to_number(t.column_value) as msite_id
861: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
862: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
863: ibe_msites_b MM, ibe_msite_information MI, iby_creditcard_issuers_b cci
864: WHERE MM.msite_id = MI.msite_id
865: AND MM.msite_id = v.msite_id
866: AND MM.site_type = 'I'
867: AND (MI.msite_information1 = cci.CARD_ISSUER_CODE)