|
ACS3 Data Model |
||||||||||||
|
Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|---|---|---|---|---|---|
PARTNER_ID | NUMBER(38) | N | NO | NO | NO | |
URL_ID | NUMBER(38) | N | NO | NO | NO | |
PROC_NAME | VARCHAR2(100.0) | N | YES | YES | YES | |
CALL_NUMBER | NUMBER(38) | N | YES | YES | YES | |
PROC_ID | NUMBER(38) | N | YES | YES | YES |
select u.partner_id, u.url_id, p.proc_name, p.call_number, p.proc_id from ad_partner_procs p, ad_partner_url u where proc_type='header' and p.url_id=u.url_id order by call_number