APPS.BSC_MO_DOC_PKG dependencies on ALL_TAB_COLUMNS

Line 734: l_stmt := l_stmt ||' FROM ALL_TAB_COLUMNS A, BSC_DB_TABLES_COLS B ';

730: l_stmt := l_stmt ||' FROM USER_TAB_COLUMNS A, BSC_DB_TABLES_COLS B WHERE A.TABLE_NAME = :1';
731: --BSC Autogen
732: l_stmt := l_stmt ||' AND B.TABLE_NAME(+) = :2 AND A.COLUMN_NAME=upper(B.COLUMN_NAME(+)) ';
733: Else
734: l_stmt := l_stmt ||' FROM ALL_TAB_COLUMNS A, BSC_DB_TABLES_COLS B ';
735: If (BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV And (Tabla.Type = 0 Or isBaseTable))
736: Or (Not BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV) Then
737: l_bind_case := 2;
738: l_stmt := l_stmt ||' WHERE A.TABLE_NAME = :1 ';

Line 1265: FROM all_tab_columns

1261: cRow3 c3%ROWTYPE;
1262:
1263: CURSOR c4 (p1 IN VARCHAR2, p2 IN VARCHAR2) IS
1264: SELECT column_name
1265: FROM all_tab_columns
1266: WHERE table_name = p1
1267: AND owner = p2
1268: ORDER BY column_id;
1269: cRow4 c4%ROWTYPE;

Line 1742: FROM ALL_TAB_COLUMNS

1738: msg VARCHAR2(100);
1739: TableName VARCHAR2(100);
1740: CURSOR c1 (p1 VARCHAR2, p2 VARCHAR2) IS
1741: SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE
1742: FROM ALL_TAB_COLUMNS
1743: WHERE TABLE_NAME = p1
1744: AND UPPER(OWNER) = p2
1745: ORDER BY COLUMN_ID;
1746: cRow c1%ROWTYPE;

Line 1910: FROM ALL_TAB_COLUMNS WHERE OWNER = :1 AND ';

1906: bsc_mo_helper_pkg.writeTmp('Source is BSC');
1907: --BSC dimension
1908: -- Bug 3830308 : Added owner clause here itself new GSCC validation isnt smart enough
1909: l_stmt := 'SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE
1910: FROM ALL_TAB_COLUMNS WHERE OWNER = :1 AND ';
1911: If InputTableFlag Then
1912: l_bind_case := 2;
1913: l_stmt := l_stmt||' TABLE_NAME = :2';
1914: Else