DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on ALL_TAB_COLUMNS

Line 782: FROM ALL_TAB_COLUMNS A,

778: CP_USER_ID CREATED_BY,
779: SYSDATE CREATION_DATE,
780: CP_USER_ID LAST_UPDATED_BY,
781: SYSDATE LAST_UPDATE_DATE
782: FROM ALL_TAB_COLUMNS A,
783: ALL_TABLES B
784: WHERE A.TABLE_NAME = B.TABLE_NAME
785: AND A.OWNER = CP_ORACLE_USER
786: AND B.OWNER = CP_ORACLE_USER

Line 1750: FROM ALL_TAB_COLUMNS ATC

1746: CP_USER_ID CREATED_BY,
1747: SYSDATE CREATION_DATE,
1748: CP_USER_ID LAST_UPDATED_BY,
1749: SYSDATE LAST_UPDATE_DATE
1750: FROM ALL_TAB_COLUMNS ATC
1751: WHERE ATC.OWNER = CP_ORACLE_USER
1752: AND ATC.TABLE_NAME = CP_VIEW_NAME
1753: AND NOT EXISTS
1754: (SELECT 1

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

1760: VN_SEQUENCE_NUM NUMBER;
1761: BEGIN
1762: --
1763: -- Determine ORACLE_USERNAME - usually APPS - need to limit selections
1764: -- from the ALL_TAB_COLUMNS table using this user because there can be multiple entries.
1765: VV_ORACLE_USER := NULL;
1766: BEGIN
1767: SELECT ORACLE_USERNAME
1768: INTO VV_ORACLE_USER