[Home] [Help] [Dependency Information]
Object Name: | FV_AGENCY_ID_MAP |
---|---|
Object Type: | TABLE |
Owner: | FV |
Subobject Name: | |
Status: | VALID |
Table to store Agency ID mapping data for GTAS upgrade
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FV_AGENCY_ID_MAP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AID
ATA MAIN STAR_DEPT_REG SUB STAR_DEPT_XFER STAR_MAIN_ACCT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AID | VARCHAR2 | (4) | New Agency ID | |
SUB | VARCHAR2 | (3) | Sub | |
ATA | VARCHAR2 | (4) | New Allocation Transfer Agency ID | |
MAIN | VARCHAR2 | (4) | New Main Account Code | |
STAR_DEPT_REG | VARCHAR2 | (4) | Old Allocation Transfer Agency ID | |
STAR_DEPT_XFER | VARCHAR2 | (4) | Old Agency ID | |
STAR_MAIN_ACCT | VARCHAR2 | (4) | Old Main Account Code |
Cut, paste (and edit) the following text to query this object:
SELECT AID
, SUB
, ATA
, MAIN
, STAR_DEPT_REG
, STAR_DEPT_XFER
, STAR_MAIN_ACCT
FROM FV.FV_AGENCY_ID_MAP;
FV.FV_AGENCY_ID_MAP does not reference any database object
FV.FV_AGENCY_ID_MAP is referenced by following:
|
|
|