[Home] [Help] [Dependency Information]
Object Name: | CST_MGD_LIFO_PERIODS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.CST_MGD_LIFO_PERIODS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAC_PERIOD_ID | NUMBER | Yes | Periodic Actual Costing Period Identifier. This identifier is used for LIFO periods as well | |
PERIOD_NAME | VARCHAR2 | (15) | Yes | Period Name. If periods are in annual increments the period names might be 1995, 1996, 1997 ETC or if the periods are in monthly increments the names might be Jan, Feb, Mar ETC |
PERIOD_OPEN_FLAG | VARCHAR2 | (1) | Yes | Records if the period is open or not |
PERIOD_STATUS | VARCHAR2 | (80) | Yes | Records the status of a period. Needed along with open flag because there are more than two statuses. |
PERIOD_START_DATE | DATE | Yes | Period Start Date | |
PERIOD_END_DATE | DATE | Yes | Period End Date | |
PERIOD_YEAR | NUMBER | Yes | Period Year. Depending on the period increment this might be day, month, year etc | |
PERIOD_NUM | NUMBER | Yes | Period Number | |
COST_TYPE_ID | NUMBER | Yes | Cost Type Identifier | |
COST_TYPE_NAME | VARCHAR2 | (10) | Yes | Cost Type Name |
COST_TYPE_DESCRIPTION | VARCHAR2 | (240) | Cost Type Description | |
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | Legal Entity Identifier |
LEGAL_ENTITY_NAME | VARCHAR2 | (240) | Yes | Legal Entity Name |
COST_GROUP_ID | NUMBER | Yes | Cost Group Identifier | |
COST_GROUP_NAME | VARCHAR2 | (10) | Yes | Cost Group Name |
COST_GROUP_DESCRIPTION | VARCHAR2 | (240) | Cost Group Description | |
MASTER_ORGANIZATION_ID | NUMBER | Master Organization Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PAC_PERIOD_ID
, PERIOD_NAME
, PERIOD_OPEN_FLAG
, PERIOD_STATUS
, PERIOD_START_DATE
, PERIOD_END_DATE
, PERIOD_YEAR
, PERIOD_NUM
, COST_TYPE_ID
, COST_TYPE_NAME
, COST_TYPE_DESCRIPTION
, LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME
, COST_GROUP_ID
, COST_GROUP_NAME
, COST_GROUP_DESCRIPTION
, MASTER_ORGANIZATION_ID
FROM APPS.CST_MGD_LIFO_PERIODS_V;
APPS.CST_MGD_LIFO_PERIODS_V is not referenced by any database object
|
|
|