DBA Data[Home] [Help]

APPS.CZ_RUNTIME dependencies on CZ_UI_PAGES

Line 1051: CZ_UI_PAGES uipages,

1047: FROM dual
1048: ) AS TARGET_PAGE_REFERENCE_DEPTH,
1049: '0' AS BOUND_VIA_PARENT_FLAG
1050: FROM
1051: CZ_UI_PAGES uipages,
1052: (SELECT els.ui_def_id,els.page_id,els.element_id,level as PAGE_LEVEL FROM CZ_UI_PAGE_ELEMENTS els
1053: START WITH (els.page_id,els.ui_def_id,els.element_id) IN
1054: (SELECT /*+ CARDINALITY (UITPAGES 1) */ uitpages.page_id,uitpages.ui_def_id,uitpages.element_id FROM TABLE(CAST(l_ui_pages_tbl0 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) UITPAGES)
1055: CONNECT BY els.element_signature_id=6073 AND

Line 1080: CZ_UI_PAGES uipages,

1076: FROM dual
1077: ) AS TARGET_PAGE_REFERENCE_DEPTH,
1078: '1' AS BOUND_VIA_PARENT_FLAG
1079: FROM
1080: CZ_UI_PAGES uipages,
1081: (SELECT els.ui_def_id,els.page_id,els.element_id,level as PAGE_LEVEL FROM CZ_UI_PAGE_ELEMENTS els
1082: START WITH (els.page_id,els.ui_def_id,els.element_id) IN
1083: (SELECT /*+ CARDINALITY(UITPAGES1 1) */ uitpages1.page_id,uitpages1.ui_def_id,uitpages1.element_id FROM TABLE(CAST(l_ui_pages_tbl1 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) UITPAGES1)
1084: CONNECT BY els.element_signature_id=6073 AND

Line 1139: CZ_UI_PAGES uipages,

1135: FROM dual
1136: ) AS TARGET_PAGE_REFERENCE_DEPTH,
1137: '0' AS BOUND_VIA_PARENT_FLAG
1138: FROM
1139: CZ_UI_PAGES uipages,
1140: (SELECT els.ui_def_id,els.page_id,els.element_id,level as PAGE_LEVEL FROM CZ_UI_PAGE_ELEMENTS els
1141: START WITH (els.page_id,els.ui_def_id,els.element_id) IN
1142: (SELECT uitpages.page_id,uitpages.ui_def_id,uitpages.element_id FROM TABLE(CAST(l_ui_pages_tbl0 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) uitpages)
1143: CONNECT BY els.element_signature_id=6073 AND

Line 1168: CZ_UI_PAGES uipages,

1164: FROM dual
1165: ) AS TARGET_PAGE_REFERENCE_DEPTH,
1166: '1' AS BOUND_VIA_PARENT_FLAG
1167: FROM
1168: CZ_UI_PAGES uipages,
1169: (SELECT els.ui_def_id,els.page_id,els.element_id,level as PAGE_LEVEL FROM CZ_UI_PAGE_ELEMENTS els
1170: START WITH (els.page_id,els.ui_def_id,els.element_id) IN
1171: (SELECT uitpages1.page_id,uitpages1.ui_def_id,uitpages1.element_id FROM TABLE(CAST(l_ui_pages_tbl1 AS SYSTEM.CZ_UI_PAGE_ELEM_TBL)) uitpages1)
1172: CONNECT BY els.element_signature_id=6073 AND