[Home] [Help] [Dependency Information]
Object Name: | MTL_FISCAL_CAT_ACCOUNTS# |
---|---|
Object Type: | VIEW |
Owner: | INV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | |
COST_TYPE_ID | NUMBER | Yes | ||
COST_GROUP_ID | NUMBER | Yes | ||
CATEGORY_ID | NUMBER | Yes | ||
MATERIAL_ACCOUNT | NUMBER | (15) | ||
MATERIAL_OVERHEAD_ACCOUNT | NUMBER | (15) | ||
RESOURCE_ACCOUNT | NUMBER | (15) | ||
OUTSIDE_PROCESSING_ACCOUNT | NUMBER | (15) | ||
OVERHEAD_ACCOUNT | NUMBER | (15) | ||
EXPENSE_ACCOUNT | NUMBER | (15) | ||
BRIDGING_ACCOUNT | NUMBER | (15) | ||
NON_INVOICED_SO | NUMBER | |||
NON_INVOICED_REVENUE | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LEGAL_ENTITY_ID
, COST_TYPE_ID
, COST_GROUP_ID
, CATEGORY_ID
, MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, OVERHEAD_ACCOUNT
, EXPENSE_ACCOUNT
, BRIDGING_ACCOUNT
, NON_INVOICED_SO
, NON_INVOICED_REVENUE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM INV.MTL_FISCAL_CAT_ACCOUNTS#;
|
|
|