eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITES_B

Line 38: SELECT msite_id, msite_root_section_id FROM ibe_msites_b

34: 'Get_Master_Mini_Site_Id';
35: l_api_version CONSTANT NUMBER := 1.0;
36:
37: CURSOR c1 IS
38: SELECT msite_id, msite_root_section_id FROM ibe_msites_b
39: WHERE UPPER(master_msite_flag) = 'Y' and site_type = 'I';
40: BEGIN
41:
42: OPEN c1;

Line 67: From ibe_msites_b

63: )
64: IS
65: Cursor C_msite_valid(l_c_msite_id Number)
66: Is Select msite_root_section_id
67: From ibe_msites_b
68: Where msite_id = l_c_msite_id
69: And master_msite_flag = 'N' and site_type = 'I';
70:
71: Cursor C_msite_Id(p_access_name Varchar2)

Line 73: From ibe_msites_b

69: And master_msite_flag = 'N' and site_type = 'I';
70:
71: Cursor C_msite_Id(p_access_name Varchar2)
72: Is Select msite_id,msite_root_section_id
73: From ibe_msites_b
74: Where access_name = p_access_name
75: And master_msite_flag = 'N' and site_type = 'I';
76:
77: CURSOR c2(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER,

Line 235: (SELECT msite_root_section_id FROM ibe_msites_b

231: AND child_section_id NOT IN
232: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
233: WHERE mini_site_id = l_c_msite_id)
234: START WITH child_section_id =
235: (SELECT msite_root_section_id FROM ibe_msites_b
236: WHERE msite_id = l_c_msite_id)
237: AND mini_site_id = l_c_master_msite_id
238: CONNECT BY PRIOR child_section_id = parent_section_id
239: AND mini_site_id = l_c_master_msite_id

Line 244: From ibe_msites_b

240: AND PRIOR mini_site_id = l_c_master_msite_id;
241:
242: Cursor C_msite_Id(p_access_name Varchar2)
243: Is Select msite_id,msite_root_section_id
244: From ibe_msites_b
245: Where access_name = p_access_name
246: And master_msite_flag = 'N' and site_type = 'I';
247:
248: BEGIN

Line 348: From ibe_msites_b

344: l_msite_not_exists_excp EXCEPTION;
345:
346: Cursor C_msite_Id(p_access_name Varchar2)
347: Is Select msite_id,msite_root_section_id
348: From ibe_msites_b
349: Where access_name = p_access_name
350: And master_msite_flag = 'N' and site_type = 'I';
351: -- removed by YAXU on 08/06/02
352: -- And sysdate BETWEEN start_date_active

Line 361: From ibe_msites_b

357: -- root section id for a given minisite.+
358:
359: Cursor C_msite_valid(l_c_msite_id Number)
360: Is Select msite_root_section_id
361: From ibe_msites_b
362: Where msite_id = l_c_msite_id
363: And master_msite_flag = 'N' and site_type = 'I';
364: -- removed by YAXU on 08/06/02
365: -- And sysdate BETWEEN start_date_active

Line 415: FROM ibe_msites_b

411: attribute9,attribute10,attribute11,attribute12,
412: attribute13,attribute14,attribute15,
413: payment_threshold_enable_flag, --added by YAXU for payment threshold
414: start_date_active, end_date_active -- added by YAXU on 08/06/02
415: FROM ibe_msites_b
416: WHERE msite_id = l_msite_id
417: AND site_type = 'I';
418:
419: OPEN x_name_cur FOR SELECT a.language_code,

Line 484: || ' FROM ibe_msites_b '

480: || ' AND mini_site_id = :l_c_master_msite_id '
481: || ' START WITH child_section_id = '
482: || ' ( '
483: || ' SELECT msite_root_section_id '
484: || ' FROM ibe_msites_b '
485: || ' WHERE msite_id = :l_c_msite_id '
486: || ' ) '
487: || ' AND mini_site_id = :l_c_master_msite_id '
488: || ' ) '

Line 748: (SELECT msite_root_section_id FROM ibe_msites_b

744: AND child_section_id NOT IN
745: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
746: WHERE mini_site_id = l_c_msite_id)
747: START WITH child_section_id =
748: (SELECT msite_root_section_id FROM ibe_msites_b
749: WHERE msite_id = l_c_msite_id)
750: AND mini_site_id = l_c_master_msite_id
751: CONNECT BY PRIOR child_section_id = parent_section_id
752: AND mini_site_id = l_c_master_msite_id

Line 769: -- (SELECT msite_root_section_id FROM ibe_msites_b

765: -- AND child_section_id NOT IN
766: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
767: -- WHERE mini_site_id = l_c_msite_id)
768: -- START WITH child_section_id =
769: -- (SELECT msite_root_section_id FROM ibe_msites_b
770: -- WHERE msite_id = l_c_msite_id)
771: -- AND mini_site_id = l_c_master_msite_id
772: -- CONNECT BY PRIOR child_section_id = parent_section_id
773: -- AND PRIOR mini_site_id = l_c_master_msite_id

Line 800: -- (SELECT msite_root_section_id FROM ibe_msites_b

796: -- AND child_section_id NOT IN
797: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
798: -- WHERE mini_site_id = l_c_msite_id)
799: -- START WITH child_section_id =
800: -- (SELECT msite_root_section_id FROM ibe_msites_b
801: -- WHERE msite_id = l_c_msite_id)
802: -- AND mini_site_id = l_c_master_msite_id
803: -- CONNECT BY PRIOR child_section_id = parent_section_id
804: -- AND PRIOR mini_site_id = l_c_master_msite_id

Line 882: -- FROM ibe_msites_b

878: -- AND mini_site_id = l_c_master_msite_id
879: -- START WITH child_section_id =
880: -- (
881: -- SELECT msite_root_section_id
882: -- FROM ibe_msites_b
883: -- WHERE msite_id = l_c_msite_id
884: -- )
885: -- AND mini_site_id = l_c_master_msite_id
886: -- )

