APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITE_INFORMATION

Line 578: FROM ibe_msite_information

574:
575: -- For payment method, credit card type, and shipment method
576: OPEN x_pm_cc_sm_cur FOR SELECT msite_information_context, msite_information1,
577: msite_information2 -- added by YAXU for payment threshold
578: FROM ibe_msite_information
579: WHERE msite_id = l_msite_id
580: AND msite_information_context = 'SHPMT_MTHD'
581: UNION -- added by JQU for validating the TAG.
582: SELECT msite_information_context, msite_information1,

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

590: AND b.language=userenv('lang')
591: UNION
592: SELECT msite_information_context, msite_information1,
593: msite_information2
594: FROM ibe_msite_information a, iby_creditcard_issuers_b cc
595: WHERE a.msite_id = l_msite_id
596: AND a.msite_information1 = cc.card_issuer_code
597: ORDER BY msite_information_context;
598:

Line 1096: -- (from ibe_msite_information table)

1092: AND MM.site_type = 'I'
1093: ORDER BY MM.msite_id;
1094:
1095: -- Payment method, credit card type and shipment method assocation
1096: -- (from ibe_msite_information table)
1097: OPEN x_pm_cc_sm_cur FOR SELECT /*+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) */
1098: MM.msite_id, MI.msite_information_context, MI.msite_information1,MI.msite_information2
1099: FROM(select distinct to_number(t.column_value) as msite_id
1100: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

Line 1102: ibe_msites_b MM, ibe_msite_information MI

1098: MM.msite_id, MI.msite_information_context, MI.msite_information1,MI.msite_information2
1099: FROM(select distinct to_number(t.column_value) as msite_id
1100: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1101: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1102: ibe_msites_b MM, ibe_msite_information MI
1103: WHERE MM.msite_id = MI.msite_id
1104: AND MM.msite_id = v.msite_id
1105: AND MM.site_type = 'I'
1106: AND MI.msite_information_context = 'SHPMT_MTHD'

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

Line 1128: ibe_msites_b MM, ibe_msite_information MI, iby_creditcard_issuers_b cci

1124: MM.msite_id, MI.msite_information_context,MI.msite_information1,MI.msite_information2
1125: FROM(select distinct to_number(t.column_value) as msite_id
1126: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1127: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1128: ibe_msites_b MM, ibe_msite_information MI, iby_creditcard_issuers_b cci
1129: WHERE MM.msite_id = MI.msite_id
1130: AND MM.msite_id = v.msite_id
1131: AND MM.site_type = 'I'
1132: AND (MI.msite_information1 = cci.CARD_ISSUER_CODE)