APPS.BSC_MO_DOC_PKG dependencies on BSC_DB_TABLES_COLS

Line 730: l_stmt := l_stmt ||' FROM USER_TAB_COLUMNS A, BSC_DB_TABLES_COLS B WHERE A.TABLE_NAME = :1';

726: --Columns
727: l_stmt := 'SELECT DISTINCT A.COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, B.SOURCE, A.COLUMN_ID ';
728: If BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV And Tabla.dbObjectType = 'VIEW' Then
729: l_bind_case := 1;
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 ';

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 1251: FROM BSC_DB_TABLES_COLS

1247: cv Curtyp;
1248:
1249: CURSOR c2(p1 VARCHAR2) IS
1250: SELECT COLUMN_TYPE, COLUMN_NAME, SOURCE
1251: FROM BSC_DB_TABLES_COLS
1252: WHERE TABLE_NAME = p1;
1253: cRow2 c2%ROWTYPE;
1254:
1255: CURSOR c3(p1 VARCHAR2, p2 IN NUMBER) IS