Line 915: IS SELECT msite_id FROM ibe_msites_b

911: -- ibe_dsp_section_items i0
912: -- WHERE i0.section_item_id = v1.section_item_id;
913:
914: CURSOR c3
915: IS SELECT msite_id FROM ibe_msites_b
916: -- removed by YAXU on 08/06/02
917: -- WHERE sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate)
918: --AND
919: WHERE master_msite_flag = 'N' and site_type = 'I';

Line 923: From ibe_msites_b

919: WHERE master_msite_flag = 'N' and site_type = 'I';
920:
921: Cursor C_msite_valid(l_c_msite_id Number)
922: Is Select msite_root_section_id
923: From ibe_msites_b
924: Where msite_id = l_c_msite_id
925: And master_msite_flag = 'N' and site_type = 'I';
926: -- removed by YAXU on 08/06/02
927: -- And sysdate BETWEEN start_date_active

Line 990: -- Basic information (from ibe_msites_b table)

986: -- End If;
987: -- END LOOP; -- end loop i
988: -- l_tmp_str := l_tmp_str || ') ';
989:
990: -- Basic information (from ibe_msites_b table)
991: -- OPEN x_minisite_cur FOR 'SELECT msite_id, default_language_code, '
992: -- || 'default_currency_code, default_org_id, walkin_allowed_flag, '
993: -- || 'msite_root_section_id, master_msite_flag, atp_check_flag, '
994: -- || 'default_date_format, profile_id, access_name, resp_access_flag, '

Line 999: -- || 'FROM ibe_msites_b MM WHERE '

