ALTER SESSION SET CURRENT_SCHEMA = "WAREHOUSE"
SELECT count(*) FROM olap_delivery_data3 WHERE olap_delivery_data3.seq_number='138376'  =>Count=1
select * from ( select a.*, rownum as rnum from ( SELECT olap_delivery_data3.* FROM olap_delivery_data3 WHERE olap_delivery_data3.seq_number='138376'    ) a where rownum <= 1 ) where rnum >= 1=>Count=1
ALTER SESSION SET CURRENT_SCHEMA = "WAREHOUSE"
ALTER SESSION SET CURRENT_SCHEMA = "WAREHOUSE"
SELECT count(*) FROM olap_delivery_notes3 LEFT JOIN olap_delivery_data3 ON (olap_delivery_data3.seq_number=olap_delivery_notes3.delivery_data_seq)   =>Count=2076
select * from ( select a.*, rownum as rnum from ( SELECT olap_delivery_notes3.*, olap_delivery_data3.seq_number FROM olap_delivery_notes3 LEFT JOIN olap_delivery_data3 ON (olap_delivery_data3.seq_number=olap_delivery_notes3.delivery_data_seq)     ) a where rownum <= 25 ) where rnum >= 1=>Count=2076
ALTER SESSION SET CURRENT_SCHEMA = "MENU"
SELECT role_id,global_access FROM mnu_role WHERE role_id='GLOBAL'   ORDER BY role_id  =>Count=1
ALTER SESSION SET CURRENT_SCHEMA = "MENU"
SELECT x.task_id, x.script_id, x.pattern_id, mnu_nav_button.button_text, mnu_nav_button.context_preselect FROM mnu_nav_button LEFT JOIN mnu_task ON (mnu_task.task_id = mnu_nav_button.task_id_snr) LEFT JOIN mnu_task x ON (x.task_id = mnu_nav_button.task_id_jnr)  WHERE mnu_task.task_id='mops_olap_delivery_notes3(list2)' AND (x.is_disabled='N')   ORDER BY mnu_nav_button.sort_seq  =>Count=6

select * from ( select a.*, rownum as rnum from ( SELECT olap_delivery_notes3.*, olap_delivery_data3.seq_number FROM olap_delivery_notes3 LEFT JOIN olap_delivery_data3 ON (olap_delivery_data3.seq_number=olap_delivery_notes3.delivery_data_seq)     ) a where rownum <= 25 ) where rnum >= 1=>Count=2076

where olap_delivery_data3.seq_number=(the seq_number specified from the selected row in the list1 form of the parent table)

where child_table.seq_number=(parent row.seq_number)

SELECT count(*) FROM olap_delivery_data3 WHERE olap_delivery_data3.seq_number='138376'  =>Count=1

select * from ( select a.*, rownum as rnum from ( SELECT olap_delivery_data3.* FROM olap_delivery_data3 WHERE olap_delivery_data3.seq_number='138376'    ) a where rownum <= 1 ) where rnum >= 1=>Count=1

SELECT count(*) FROM olap_delivery_notes3 LEFT JOIN olap_delivery_data3 ON (olap_delivery_data3.seq_number=olap_delivery_notes3.delivery_data_seq)   =>Count=2076

$pkeynames = $dbouter->getPkeyNamesAdjusted();
$inner_where = array2where($outer_data, $pkeynames, $dbouter);

Name                       Null?    Type
 ------------------------- -------- ----------------------------
 TASK_ID                   NOT NULL VARCHAR2(80 CHAR)
 FIELD_ID                  NOT NULL VARCHAR2(40 CHAR)
 CREATED_DATE              NOT NULL TIMESTAMP(6)
 CREATED_USER              NOT NULL VARCHAR2(16 CHAR)
 FIELD_DESC                         VARCHAR2(255 CHAR)
 REVISED_DATE                       TIMESTAMP(6)
 REVISED_USER                       VARCHAR2(16 CHAR)

INSERT INTO mnu_task_field VALUES('mnu_control(upd3)', 'DEFAULT_LANGUAGE', NULL, '2006-04-10 09:36:18', 'AJM', '2007-09-10 10:44:37', 'AJM')
                                                                                 *
ERROR at line 1:
ORA-12899: value too large for column "MENU"."MNU_TASK_FIELD"."CREATED_USER"
(actual: 19, maximum: 16)

if ($item == 'table_id') {
            // get data from the database, ignoring any tables which have no entries on DICT_COLUMN
            $this->sql_select     = 'dict_table.table_id, table_desc, count(dict_column.table_id) as column_count';
            $this->sql_orderby    = 'dict_table.table_id';
            $this->sql_ordery_seq = 'asc';
            $this->sql_from       = 'dict_table '
                                  . 'LEFT JOIN dict_column ON (dict_table.database_id=dict_column.database_id AND dict_table.table_id=dict_column.table_id) ';
            $this->sql_having     = 'column_count > 0';
            $this->sql_groupby    = 'dict_table.table_id, table_desc,AJW_RAD_GET_REL_TABLE_COUNT(DICT_TABLE.DATABASE_ID, DICT_TABLE.TABLE_ID) ';
            $data = $this->getData($where);

            // convert each row into 'id=id' in the output array
            foreach ($data as $row => $rowdata) {
                $rowvalues = array_values($rowdata);
                $array[$rowvalues[0]] = $rowvalues[0];
            } // foreach
            return $array;
        } // if

CREATE OR REPLACE FUNCTION AJW_RAD_GET_REL_TABLE_COUNT(IN_DB VARCHAR2, IN_TAB VARCHAR2) RETURN NUMBER
IS

V_RETURN NUMBER;

BEGIN

BEGIN

SELECT COUNT(*)
INTO V_RETURN
FROM DICT_RELATIONSHIP
WHERE
	DATABASE_ID_SNR	=	IN_DB AND
	TABLE_ID_SNR	=	IN_TAB;

EXCEPTION
WHEN OTHERS
THEN
	RETURN 0;

END;

RETURN V_RETURN;

END;
/

count(dict_column.table_id) as column_count

(SELECT COUNT(table_id) FROM dict_column WHERE dict_column.database_id=dict_table.database_id AND dict_column.table_id=dict_table.table_id GROUP BY dict_table.table_id) AS column_count

require_once 'std.table.class.inc';
class olap_delivery_notes3 extends Default_Table
{
    // ****************************************************************************
    function olap_delivery_notes3 ()
    {
        // save directory name of current script
        $this->dirname   = dirname(__file__);

        $this->dbms_engine = $GLOBALS['dbms'];
        $this->dbname      = 'warehouse';
        $this->tablename   = 'olap_delivery_notes3';

        // call this method to get original field specifications
        // (note that they may be modified at runtime)
        $this->fieldspec = $this->getFieldSpec_original();

    } // olap_delivery_notes3

    function _cm_pre_getData ($where, $where_array, $fieldarray=null){
	
        $where = str_replace('line_no=', 'order_line_no=', $where);

	return $where;
    }




// ****************************************************************************
} // end class
// ****************************************************************************