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.EDW_BSC_BRIDGE dependencies on ALL_TAB_COLUMNS

Line 150: p_tbl_name ALL_TAB_COLUMNS.TABLE_NAME%TYPE ,

146: /*
147: CHANGES FOR BUG 3431744 BY AMITGUPT
148: */
149: CURSOR c_att_validity (
150: p_tbl_name ALL_TAB_COLUMNS.TABLE_NAME%TYPE ,
151: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE) IS
152: SELECT
153: COUNT(TAB.COLUMN_NAME)
154: FROM

Line 151: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE) IS

147: CHANGES FOR BUG 3431744 BY AMITGUPT
148: */
149: CURSOR c_att_validity (
150: p_tbl_name ALL_TAB_COLUMNS.TABLE_NAME%TYPE ,
151: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE) IS
152: SELECT
153: COUNT(TAB.COLUMN_NAME)
154: FROM
155: ALL_TAB_COLUMNS TAB, USER_SYNONYMS SYN

Line 155: ALL_TAB_COLUMNS TAB, USER_SYNONYMS SYN

151: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE) IS
152: SELECT
153: COUNT(TAB.COLUMN_NAME)
154: FROM
155: ALL_TAB_COLUMNS TAB, USER_SYNONYMS SYN
156: WHERE
157: TAB.TABLE_NAME = UPPER(p_tbl_name) AND
158: SYN.TABLE_NAME = TAB.TABLE_NAME AND
159: SYN.TABLE_OWNER = TAB.OWNER AND

Line 192: p_tbl_name ALL_TAB_COLUMNS.TABLE_NAME%TYPE ,

188: p_fact_name IN EDW_FACTS_MD_V.FACT_NAME%TYPE
189: ) RETURN EDW_FACTS_MD_V.FACT_ID%TYPE;
190:
191: FUNCTION CHECK_VALIDILITY(
192: p_tbl_name ALL_TAB_COLUMNS.TABLE_NAME%TYPE ,
193: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE)
194: RETURN BOOLEAN;
195:
196: FUNCTION CHECK_FACT_VALIDILITY(

Line 193: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE)

189: ) RETURN EDW_FACTS_MD_V.FACT_ID%TYPE;
190:
191: FUNCTION CHECK_VALIDILITY(
192: p_tbl_name ALL_TAB_COLUMNS.TABLE_NAME%TYPE ,
193: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE)
194: RETURN BOOLEAN;
195:
196: FUNCTION CHECK_FACT_VALIDILITY(
197: p_fact_name IN EDW_FACT_ATTRIBUTES_MD_V.FACT_NAME%TYPE

Line 805: p_tbl_name ALL_TAB_COLUMNS.TABLE_NAME%TYPE ,

801: END GET_SQL_STMT;
802:
803:
804: FUNCTION CHECK_VALIDILITY(
805: p_tbl_name ALL_TAB_COLUMNS.TABLE_NAME%TYPE ,
806: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE)
807: RETURN BOOLEAN IS
808: l_count NUMBER;
809: BEGIN

Line 806: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE)

802:
803:
804: FUNCTION CHECK_VALIDILITY(
805: p_tbl_name ALL_TAB_COLUMNS.TABLE_NAME%TYPE ,
806: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE)
807: RETURN BOOLEAN IS
808: l_count NUMBER;
809: BEGIN
810: OPEN c_att_validity( p_tbl_name , p_col_name);