995: -- || 'party_access_code, attribute1, attribute2, attribute3, attribute4, '
996: -- || 'attribute5, attribute6, attribute7, attribute8, attribute9, '
997: -- || 'attribute10, attribute11, attribute12, attribute13, attribute14, '
998: -- || 'attribute15 '
999: -- || 'FROM ibe_msites_b MM WHERE '
1000: -- || l_tmp_str
1001: -- || 'ORDER BY msite_id';
1002:
1003:

Line 1004: -- Basic information (from ibe_msites_b table)

1000: -- || l_tmp_str
1001: -- || 'ORDER BY msite_id';
1002:
1003:
1004: -- Basic information (from ibe_msites_b table)
1005: OPEN x_minisite_cur FOR SELECT msite_id, default_language_code,
1006: default_currency_code, default_org_id, walkin_allowed_flag,
1007: msite_root_section_id, master_msite_flag, atp_check_flag,
1008: default_date_format, profile_id, access_name, resp_access_flag,

Line 1015: FROM ibe_msites_b MM

1011: attribute10, attribute11, attribute12, attribute13, attribute14,
1012: attribute15,
1013: payment_threshold_enable_flag, --added by YAXU for payment threshold
1014: start_date_active, end_date_active -- added by YAXU on 08/06/02
1015: FROM ibe_msites_b MM
1016: WHERE MM.msite_id IN
1017: (SELECT t.COLUMN_VALUE
1018: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1019: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125)

Line 1023: OPEN x_name_cur FOR SELECT /+ ORDERED USE_NL (V MM TL L) INDEX (MM,IBE_MSITES_B_U1) /

