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 36: SELECT msite_id, msite_root_section_id FROM ibe_msites_b

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

Line 83: From ibe_msites_b

79: l_msite_not_exists_excp EXCEPTION;
80:
81: Cursor C_msite_Id(p_access_name Varchar2)
82: Is Select msite_id,msite_root_section_id
83: From ibe_msites_b
84: Where access_name = p_access_name
85: And master_msite_flag = 'N' and site_type = 'I';
86: -- removed by YAXU on 08/06/02
87: -- And sysdate BETWEEN start_date_active

Line 96: From ibe_msites_b

92: -- root section id for a given minisite.+
93:
94: Cursor C_msite_valid(l_c_msite_id Number)
95: Is Select msite_root_section_id
96: From ibe_msites_b
97: Where msite_id = l_c_msite_id
98: And master_msite_flag = 'N' and site_type = 'I';
99: -- removed by YAXU on 08/06/02
100: -- And sysdate BETWEEN start_date_active

Line 150: FROM ibe_msites_b

146: attribute9,attribute10,attribute11,attribute12,
147: attribute13,attribute14,attribute15,
148: payment_threshold_enable_flag, --added by YAXU for payment threshold
149: start_date_active, end_date_active -- added by YAXU on 08/06/02
150: FROM ibe_msites_b
151: WHERE msite_id = l_msite_id
152: AND site_type = 'I';
153:
154: OPEN x_name_cur FOR SELECT a.language_code,

Line 219: || ' FROM ibe_msites_b '

215: || ' AND mini_site_id = :l_c_master_msite_id '
216: || ' START WITH child_section_id = '
217: || ' ( '
218: || ' SELECT msite_root_section_id '
219: || ' FROM ibe_msites_b '
220: || ' WHERE msite_id = :l_c_msite_id '
221: || ' ) '
222: || ' AND mini_site_id = :l_c_master_msite_id '
223: || ' ) '

Line 483: (SELECT msite_root_section_id FROM ibe_msites_b

479: AND child_section_id NOT IN
480: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
481: WHERE mini_site_id = l_c_msite_id)
482: START WITH child_section_id =
483: (SELECT msite_root_section_id FROM ibe_msites_b
484: WHERE msite_id = l_c_msite_id)
485: AND mini_site_id = l_c_master_msite_id
486: CONNECT BY PRIOR child_section_id = parent_section_id
487: AND mini_site_id = l_c_master_msite_id

Line 504: -- (SELECT msite_root_section_id FROM ibe_msites_b

500: -- AND child_section_id NOT IN
501: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
502: -- WHERE mini_site_id = l_c_msite_id)
503: -- START WITH child_section_id =
504: -- (SELECT msite_root_section_id FROM ibe_msites_b
505: -- WHERE msite_id = l_c_msite_id)
506: -- AND mini_site_id = l_c_master_msite_id
507: -- CONNECT BY PRIOR child_section_id = parent_section_id
508: -- AND PRIOR mini_site_id = l_c_master_msite_id

Line 535: -- (SELECT msite_root_section_id FROM ibe_msites_b

531: -- AND child_section_id NOT IN
532: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
533: -- WHERE mini_site_id = l_c_msite_id)
534: -- START WITH child_section_id =
535: -- (SELECT msite_root_section_id FROM ibe_msites_b
536: -- WHERE msite_id = l_c_msite_id)
537: -- AND mini_site_id = l_c_master_msite_id
538: -- CONNECT BY PRIOR child_section_id = parent_section_id
539: -- AND PRIOR mini_site_id = l_c_master_msite_id

Line 617: -- FROM ibe_msites_b

613: -- AND mini_site_id = l_c_master_msite_id
614: -- START WITH child_section_id =
615: -- (
616: -- SELECT msite_root_section_id
617: -- FROM ibe_msites_b
618: -- WHERE msite_id = l_c_msite_id
619: -- )
620: -- AND mini_site_id = l_c_master_msite_id
621: -- )

