[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_XLA_EXT_LINES_B_GT |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_XLA_EXT_LINES_B_GT
|
| Subobject Name: | |
| Status: | VALID |
FA.FA_XLA_EXT_LINES_B_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_XLA_EXT_LINES_B_GT_U1 | NORMAL | UNIQUE |
|
 EVENT_ID
LINE_NUMBER
LEDGER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EVENT_ID | NUMBER | (38) | ||
| LINE_NUMBER | NUMBER | (38) | ||
| BOOK_TYPE_CODE | VARCHAR2 | (15) | ||
| ASSET_NUMBER | VARCHAR2 | (15) | ||
| ASSET_ID | NUMBER | (15) | ||
| OWNED_LEASED | VARCHAR2 | (15) | ||
| TAG_NUMBER | VARCHAR2 | (15) | ||
| SERIAL_NUMBER | VARCHAR2 | (35) | ||
| MODEL_NUMBER | VARCHAR2 | (40) | ||
| ASSET_TYPE | VARCHAR2 | (11) | ||
| PROPERTY_TYPE | VARCHAR2 | (10) | ||
| PROPERTY_CLASS | VARCHAR2 | (4) | ||
| MANUFACTURER_NAME | VARCHAR2 | (30) | ||
| CURRENT_UNITS | NUMBER | (15) | ||
| NEW_USED | VARCHAR2 | (4) | ||
| INVENTORIAL | VARCHAR2 | (3) | ||
| IN_USE | VARCHAR2 | (3) | ||
| ASSET_CAT_ATTR_CAT_CODE | VARCHAR2 | (210) | ||
| ASSET_CAT_ATTR1 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR2 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR3 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR4 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR5 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR6 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR7 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR8 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR9 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR10 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR11 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR12 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR13 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR14 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR15 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR16 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR17 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR18 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR19 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR20 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR21 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR22 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR23 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR24 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR25 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR26 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR27 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR28 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR29 | VARCHAR2 | (150) | ||
| ASSET_CAT_ATTR30 | VARCHAR2 | (150) | ||
| DISTRIBUTION_ID | NUMBER | (15) | ||
| ENTERED_AMOUNT | NUMBER | |||
| BONUS_ENTERED_AMOUNT | NUMBER | |||
| REVAL_ENTERED_AMOUNT | NUMBER | |||
| SOURCE_TYPE_CODE | VARCHAR2 | (15) | ||
| DEPRN_OVERRIDE_FLAG | VARCHAR2 | (1) | ||
| ADJUSTMENT_LINE_ID | NUMBER | (15) | ||
| SOURCE_DEST_CODE | VARCHAR2 | (15) | ||
| SOURCE_LINE_ID | NUMBER | (15) | ||
| ASSET_INVOICE_ID | NUMBER | (15) | ||
| PAYABLES_CCID | NUMBER | (15) | ||
| PO_VENDOR_ID | NUMBER | (15) | ||
| PO_NUMBER | VARCHAR2 | (20) | ||
| INVOICE_DATE | DATE | |||
| INVOICE_NUMBER | VARCHAR2 | (50) | ||
| INVOICE_ID | NUMBER | (15) | ||
| INVOICE_LINE_NUMBER | NUMBER | (15) | ||
| INVOICE_DISTRIBUTION_ID | NUMBER | (15) | ||
| AP_DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | ||
| PROJECT_ID | NUMBER | (15) | ||
| TASK_ID | NUMBER | (15) | ||
| PROJECT_ASSET_LINE_ID | NUMBER | (15) | ||
| FEEDER_SYSTEM_NAME | VARCHAR2 | (40) | ||
| ASSET_INVOICES_ATTR1 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR2 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR3 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR4 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR5 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR6 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR7 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR8 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR9 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR10 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR11 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR12 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR13 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR14 | VARCHAR2 | (150) | ||
| ASSET_INVOICES_ATTR15 | VARCHAR2 | (150) | ||
| DATE_PLACED_IN_SERVICE | DATE | |||
| CONVERSION_DATE | DATE | |||
| SHORT_FISCAL_YEAR_FLAG | VARCHAR2 | (3) | ||
| COST | NUMBER | |||
| GROUP_ASSET_ID | NUMBER | (15) | ||
| PRODUCTION_CAPACITY | NUMBER | |||
| TRACKING_METHOD | VARCHAR2 | (30) | ||
| DRY_HOLE_FLAG | VARCHAR2 | (1) | ||
| CAT_FLEXFIELD_SEGMENT1 | VARCHAR2 | (30) | ||
| CAT_FLEXFIELD_SEGMENT2 | VARCHAR2 | (30) | ||
| CAT_FLEXFIELD_SEGMENT3 | VARCHAR2 | (30) | ||
| CAT_FLEXFIELD_SEGMENT4 | VARCHAR2 | (30) | ||
| CAT_FLEXFIELD_SEGMENT5 | VARCHAR2 | (30) | ||
| CAT_FLEXFIELD_SEGMENT6 | VARCHAR2 | (30) | ||
| CAT_FLEXFIELD_SEGMENT7 | VARCHAR2 | (30) | ||
| CAT_ID | NUMBER | (15) | ||
| CAT_TYPE | VARCHAR2 | (30) | ||
| CAT_ATTR1 | VARCHAR2 | (150) | ||
| CAT_ATTR2 | VARCHAR2 | (150) | ||
| CAT_ATTR3 | VARCHAR2 | (150) | ||
| CAT_ATTR4 | VARCHAR2 | (150) | ||
| CAT_ATTR5 | VARCHAR2 | (150) | ||
| CAT_ATTR6 | VARCHAR2 | (150) | ||
| CAT_ATTR7 | VARCHAR2 | (150) | ||
| CAT_ATTR8 | VARCHAR2 | (150) | ||
| CAT_ATTR9 | VARCHAR2 | (150) | ||
| CAT_ATTR10 | VARCHAR2 | (150) | ||
| CAT_ATTR11 | VARCHAR2 | (150) | ||
| CAT_ATTR12 | VARCHAR2 | (150) | ||
| CAT_ATTR13 | VARCHAR2 | (150) | ||
| CAT_ATTR14 | VARCHAR2 | (150) | ||
| CAT_ATTR15 | VARCHAR2 | (150) | ||
| BONUS_DEPRN_EXPENSE_ACCT | VARCHAR2 | (25) | ||
| DEPRN_EXPENSE_ACCT | VARCHAR2 | (25) | ||
| ASSET_COST_ACCT | VARCHAR2 | (25) | ||
| ASSET_CLEARING_ACCT | VARCHAR2 | (25) | ||
| CIP_COST_ACCT | VARCHAR2 | (25) | ||
| CIP_CLEARING_ACCT | VARCHAR2 | (25) | ||
| BONUS_RESERVE_ACCT | VARCHAR2 | (25) | ||
| DEPRN_RESERVE_ACCT | VARCHAR2 | (25) | ||
| REVAL_AMORT_ACCT | VARCHAR2 | (25) | ||
| REVAL_RESERVE_ACCT | VARCHAR2 | (25) | ||
| UNPLAN_EXPENSE_ACCT | VARCHAR2 | (25) | ||
| ALT_COST_ACCT | VARCHAR2 | (25) | ||
| WRITE_OFF_ACCT | VARCHAR2 | (25) | ||
| BONUS_RESERVE_ACCT_CCID | NUMBER | (15) | ||
| ASSET_COST_ACCOUNT_CCID | NUMBER | (15) | ||
| ASSET_CLEARING_ACCOUNT_CCID | NUMBER | (15) | ||
| CIP_COST_ACCOUNT_CCID | NUMBER | (15) | ||
| CIP_CLEARING_ACCOUNT_CCID | NUMBER | (15) | ||
| RESERVE_ACCOUNT_CCID | NUMBER | (15) | ||
| REVAL_AMORT_ACCOUNT_CCID | NUMBER | (15) | ||
| REVAL_RESERVE_ACCOUNT_CCID | NUMBER | (15) | ||
| DEPRN_EXPENSE_ACCOUNT_CCID | NUMBER | (15) | ||
| BONUS_EXPENSE_ACCOUNT_CCID | NUMBER | (15) | ||
| UNPLAN_EXPENSE_ACCOUNT_CCID | NUMBER | (15) | ||
| ALT_COST_ACCOUNT_CCID | NUMBER | (15) | ||
| WRITE_OFF_ACCOUNT_CCID | NUMBER | (15) | ||
| CAT_BOOKS_ATTR1 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR2 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR3 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR4 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR5 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR6 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR7 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR8 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR9 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR10 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR11 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR12 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR13 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR14 | VARCHAR2 | (150) | ||
| CAT_BOOKS_ATTR15 | VARCHAR2 | (150) | ||
| EXPENSE_ACCOUNT_CCID | NUMBER | (15) | ||
| UNITS_ASSIGNED | NUMBER | (15) | ||
| EMPLOYEE_ID | NUMBER | (15) | ||
| LEASE_NUMBER | VARCHAR2 | (15) | ||
| LEASE_ID | NUMBER | (15) | ||
| LESSOR_SITE_ID | NUMBER | (15) | ||
| LEASES_ATTR1 | VARCHAR2 | (150) | ||
| LEASES_ATTR2 | VARCHAR2 | (150) | ||
| LEASES_ATTR3 | VARCHAR2 | (150) | ||
| LEASES_ATTR4 | VARCHAR2 | (150) | ||
| LEASES_ATTR5 | VARCHAR2 | (150) | ||
| LEASES_ATTR6 | VARCHAR2 | (150) | ||
| LEASES_ATTR7 | VARCHAR2 | (150) | ||
| LEASES_ATTR8 | VARCHAR2 | (150) | ||
| LEASES_ATTR9 | VARCHAR2 | (150) | ||
| LEASES_ATTR10 | VARCHAR2 | (150) | ||
| LEASES_ATTR11 | VARCHAR2 | (150) | ||
| LEASES_ATTR12 | VARCHAR2 | (150) | ||
| LEASES_ATTR13 | VARCHAR2 | (150) | ||
| LEASES_ATTR14 | VARCHAR2 | (150) | ||
| LEASES_ATTR15 | VARCHAR2 | (150) | ||
| LOCATION_ID | NUMBER | (15) | ||
| LOCATION_KEY_SEGMENT1 | VARCHAR2 | (30) | ||
| LOCATION_KEY_SEGMENT2 | VARCHAR2 | (30) | ||
| LOCATION_KEY_SEGMENT3 | VARCHAR2 | (30) | ||
| LOCATION_KEY_SEGMENT4 | VARCHAR2 | (30) | ||
| LOCATION_KEY_SEGMENT5 | VARCHAR2 | (30) | ||
| LOCATION_KEY_SEGMENT6 | VARCHAR2 | (30) | ||
| LOCATION_KEY_SEGMENT7 | VARCHAR2 | (30) | ||
| LOCATIONS_ATTR1 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR2 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR3 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR4 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR5 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR6 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR7 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR8 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR9 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR10 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR11 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR12 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR13 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR14 | VARCHAR2 | (150) | ||
| LOCATIONS_ATTR15 | VARCHAR2 | (150) | ||
| BONUS_RESERVE_RETIRED | NUMBER | |||
| COST_RETIRED | NUMBER | |||
| NBV_RETIRED | NUMBER | |||
| GAIN_LOSS_AMOUNT | NUMBER | |||
| PROCEEDS_OF_SALE_AMOUNT | NUMBER | |||
| COST_OF_REMOVAL_AMOUNT | NUMBER | |||
| REVAL_RESERVE_RETIRED_AMOUNT | NUMBER | |||
| UNREVALUED_COST_RETIRED | NUMBER | |||
| RETIREMENT_TYPE | VARCHAR2 | (15) | ||
| RETIREMENTS_ATTR1 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR2 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR3 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR4 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR5 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR6 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR7 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR8 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR9 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR10 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR11 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR12 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR13 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR14 | VARCHAR2 | (150) | ||
| RETIREMENTS_ATTR15 | VARCHAR2 | (150) | ||
| TRANSACTION_HEADER_ID | NUMBER | (15) | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | (20) | ||
| TRANSACTION_SUBTYPE | VARCHAR2 | (9) | ||
| TRANSACTION_KEY | VARCHAR2 | (2) | ||
| TRANSACTION_NAME | VARCHAR2 | (30) | ||
| SOURCE_TRANSACTION_HEADER_ID | NUMBER | (15) | ||
| CALLING_INTERFACE | VARCHAR2 | (30) | ||
| AMORTIZATION_START_DATE | DATE | |||
| TRANSACTIONS_ATTR1 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR2 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR3 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR4 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR5 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR6 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR7 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR8 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR9 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR10 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR11 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR12 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR13 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR14 | VARCHAR2 | (150) | ||
| TRANSACTIONS_ATTR15 | VARCHAR2 | (150) | ||
| VENDOR_NAME | VARCHAR2 | (240) | ||
| PROJECT_NUMBER | VARCHAR2 | (240) | ||
| ASSET_KEY_CCID | NUMBER | (15) | ||
| ASSET_KEY_SEGMENT1 | VARCHAR2 | (30) | ||
| ASSET_KEY_SEGMENT2 | VARCHAR2 | (30) | ||
| ASSET_KEY_SEGMENT3 | VARCHAR2 | (30) | ||
| ASSET_KEY_SEGMENT4 | VARCHAR2 | (30) | ||
| ASSET_KEY_SEGMENT5 | VARCHAR2 | (30) | ||
| ASSET_KEY_SEGMENT6 | VARCHAR2 | (30) | ||
| ASSET_KEY_SEGMENT7 | VARCHAR2 | (30) | ||
| ASSET_KEY_SEGMENT8 | VARCHAR2 | (30) | ||
| ASSET_KEY_SEGMENT9 | VARCHAR2 | (30) | ||
| ASSET_KEY_SEGMENT10 | VARCHAR2 | (30) | ||
| SUPER_GROUP_ID | NUMBER | (15) | ||
| METHOD_CODE | VARCHAR2 | (12) | ||
| DEPRN_BASIS_RULE_ID | NUMBER | (15) | ||
| PRORATE_CONVENTION_CODE | VARCHAR2 | (10) | ||
| PRORATE_DATE | DATE | |||
| BONUS_RULE | VARCHAR2 | (30) | ||
| PRODUCTION | NUMBER | |||
| REFERENCE_NUM | VARCHAR2 | (15) | ||
| SOLD_TO | VARCHAR2 | (30) | ||
| TRADE_IN_ASSET_ID | NUMBER | (15) | ||
| ASSET_CAT_GLOBAL_ATTR1 | VARCHAR2 | (150) | ||
| ASSET_CAT_GLOBAL_ATTR2 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR1 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR2 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR3 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR4 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR5 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR6 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR7 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR8 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR9 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR10 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR11 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR12 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR13 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR14 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR15 | VARCHAR2 | (150) | ||
| CAT_GLOBAL_ATTR16 | VARCHAR2 | (150) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| GENERATED_CCID | NUMBER | (15) | ||
| GENERATED_OFFSET_CCID | NUMBER | (15) | ||
| BONUS_GENERATED_CCID | NUMBER | (15) | ||
| BONUS_GENERATED_OFFSET_CCID | NUMBER | (15) | ||
| REVAL_GENERATED_CCID | NUMBER | (15) | ||
| REVAL_GENERATED_OFFSET_CCID | NUMBER | (15) | ||
| LEDGER_ID | NUMBER | (15) | ||
| DISTRIBUTION_TYPE_CODE | VARCHAR2 | (30) | ||
| TRANSACTION_REFERENCE_ID | NUMBER | (15) | ||
| ADJUSTMENT_TYPE | VARCHAR2 | (15) | ||
| DEPRN_RUN_ID | NUMBER | (15) | ||
| TAX_BOOK_TYPE_CODE | VARCHAR2 | (15) | ||
| PERIOD_COUNTER | NUMBER | (15) | ||
| COUNTER_GENERATED_CCID | NUMBER | (15) | ||
| COUNTER_GENERATED_OFFSET_CCID | NUMBER | (15) | ||
| IMPAIR_EXPENSE_ACCOUNT_CCID | NUMBER | (15) | ||
| IMPAIR_RESERVE_ACCOUNT_CCID | NUMBER | (15) | ||
| IMPAIR_EXPENSE_ACCT | VARCHAR2 | (25) | ||
| IMPAIR_RESERVE_ACCT | VARCHAR2 | (25) | ||
| GENERAL_FUND_ACCOUNT_CCID | NUMBER | (15) | ||
| GENERAL_FUND_ACCT | VARCHAR2 | (25) | ||
| CAPITAL_ADJ_ACCOUNT_CCID | NUMBER | (15) | ||
| CAPITAL_ADJ_ACCT | VARCHAR2 | (25) | ||
| CAPITAL_ADJ_GENERATED_CCID | NUMBER | (15) | ||
| GENERAL_FUND_GENERATED_CCID | NUMBER | (15) | ||
| OVERRIDE_ACCOUNT_SEGMENT | VARCHAR2 | (25) | ||
| REVAL_LOSS_ACCT | VARCHAR2 | (25) | ||
| REVAL_LOSS_ACCOUNT_CCID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, LINE_NUMBER
, BOOK_TYPE_CODE
, ASSET_NUMBER
, ASSET_ID
, OWNED_LEASED
, TAG_NUMBER
, SERIAL_NUMBER
, MODEL_NUMBER
, ASSET_TYPE
, PROPERTY_TYPE
, PROPERTY_CLASS
, MANUFACTURER_NAME
, CURRENT_UNITS
, NEW_USED
, INVENTORIAL
, IN_USE
, ASSET_CAT_ATTR_CAT_CODE
, ASSET_CAT_ATTR1
, ASSET_CAT_ATTR2
, ASSET_CAT_ATTR3
, ASSET_CAT_ATTR4
, ASSET_CAT_ATTR5
, ASSET_CAT_ATTR6
, ASSET_CAT_ATTR7
, ASSET_CAT_ATTR8
, ASSET_CAT_ATTR9
, ASSET_CAT_ATTR10
, ASSET_CAT_ATTR11
, ASSET_CAT_ATTR12
, ASSET_CAT_ATTR13
, ASSET_CAT_ATTR14
, ASSET_CAT_ATTR15
, ASSET_CAT_ATTR16
, ASSET_CAT_ATTR17
, ASSET_CAT_ATTR18
, ASSET_CAT_ATTR19
, ASSET_CAT_ATTR20
, ASSET_CAT_ATTR21
, ASSET_CAT_ATTR22
, ASSET_CAT_ATTR23
, ASSET_CAT_ATTR24
, ASSET_CAT_ATTR25
, ASSET_CAT_ATTR26
, ASSET_CAT_ATTR27
, ASSET_CAT_ATTR28
, ASSET_CAT_ATTR29
, ASSET_CAT_ATTR30
, DISTRIBUTION_ID
, ENTERED_AMOUNT
, BONUS_ENTERED_AMOUNT
, REVAL_ENTERED_AMOUNT
, SOURCE_TYPE_CODE
, DEPRN_OVERRIDE_FLAG
, ADJUSTMENT_LINE_ID
, SOURCE_DEST_CODE
, SOURCE_LINE_ID
, ASSET_INVOICE_ID
, PAYABLES_CCID
, PO_VENDOR_ID
, PO_NUMBER
, INVOICE_DATE
, INVOICE_NUMBER
, INVOICE_ID
, INVOICE_LINE_NUMBER
, INVOICE_DISTRIBUTION_ID
, AP_DISTRIBUTION_LINE_NUMBER
, PROJECT_ID
, TASK_ID
, PROJECT_ASSET_LINE_ID
, FEEDER_SYSTEM_NAME
, ASSET_INVOICES_ATTR1
, ASSET_INVOICES_ATTR2
, ASSET_INVOICES_ATTR3
, ASSET_INVOICES_ATTR4
, ASSET_INVOICES_ATTR5
, ASSET_INVOICES_ATTR6
, ASSET_INVOICES_ATTR7
, ASSET_INVOICES_ATTR8
, ASSET_INVOICES_ATTR9
, ASSET_INVOICES_ATTR10
, ASSET_INVOICES_ATTR11
, ASSET_INVOICES_ATTR12
, ASSET_INVOICES_ATTR13
, ASSET_INVOICES_ATTR14
, ASSET_INVOICES_ATTR15
, DATE_PLACED_IN_SERVICE
, CONVERSION_DATE
, SHORT_FISCAL_YEAR_FLAG
, COST
, GROUP_ASSET_ID
, PRODUCTION_CAPACITY
, TRACKING_METHOD
, DRY_HOLE_FLAG
, CAT_FLEXFIELD_SEGMENT1
, CAT_FLEXFIELD_SEGMENT2
, CAT_FLEXFIELD_SEGMENT3
, CAT_FLEXFIELD_SEGMENT4
, CAT_FLEXFIELD_SEGMENT5
, CAT_FLEXFIELD_SEGMENT6
, CAT_FLEXFIELD_SEGMENT7
, CAT_ID
, CAT_TYPE
, CAT_ATTR1
, CAT_ATTR2
, CAT_ATTR3
, CAT_ATTR4
, CAT_ATTR5
, CAT_ATTR6
, CAT_ATTR7
, CAT_ATTR8
, CAT_ATTR9
, CAT_ATTR10
, CAT_ATTR11
, CAT_ATTR12
, CAT_ATTR13
, CAT_ATTR14
, CAT_ATTR15
, BONUS_DEPRN_EXPENSE_ACCT
, DEPRN_EXPENSE_ACCT
, ASSET_COST_ACCT
, ASSET_CLEARING_ACCT
, CIP_COST_ACCT
, CIP_CLEARING_ACCT
, BONUS_RESERVE_ACCT
, DEPRN_RESERVE_ACCT
, REVAL_AMORT_ACCT
, REVAL_RESERVE_ACCT
, UNPLAN_EXPENSE_ACCT
, ALT_COST_ACCT
, WRITE_OFF_ACCT
, BONUS_RESERVE_ACCT_CCID
, ASSET_COST_ACCOUNT_CCID
, ASSET_CLEARING_ACCOUNT_CCID
, CIP_COST_ACCOUNT_CCID
, CIP_CLEARING_ACCOUNT_CCID
, RESERVE_ACCOUNT_CCID
, REVAL_AMORT_ACCOUNT_CCID
, REVAL_RESERVE_ACCOUNT_CCID
, DEPRN_EXPENSE_ACCOUNT_CCID
, BONUS_EXPENSE_ACCOUNT_CCID
, UNPLAN_EXPENSE_ACCOUNT_CCID
, ALT_COST_ACCOUNT_CCID
, WRITE_OFF_ACCOUNT_CCID
, CAT_BOOKS_ATTR1
, CAT_BOOKS_ATTR2
, CAT_BOOKS_ATTR3
, CAT_BOOKS_ATTR4
, CAT_BOOKS_ATTR5
, CAT_BOOKS_ATTR6
, CAT_BOOKS_ATTR7
, CAT_BOOKS_ATTR8
, CAT_BOOKS_ATTR9
, CAT_BOOKS_ATTR10
, CAT_BOOKS_ATTR11
, CAT_BOOKS_ATTR12
, CAT_BOOKS_ATTR13
, CAT_BOOKS_ATTR14
, CAT_BOOKS_ATTR15
, EXPENSE_ACCOUNT_CCID
, UNITS_ASSIGNED
, EMPLOYEE_ID
, LEASE_NUMBER
, LEASE_ID
, LESSOR_SITE_ID
, LEASES_ATTR1
, LEASES_ATTR2
, LEASES_ATTR3
, LEASES_ATTR4
, LEASES_ATTR5
, LEASES_ATTR6
, LEASES_ATTR7
, LEASES_ATTR8
, LEASES_ATTR9
, LEASES_ATTR10
, LEASES_ATTR11
, LEASES_ATTR12
, LEASES_ATTR13
, LEASES_ATTR14
, LEASES_ATTR15
, LOCATION_ID
, LOCATION_KEY_SEGMENT1
, LOCATION_KEY_SEGMENT2
, LOCATION_KEY_SEGMENT3
, LOCATION_KEY_SEGMENT4
, LOCATION_KEY_SEGMENT5
, LOCATION_KEY_SEGMENT6
, LOCATION_KEY_SEGMENT7
, LOCATIONS_ATTR1
, LOCATIONS_ATTR2
, LOCATIONS_ATTR3
, LOCATIONS_ATTR4
, LOCATIONS_ATTR5
, LOCATIONS_ATTR6
, LOCATIONS_ATTR7
, LOCATIONS_ATTR8
, LOCATIONS_ATTR9
, LOCATIONS_ATTR10
, LOCATIONS_ATTR11
, LOCATIONS_ATTR12
, LOCATIONS_ATTR13
, LOCATIONS_ATTR14
, LOCATIONS_ATTR15
, BONUS_RESERVE_RETIRED
, COST_RETIRED
, NBV_RETIRED
, GAIN_LOSS_AMOUNT
, PROCEEDS_OF_SALE_AMOUNT
, COST_OF_REMOVAL_AMOUNT
, REVAL_RESERVE_RETIRED_AMOUNT
, UNREVALUED_COST_RETIRED
, RETIREMENT_TYPE
, RETIREMENTS_ATTR1
, RETIREMENTS_ATTR2
, RETIREMENTS_ATTR3
, RETIREMENTS_ATTR4
, RETIREMENTS_ATTR5
, RETIREMENTS_ATTR6
, RETIREMENTS_ATTR7
, RETIREMENTS_ATTR8
, RETIREMENTS_ATTR9
, RETIREMENTS_ATTR10
, RETIREMENTS_ATTR11
, RETIREMENTS_ATTR12
, RETIREMENTS_ATTR13
, RETIREMENTS_ATTR14
, RETIREMENTS_ATTR15
, TRANSACTION_HEADER_ID
, TRANSACTION_TYPE_CODE
, TRANSACTION_SUBTYPE
, TRANSACTION_KEY
, TRANSACTION_NAME
, SOURCE_TRANSACTION_HEADER_ID
, CALLING_INTERFACE
, AMORTIZATION_START_DATE
, TRANSACTIONS_ATTR1
, TRANSACTIONS_ATTR2
, TRANSACTIONS_ATTR3
, TRANSACTIONS_ATTR4
, TRANSACTIONS_ATTR5
, TRANSACTIONS_ATTR6
, TRANSACTIONS_ATTR7
, TRANSACTIONS_ATTR8
, TRANSACTIONS_ATTR9
, TRANSACTIONS_ATTR10
, TRANSACTIONS_ATTR11
, TRANSACTIONS_ATTR12
, TRANSACTIONS_ATTR13
, TRANSACTIONS_ATTR14
, TRANSACTIONS_ATTR15
, VENDOR_NAME
, PROJECT_NUMBER
, ASSET_KEY_CCID
, ASSET_KEY_SEGMENT1
, ASSET_KEY_SEGMENT2
, ASSET_KEY_SEGMENT3
, ASSET_KEY_SEGMENT4
, ASSET_KEY_SEGMENT5
, ASSET_KEY_SEGMENT6
, ASSET_KEY_SEGMENT7
, ASSET_KEY_SEGMENT8
, ASSET_KEY_SEGMENT9
, ASSET_KEY_SEGMENT10
, SUPER_GROUP_ID
, METHOD_CODE
, DEPRN_BASIS_RULE_ID
, PRORATE_CONVENTION_CODE
, PRORATE_DATE
, BONUS_RULE
, PRODUCTION
, REFERENCE_NUM
, SOLD_TO
, TRADE_IN_ASSET_ID
, ASSET_CAT_GLOBAL_ATTR1
, ASSET_CAT_GLOBAL_ATTR2
, CAT_GLOBAL_ATTR1
, CAT_GLOBAL_ATTR2
, CAT_GLOBAL_ATTR3
, CAT_GLOBAL_ATTR4
, CAT_GLOBAL_ATTR5
, CAT_GLOBAL_ATTR6
, CAT_GLOBAL_ATTR7
, CAT_GLOBAL_ATTR8
, CAT_GLOBAL_ATTR9
, CAT_GLOBAL_ATTR10
, CAT_GLOBAL_ATTR11
, CAT_GLOBAL_ATTR12
, CAT_GLOBAL_ATTR13
, CAT_GLOBAL_ATTR14
, CAT_GLOBAL_ATTR15
, CAT_GLOBAL_ATTR16
, CURRENCY_CODE
, GENERATED_CCID
, GENERATED_OFFSET_CCID
, BONUS_GENERATED_CCID
, BONUS_GENERATED_OFFSET_CCID
, REVAL_GENERATED_CCID
, REVAL_GENERATED_OFFSET_CCID
, LEDGER_ID
, DISTRIBUTION_TYPE_CODE
, TRANSACTION_REFERENCE_ID
, ADJUSTMENT_TYPE
, DEPRN_RUN_ID
, TAX_BOOK_TYPE_CODE
, PERIOD_COUNTER
, COUNTER_GENERATED_CCID
, COUNTER_GENERATED_OFFSET_CCID
, IMPAIR_EXPENSE_ACCOUNT_CCID
, IMPAIR_RESERVE_ACCOUNT_CCID
, IMPAIR_EXPENSE_ACCT
, IMPAIR_RESERVE_ACCT
, GENERAL_FUND_ACCOUNT_CCID
, GENERAL_FUND_ACCT
, CAPITAL_ADJ_ACCOUNT_CCID
, CAPITAL_ADJ_ACCT
, CAPITAL_ADJ_GENERATED_CCID
, GENERAL_FUND_GENERATED_CCID
, OVERRIDE_ACCOUNT_SEGMENT
, REVAL_LOSS_ACCT
, REVAL_LOSS_ACCOUNT_CCID
FROM FA.FA_XLA_EXT_LINES_B_GT;
FA.FA_XLA_EXT_LINES_B_GT does not reference any database object
FA.FA_XLA_EXT_LINES_B_GT is referenced by following:
APPS
FA_XLA_EXT_LINES_B_GT
|
|
|
|