[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
|
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
|
|
|
|