Line 650: IS SELECT msite_id FROM ibe_msites_b

646: -- ibe_dsp_section_items i0
647: -- WHERE i0.section_item_id = v1.section_item_id;
648:
649: CURSOR c3
650: IS SELECT msite_id FROM ibe_msites_b
651: -- removed by YAXU on 08/06/02
652: -- WHERE sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate)
653: --AND
654: WHERE master_msite_flag = 'N' and site_type = 'I';

Line 658: From ibe_msites_b

654: WHERE master_msite_flag = 'N' and site_type = 'I';
655:
656: Cursor C_msite_valid(l_c_msite_id Number)
657: Is Select msite_root_section_id
658: From ibe_msites_b
659: Where msite_id = l_c_msite_id
660: And master_msite_flag = 'N' and site_type = 'I';
661: -- removed by YAXU on 08/06/02
662: -- And sysdate BETWEEN start_date_active

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

721: -- End If;
722: -- END LOOP; -- end loop i
723: -- l_tmp_str := l_tmp_str || ') ';
724:
725: -- Basic information (from ibe_msites_b table)
726: -- OPEN x_minisite_cur FOR 'SELECT msite_id, default_language_code, '
727: -- || 'default_currency_code, default_org_id, walkin_allowed_flag, '
728: -- || 'msite_root_section_id, master_msite_flag, atp_check_flag, '
729: -- || 'default_date_format, profile_id, access_name, resp_access_flag, '

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

730: -- || 'party_access_code, attribute1, attribute2, attribute3, attribute4, '
731: -- || 'attribute5, attribute6, attribute7, attribute8, attribute9, '
732: -- || 'attribute10, attribute11, attribute12, attribute13, attribute14, '
733: -- || 'attribute15 '
734: -- || 'FROM ibe_msites_b MM WHERE '
735: -- || l_tmp_str
736: -- || 'ORDER BY msite_id';
737:
738:

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

735: -- || l_tmp_str
736: -- || 'ORDER BY msite_id';
737:
738:
739: -- Basic information (from ibe_msites_b table)
740: OPEN x_minisite_cur FOR SELECT msite_id, default_language_code,
741: default_currency_code, default_org_id, walkin_allowed_flag,
742: msite_root_section_id, master_msite_flag, atp_check_flag,
743: default_date_format, profile_id, access_name, resp_access_flag,

Line 750: FROM ibe_msites_b MM

746: attribute10, attribute11, attribute12, attribute13, attribute14,
747: attribute15,
748: payment_threshold_enable_flag, --added by YAXU for payment threshold
749: start_date_active, end_date_active -- added by YAXU on 08/06/02
750: FROM ibe_msites_b MM
751: WHERE MM.msite_id IN
752: (SELECT t.COLUMN_VALUE
753: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
754: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125)

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

