|
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='footer' and p.url_id=u.url_id order by call_number