1019: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125)
1020: ORDER BY msite_id ;
1021:
1022: -- Mini-site name and description for all languages
1023: OPEN x_name_cur FOR SELECT /*+ ORDERED USE_NL (V MM TL L) INDEX (MM,IBE_MSITES_B_U1) */
1024: MM.msite_id, L.language_code, TL.msite_name,TL.msite_description
1025: FROM(select distinct to_number(t.column_value) as msite_id
1026: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1027: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,

Line 1028: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L

1024: MM.msite_id, L.language_code, TL.msite_name,TL.msite_description
1025: FROM(select distinct to_number(t.column_value) as msite_id
1026: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1027: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1028: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L
1029: WHERE L.language_code = TL.language
1030: AND L.msite_id = MM.msite_id
1031: AND TL.msite_id = MM.msite_id
1032: AND MM.msite_id = v.msite_id

Line 1039: INDEX (MM,IBE_MSITES_B_U1) */

1035:
1036: -- Language assocation(from ibe_msite_languages table)
1037: OPEN x_lang_cur FOR SELECT /*+ ORDERED
1038: USE_NL (V MM L)
1039: INDEX (MM,IBE_MSITES_B_U1) */
1040: MM.msite_id, L.language_code
1041: FROM
1042: (select distinct to_number(t.column_value) as msite_id
1043: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

Line 1045: ibe_msites_b MM,

1041: FROM
1042: (select distinct to_number(t.column_value) as msite_id
1043: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1044: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1045: ibe_msites_b MM,
1046: ibe_msite_languages L
1047: WHERE MM.msite_id = L.msite_id
1048: AND MM.msite_id = v.msite_id
1049: AND MM.site_type = 'I'

Line 1054: OPEN x_currency_cur FOR SELECT /+ ORDERED USE_NL (V MM C) INDEX (MM,IBE_MSITES_B_U1) /

1050: AND L.enable_flag = 'Y'
1051: ORDER BY MM.msite_id;
1052:
1053: -- Currency assocation(from ibe_msite_currencies table)
1054: OPEN x_currency_cur FOR SELECT /*+ ORDERED USE_NL (V MM C) INDEX (MM,IBE_MSITES_B_U1) */
1055: MM.msite_id, C.currency_code,
1056: C.bizpartner_prc_listid,C.registered_prc_listid, C.walkin_prc_listid,
1057: C.orderable_limit,
1058: C.payment_threshold,C.partner_prc_listid

Line 1062: ibe_msites_b MM, ibe_msite_currencies C

1058: C.payment_threshold,C.partner_prc_listid
1059: FROM (select distinct to_number(t.column_value) as msite_id
1060: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1061: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1062: ibe_msites_b MM, ibe_msite_currencies C
1063: WHERE MM.msite_id = C.msite_id
1064: AND MM.msite_id = v.msite_id
1065: AND MM.site_type = 'I'
1066: ORDER BY MM.msite_id;

Line 1069: OPEN x_msite_resps_cur FOR SELECT /+ ORDERED USE_NL (V MM MRB MRTL) INDEX (MM,IBE_MSITES_B_U1)/

1065: AND MM.site_type = 'I'
1066: ORDER BY MM.msite_id;
1067:
1068: -- Mini-site and responsibility association (from ibe_msite_resps_b, _tl)
1069: OPEN x_msite_resps_cur FOR SELECT /*+ ORDERED USE_NL (V MM MRB MRTL) INDEX (MM,IBE_MSITES_B_U1)*/
1070: MM.msite_id, MRB.msite_resp_id, MRB.responsibility_id, MRB.application_id, MRTL.language,
1071: MRTL.display_name, MRB.start_date_active, MRB.end_date_active
1072: FROM (select distinct to_number(t.column_value) as msite_id
1073: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

Line 1075: ibe_msites_b MM, ibe_msite_resps_b MRB, ibe_msite_resps_tl MRTL

1071: MRTL.display_name, MRB.start_date_active, MRB.end_date_active
1072: FROM (select distinct to_number(t.column_value) as msite_id
1073: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1074: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1075: ibe_msites_b MM, ibe_msite_resps_b MRB, ibe_msite_resps_tl MRTL
1076: WHERE MM.msite_id = MRB.msite_id
1077: AND MRB.msite_resp_id = MRTL.msite_resp_id
1078: AND MM.msite_id = v.msite_id
1079: AND MM.site_type = 'I'

Line 1083: OPEN x_party_access_cur FOR SELECT /+ ORDERED USE_NL (V MM MP) INDEX (MM,IBE_MSITES_B_U1) /

1079: AND MM.site_type = 'I'
1080: ORDER BY MM.msite_id, MRB.msite_resp_id;
1081:
1082: -- Mini-site and party association (from ibe_msite_prty_accss table)
1083: OPEN x_party_access_cur FOR SELECT /*+ ORDERED USE_NL (V MM MP) INDEX (MM,IBE_MSITES_B_U1) */
1084: MM.msite_id, party_id
1085: FROM (select distinct to_number(t.column_value) as msite_id
1086: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1087: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,

Line 1088: ibe_msites_b MM, ibe_msite_prty_accss MP

1084: MM.msite_id, party_id
1085: FROM (select distinct to_number(t.column_value) as msite_id
1086: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1087: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1088: ibe_msites_b MM, ibe_msite_prty_accss MP
1089: WHERE MM.msite_id = MP.msite_id
1090: AND sysdate BETWEEN MP.start_date_Active AND NVL(MP.end_date_active,sysdate)
1091: AND MM.msite_id = v.msite_id
1092: AND MM.site_type = 'I'

Line 1097: OPEN x_pm_cc_sm_cur FOR SELECT /+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) /

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
1101: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,

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 1108: SELECT /+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) /

1104: AND MM.msite_id = v.msite_id
1105: AND MM.site_type = 'I'
1106: AND MI.msite_information_context = 'SHPMT_MTHD'
1107: UNION
1108: SELECT /*+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) */
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,

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 1123: SELECT /+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) /

1119: AND FLV.enabled_flag = 'Y' AND (FLV.TAG='Y' or FLV.TAG is null)
1120: AND FLV.language=userenv('lang')
1121:
1122: UNION --ssekar bug 5064210 query split to handle multiple sources of payment/credit card info.
1123: SELECT /*+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) */
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,

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)