754: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125)
755: ORDER BY msite_id ;
756:
757: -- Mini-site name and description for all languages
758: OPEN x_name_cur FOR SELECT /*+ ORDERED USE_NL (V MM TL L) INDEX (MM,IBE_MSITES_B_U1) */
759: MM.msite_id, L.language_code, TL.msite_name,TL.msite_description
760: FROM(select distinct to_number(t.column_value) as msite_id
761: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
762: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,

Line 763: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L

759: MM.msite_id, L.language_code, TL.msite_name,TL.msite_description
760: FROM(select distinct to_number(t.column_value) as msite_id
761: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
762: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
763: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L
764: WHERE L.language_code = TL.language
765: AND L.msite_id = MM.msite_id
766: AND TL.msite_id = MM.msite_id
767: AND MM.msite_id = v.msite_id

Line 774: INDEX (MM,IBE_MSITES_B_U1) */

770:
771: -- Language assocation(from ibe_msite_languages table)
772: OPEN x_lang_cur FOR SELECT /*+ ORDERED
773: USE_NL (V MM L)
774: INDEX (MM,IBE_MSITES_B_U1) */
775: MM.msite_id, L.language_code
776: FROM
777: (select distinct to_number(t.column_value) as msite_id
778: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

Line 780: ibe_msites_b MM,

776: FROM
777: (select distinct to_number(t.column_value) as msite_id
778: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
779: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
780: ibe_msites_b MM,
781: ibe_msite_languages L
782: WHERE MM.msite_id = L.msite_id
783: AND MM.msite_id = v.msite_id
784: AND MM.site_type = 'I'

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

785: AND L.enable_flag = 'Y'
786: ORDER BY MM.msite_id;
787:
788: -- Currency assocation(from ibe_msite_currencies table)
789: OPEN x_currency_cur FOR SELECT /*+ ORDERED USE_NL (V MM C) INDEX (MM,IBE_MSITES_B_U1) */
790: MM.msite_id, C.currency_code,
791: C.bizpartner_prc_listid,C.registered_prc_listid, C.walkin_prc_listid,
792: C.orderable_limit,
793: C.payment_threshold,C.partner_prc_listid

Line 797: ibe_msites_b MM, ibe_msite_currencies C

793: C.payment_threshold,C.partner_prc_listid
794: FROM (select distinct to_number(t.column_value) as msite_id
795: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
796: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
797: ibe_msites_b MM, ibe_msite_currencies C
798: WHERE MM.msite_id = C.msite_id
799: AND MM.msite_id = v.msite_id
800: AND MM.site_type = 'I'
801: ORDER BY MM.msite_id;

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

800: AND MM.site_type = 'I'
801: ORDER BY MM.msite_id;
802:
803: -- Mini-site and responsibility association (from ibe_msite_resps_b, _tl)
804: OPEN x_msite_resps_cur FOR SELECT /*+ ORDERED USE_NL (V MM MRB MRTL) INDEX (MM,IBE_MSITES_B_U1)*/
805: MM.msite_id, MRB.msite_resp_id, MRB.responsibility_id, MRB.application_id, MRTL.language,
806: MRTL.display_name, MRB.start_date_active, MRB.end_date_active
807: FROM (select distinct to_number(t.column_value) as msite_id
808: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

Line 810: ibe_msites_b MM, ibe_msite_resps_b MRB, ibe_msite_resps_tl MRTL

806: MRTL.display_name, MRB.start_date_active, MRB.end_date_active
807: FROM (select distinct to_number(t.column_value) as msite_id
808: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
809: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
810: ibe_msites_b MM, ibe_msite_resps_b MRB, ibe_msite_resps_tl MRTL
811: WHERE MM.msite_id = MRB.msite_id
812: AND MRB.msite_resp_id = MRTL.msite_resp_id
813: AND MM.msite_id = v.msite_id
814: AND MM.site_type = 'I'

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

814: AND MM.site_type = 'I'
815: ORDER BY MM.msite_id, MRB.msite_resp_id;
816:
817: -- Mini-site and party association (from ibe_msite_prty_accss table)
818: OPEN x_party_access_cur FOR SELECT /*+ ORDERED USE_NL (V MM MP) INDEX (MM,IBE_MSITES_B_U1) */
819: MM.msite_id, party_id
820: FROM (select distinct to_number(t.column_value) as msite_id
821: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
822: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,

Line 823: ibe_msites_b MM, ibe_msite_prty_accss MP

819: MM.msite_id, party_id
820: FROM (select distinct to_number(t.column_value) as msite_id
821: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
822: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
823: ibe_msites_b MM, ibe_msite_prty_accss MP
824: WHERE MM.msite_id = MP.msite_id
825: AND sysdate BETWEEN MP.start_date_Active AND NVL(MP.end_date_active,sysdate)
826: AND MM.msite_id = v.msite_id
827: AND MM.site_type = 'I'

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

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

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

839: AND MM.msite_id = v.msite_id
840: AND MM.site_type = 'I'
841: AND MI.msite_information_context = 'SHPMT_MTHD'
842: UNION
843: SELECT /*+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) */
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,

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

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

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)