APPS.BNE_CONTENT_UTILS dependencies on ALL_TAB_COLUMNS

Line 12: -- from ALL_TAB_COLUMNS instead of FND_VIEWS and --

8: -- MODIFICATION HISTORY --
9: -- Date Username Description --
10: -- 05-JUN-2002 KPEET Created --
11: -- 16-JUL-2002 KPEET Changed CREATE_CONTENT_COLS_FROM_VIEW to select --
12: -- from ALL_TAB_COLUMNS instead of FND_VIEWS and --
13: -- FND_VIEW_COLUMNS as custom views are not created --
14: -- in the FND tables. --
15: -- 22-JUL-2002 KPEET Removed reference to REPORTING_INTERFACE_ID in --
16: -- from insert into BNE_TEXT_IMPORT_DETAILS in --

Line 605: -- from the ALL_TAB_COLUMNS table using this user because there can be multiple entries.

601: WHEN NO_DATA_FOUND THEN NULL;
602: END;
603:
604: -- Determine ORACLE_USERNAME - usually APPS - need to limit selections
605: -- from the ALL_TAB_COLUMNS table using this user because there can be multiple entries.
606:
607: VV_ORACLE_USER := NULL;
608: BEGIN
609: SELECT ORACLE_USERNAME

Line 635: FROM ALL_TAB_COLUMNS ATC

631: P_USER_ID CREATED_BY,
632: SYSDATE CREATION_DATE,
633: P_USER_ID LAST_UPDATED_BY,
634: SYSDATE LAST_UPDATE_DATE
635: FROM ALL_TAB_COLUMNS ATC
636: WHERE ATC.OWNER = VV_ORACLE_USER
637: AND ATC.TABLE_NAME = P_VIEW_NAME;
638:
639:

Line 655: FROM ALL_TAB_COLUMNS ATC

651: P_USER_ID CREATED_BY,
652: SYSDATE CREATION_DATE,
653: P_USER_ID LAST_UPDATED_BY,
654: SYSDATE LAST_UPDATE_DATE
655: FROM ALL_TAB_COLUMNS ATC
656: WHERE ATC.OWNER = VV_ORACLE_USER
657: AND ATC.TABLE_NAME = P_VIEW_NAME;
658:
659: END IF;