APPS.ETRM_PNAV dependencies on DBA_TABLES

Line 652: v_table_name dba_tables.table_name%type;

648:
649:
650: v_first boolean;
651: v_first2 boolean;
652: v_table_name dba_tables.table_name%type;
653:
654: begin
655:
656: v_first := TRUE;

Line 769: procedure ls_table(c_name dba_tables.table_name%type

765: end if;
766: end ls_table;
767:
768:
769: procedure ls_table(c_name dba_tables.table_name%type
770: , c_owner dba_tab_columns.owner%type) is
771:
772: CURSOR cur_table_dets(c_name in dba_tables.table_name%type
773: , c_owner in dba_objects.owner%type)

Line 772: CURSOR cur_table_dets(c_name in dba_tables.table_name%type

768:
769: procedure ls_table(c_name dba_tables.table_name%type
770: , c_owner dba_tab_columns.owner%type) is
771:
772: CURSOR cur_table_dets(c_name in dba_tables.table_name%type
773: , c_owner in dba_objects.owner%type)
774: -- List table details
775: IS select tab.table_name
776: , tab.tablespace_name

Line 781: from dba_tables tab

777: , tab.pct_free
778: , tab.pct_used
779: , tab.temporary
780: , tab.duration
781: from dba_tables tab
782: where table_name = c_name
783: and owner = c_owner
784: order by tab.table_name;
785: --

Line 787: CURSOR cur_comment(c_name in dba_tables.table_name%type

783: and owner = c_owner
784: order by tab.table_name;
785: --
786:
787: CURSOR cur_comment(c_name in dba_tables.table_name%type
788: , c_owner in dba_objects.owner%type)
789: is select comments
790: from dba_tab_comments
791: where owner = c_owner

Line 895: summary="dba_tables information">');

891:
892:
893: htp.p('

Storage Details