[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OZF_QUOTA_HEADER |
|---|---|
| Object Type: | TYPE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Type Code: | OBJECT |
|---|---|
| Predefined: | NO |
| Incomplete: | NO |
| Name | Datatype | Length | Prcn |
|---|---|---|---|
| FUND_ID | NUMBER |
|
|
| LAST_UPDATE_DATE | DATE |
|
|
| LAST_UPDATED_BY | NUMBER |
|
15 |
| CREATION_DATE | DATE |
|
|
| CREATED_BY | NUMBER |
|
15 |
| LAST_UPDATE_LOGIN | NUMBER |
|
15 |
| OBJECT_VERSION_NUMBER | NUMBER |
|
|
| CREATED_FROM | VARCHAR2 | (30) | |
| REQUEST_ID | NUMBER |
|
15 |
| PROGRAM_APPLICATION_ID | NUMBER |
|
15 |
| PROGRAM_ID | NUMBER |
|
15 |
| PROGRAM_UPDATE_DATE | DATE |
|
|
| FUND_NUMBER | VARCHAR2 | (30) | |
| PARENT_FUND_ID | NUMBER |
|
|
| CATEGORY_ID | NUMBER |
|
|
| FUND_TYPE | VARCHAR2 | (30) | |
| FUND_USAGE | VARCHAR2 | (30) | |
| STATUS_CODE | VARCHAR2 | (30) | |
| STATUS_DATE | DATE |
|
|
| USER_STATUS_ID | NUMBER |
|
|
| ACCRUED_LIABLE_ACCOUNT | NUMBER |
|
15 |
| DED_ADJUSTMENT_ACCOUNT | NUMBER |
|
15 |
| LIABILITY_FLAG | VARCHAR2 | (1) | |
| SET_OF_BOOKS_ID | NUMBER |
|
|
| START_PERIOD_ID | NUMBER |
|
|
| END_PERIOD_ID | NUMBER |
|
|
| START_DATE_ACTIVE | DATE |
|
|
| END_DATE_ACTIVE | DATE |
|
|
| BUDGET_AMOUNT_TC | NUMBER |
|
|
| BUDGET_AMOUNT_FC | NUMBER |
|
|
| AVAILABLE_AMOUNT | NUMBER |
|
|
| DISTRIBUTED_AMOUNT | NUMBER |
|
|
| CURRENCY_CODE_TC | VARCHAR2 | (15) | |
| CURRENCY_CODE_FC | VARCHAR2 | (15) | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | |
| EXCHANGE_RATE_DATE | DATE |
|
|
| EXCHANGE_RATE | NUMBER |
|
|
| DEPARTMENT_ID | NUMBER |
|
|
| COSTCENTRE_ID | NUMBER |
|
|
| OWNER | NUMBER |
|
|
| ACCRUAL_METHOD | VARCHAR2 | (30) | |
| ACCRUAL_OPERAND | VARCHAR2 | (30) | |
| ACCRUAL_RATE | NUMBER |
|
|
| ACCRUAL_BASIS | VARCHAR2 | (30) | |
| HIERARCHY | VARCHAR2 | (30) | |
| HIERARCHY_ID | NUMBER |
|
|
| HIERARCHY_LEVEL | VARCHAR2 | (30) | |
| PARENT_NODE_ID | NUMBER |
|
|
| NODE_ID | NUMBER |
|
|
| BUDGET_FLAG | VARCHAR2 | (1) | |
| EARNED_FLAG | VARCHAR2 | (1) | |
| APPLY_ACCRUAL_ON | VARCHAR2 | (30) | |
| ACCRUAL_PHASE | VARCHAR2 | (30) | |
| ACCRUAL_CAP | NUMBER |
|
|
| ACCRUAL_UOM | VARCHAR2 | (30) | |
| ORIGINAL_BUDGET | NUMBER |
|
|
| TRANSFERED_IN_AMT | NUMBER |
|
|
| TRANSFERED_OUT_AMT | NUMBER |
|
|
| HOLDBACK_AMT | NUMBER |
|
|
| PLANNED_AMT | NUMBER |
|
|
| COMMITTED_AMT | NUMBER |
|
|
| EARNED_AMT | NUMBER |
|
|
| PAID_AMT | NUMBER |
|
|
| PLAN_TYPE | VARCHAR2 | (30) | |
| PLAN_ID | NUMBER |
|
|
| LIABLE_ACCNT_SEGMENTS | VARCHAR2 | (155) | |
| ADJUSTMENT_ACCNT_SEGMENTS | VARCHAR2 | (155) | |
| COUNTRY_ID | NUMBER |
|
|
| TASK_ID | NUMBER |
|
|
| CUSTOM_SETUP_ID | NUMBER |
|
|
| THRESHOLD_ID | NUMBER |
|
|
| FUND_CALENDAR | VARCHAR2 | (30) | |
| START_PERIOD_NAME | VARCHAR2 | (30) | |
| END_PERIOD_NAME | VARCHAR2 | (30) | |
| ACCRUE_TO_LEVEL_ID | NUMBER |
|
|
| ACCRUAL_QUANTITY | NUMBER |
|
|
| ACCRUAL_DISCOUNT_LEVEL | VARCHAR2 | (30) | |
| BUSINESS_UNIT_ID | NUMBER |
|
|
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | |
| ATTRIBUTE1 | VARCHAR2 | (150) | |
| ATTRIBUTE2 | VARCHAR2 | (150) | |
| ATTRIBUTE3 | VARCHAR2 | (150) | |
| ATTRIBUTE4 | VARCHAR2 | (150) | |
| ATTRIBUTE5 | VARCHAR2 | (150) | |
| ATTRIBUTE6 | VARCHAR2 | (150) | |
| ATTRIBUTE7 | VARCHAR2 | (150) | |
| ATTRIBUTE8 | VARCHAR2 | (150) | |
| ATTRIBUTE9 | VARCHAR2 | (150) | |
| ATTRIBUTE10 | VARCHAR2 | (150) | |
| ATTRIBUTE11 | VARCHAR2 | (150) | |
| ATTRIBUTE12 | VARCHAR2 | (150) | |
| ATTRIBUTE13 | VARCHAR2 | (150) | |
| ATTRIBUTE14 | VARCHAR2 | (150) | |
| ATTRIBUTE15 | VARCHAR2 | (150) | |
| ORG_ID | NUMBER |
|
32 |
| RECAL_COMMITTED | NUMBER |
|
|
| ROLLUP_ORIGINAL_BUDGET | NUMBER |
|
|
| ROLLUP_TRANSFERED_IN_AMT | NUMBER |
|
|
| ROLLUP_TRANSFERED_OUT_AMT | NUMBER |
|
|
| ROLLUP_HOLDBACK_AMT | NUMBER |
|
|
| ROLLUP_PLANNED_AMT | NUMBER |
|
|
| ROLLUP_COMMITTED_AMT | NUMBER |
|
|
| ROLLUP_RECAL_COMMITTED | NUMBER |
|
|
| ROLLUP_EARNED_AMT | NUMBER |
|
|
| ROLLUP_PAID_AMT | NUMBER |
|
|
| FUND_NAME | VARCHAR2 | (240) | |
| DESCRIPTION | VARCHAR2 | (4000) | |
| RETROACTIVE_FLAG | VARCHAR2 | (1) | |
| QUALIFIER_ID | NUMBER |
|
|
| PREV_FUND_ID | NUMBER |
|
|
| TRANSFERED_FLAG | VARCHAR2 | (1) | |
| UTILIZED_AMT | NUMBER |
|
|
| ROLLUP_UTILIZED_AMT | NUMBER |
|
|
| PRODUCT_SPREAD_TIME_ID | NUMBER |
|
|
| TERRITORY_ID | NUMBER |
|
|
| TERRITORY_NAME | VARCHAR2 | (4000) | |
| PRODUCT_SPREAD |
 OZF_TIME_PRODUCT_TYPE
|
|
APPS
OZF_TIME_PRODUCT_TYPE
SYS
STANDARD
- show dependent code
APPS
OZF_QUOTA_CLOB_V
|
|
|
|