DBA Data[Home] [Help] [Dependency Information]

TABLE: WIP.WIP_PAC_PERIOD_BALANCES

Object Details
Object Name: WIP_PAC_PERIOD_BALANCES
Object Type: TABLE
Owner: WIP
FND Design Data: TableWIP.WIP_PAC_PERIOD_BALANCES
Subobject Name:
Status: VALID


Stores the WIP balances for all entities within a cost group by period. Values are stored by WIP_ENTITY_ID, LINE_ID and OPERATION_SEQ_NUM. The IN columns represent value charged to the entity by material issues, resource charges or overhead charges. The OUT columns represent the value relieved from the entity by scrap or completions. The VAR columns usually represent the difference between IN and OUT columns and are updated during period close for repetitive schedules and during job close for discrete jobs. For repetitive schedules, the values are stored at the repetitive line level by aggregating the charges by operation for every schedule. OPERATION_COMPLETED_UNITS represents the quantity of assembly units that have moved past an operation. RELIEVED_ASSEMBLY_UNITS represents the quantity of assembly units that are relieved from the operation due to completion or scrap.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WIP_PAC_PERIOD_BALANCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAC_PERIOD_ID
ColumnCOST_GROUP_ID
ColumnWIP_ENTITY_ID
ColumnOPERATION_SEQ_NUM
ColumnLINE_ID
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
PAC_PERIOD_ID NUMBER
Yes Period Identifier
COST_GROUP_ID NUMBER
Yes Cost group Identifier
COST_TYPE_ID NUMBER
Yes Cost type Identifier
ORGANIZATION_ID NUMBER
Yes Organization Identifier
WIP_ENTITY_ID NUMBER
Yes WIP entity Identifier
LINE_ID NUMBER

Repetitive line Identifier
OPERATION_SEQ_NUM NUMBER
Yes WIP operation sequence number
OPERATION_COMPLETED_UNITS NUMBER

Assembly units moved past this operation
RELIEVED_ASSEMBLY_UNITS NUMBER

Assembly units that moved past and were relieved (completed, scrapped) from the operation
TL_RESOURCE_IN NUMBER

This level resource charges accumulated
TL_RESOURCE_OUT NUMBER

This level resource charges relieved
TL_OUTSIDE_PROCESSING_IN NUMBER

This level outside processing charges accumulated
TL_OUTSIDE_PROCESSING_OUT NUMBER

This level outside processing charges relieved
TL_OVERHEAD_IN NUMBER

This level overhead charges accumulated
TL_OVERHEAD_OUT NUMBER

This level overhead charges relieved
PL_MATERIAL_IN NUMBER

Previous level material charges accumulated
PL_MATERIAL_OUT NUMBER

Previous level material charges relieved
PL_RESOURCE_IN NUMBER

Previous level resource charges accumulated
PL_RESOURCE_OUT NUMBER

Previous level resource charges relieved
PL_OVERHEAD_IN NUMBER

Previous level overhead charges accumulated
PL_OVERHEAD_OUT NUMBER

Previous level overhead charges relieved
PL_OUTSIDE_PROCESSING_IN NUMBER

Previous level outside processing charges accumulated
PL_OUTSIDE_PROCESSING_OUT NUMBER

Previous level outside processing charges relieved
PL_MATERIAL_OVERHEAD_IN NUMBER

Previous level material overhead charges accumulated
PL_MATERIAL_OVERHEAD_OUT NUMBER

Previous level material overhead charges relieved
TL_RESOURCE_TEMP NUMBER

Temporary value storage column
TL_OUTSIDE_PROCESSING_TEMP NUMBER

Temporary value storage column
TL_OVERHEAD_TEMP NUMBER

Temporary value storage column
PL_MATERIAL_TEMP NUMBER

Temporary value storage column
PL_MATERIAL_OVERHEAD_TEMP NUMBER

Temporary value storage column
PL_RESOURCE_TEMP NUMBER

Temporary value storage column
PL_OUTSIDE_PROCESSING_TEMP NUMBER

Temporary value storage column
PL_OVERHEAD_TEMP NUMBER

Temporary value storage column
TL_RESOURCE_VAR NUMBER

This level resource charge variance (accumulated less relieved, recognized at period end or job close)
TL_OUTSIDE_PROCESSING_VAR NUMBER

This level outside processing charge variance (accumulated less relieved, recognized at period end or job close)
TL_OVERHEAD_VAR NUMBER

This level overhead charge variance (accumulated less relieved, recognized at period end or job close)
PL_MATERIAL_VAR NUMBER

Previous level material charge variance (accumulated less relieved, recognized at period end or job close)
PL_MATERIAL_OVERHEAD_VAR NUMBER

Previous level material overhead charge variance (accumulated less relieved, recognized at period end or job close)
PL_RESOURCE_VAR NUMBER

Previous level resource charge variance (accumulated less relieved, recognized at period end or job close)
PL_OUTSIDE_PROCESSING_VAR NUMBER

Previous level outside processing charge variance (accumulated less relieved, recognized at period end or job close)
PL_OVERHEAD_VAR NUMBER

Previous level overhead charge variance (accumulated less relieved, recognized at period end or job close)
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
WIP_ENTITY_TYPE NUMBER
Yes WIP entity type
PL_MATERIAL_IN_APULL NUMBER

Previous level material charges incurred in this PAC period due to assembly pull components
PL_MATERIAL_OVERHEAD_IN_APULL NUMBER

Previous level material overhead charges incurred in this PAC period due to assembly pull components
PL_RESOURCE_IN_APULL NUMBER

Previous level resource charges incurred in this PAC period due to assembly pull components
PL_OUTSIDE_PROCESSING_IN_APULL NUMBER

Previous level outside processing charges incurred in this PAC period due to assembly pull components
PL_OVERHEAD_IN_APULL NUMBER

Previous level overhead charges incurred in this PAC period due to assembly pull components
PL_MATERIAL_TEMP_VAR NUMBER

Temporary value storage column
PL_MATERIAL_OVERHEAD_TEMP_VAR NUMBER

Temporary value storage column
PL_RESOURCE_TEMP_VAR NUMBER

Temporary value storage column
PL_OVERHEAD_TEMP_VAR NUMBER

Temporary value storage column
PL_OUTSIDE_PROCESSING_TEMP_VAR NUMBER

Temporary value storage column
UNRELIEVED_SCRAP_QUANTITY NUMBER

Scrap Quantity With out Scrap Account
SCRAP_PULL_MATERIAL NUMBER

Stores Material Pull value due to Relived Scrap Quantity in a period
SCRAP_PULL_MATERIAL_OVERHEAD NUMBER

Stores Material overhead Pull value due to Relived Scrap Quantity in a period
SCRAP_PULL_RESOURCE NUMBER

Stores Resource Pull value due to Releived Scrap Quantity in a period
SCRAP_PULL_OUTSIDE_PROCESSING NUMBER

Stores OSP Pull value due to Relieved Scrap Quantity in a period
SCRAP_PULL_OVERHEAD NUMBER

Stores Overhead Pull value due to Relieved Scrap Quantity in a period
RELIEVED_SCRAP_QTY NUMBER

Stores Relived Scrap Quantity in a period
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PAC_PERIOD_ID
,      COST_GROUP_ID
,      COST_TYPE_ID
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      LINE_ID
,      OPERATION_SEQ_NUM
,      OPERATION_COMPLETED_UNITS
,      RELIEVED_ASSEMBLY_UNITS
,      TL_RESOURCE_IN
,      TL_RESOURCE_OUT
,      TL_OUTSIDE_PROCESSING_IN
,      TL_OUTSIDE_PROCESSING_OUT
,      TL_OVERHEAD_IN
,      TL_OVERHEAD_OUT
,      PL_MATERIAL_IN
,      PL_MATERIAL_OUT
,      PL_RESOURCE_IN
,      PL_RESOURCE_OUT
,      PL_OVERHEAD_IN
,      PL_OVERHEAD_OUT
,      PL_OUTSIDE_PROCESSING_IN
,      PL_OUTSIDE_PROCESSING_OUT
,      PL_MATERIAL_OVERHEAD_IN
,      PL_MATERIAL_OVERHEAD_OUT
,      TL_RESOURCE_TEMP
,      TL_OUTSIDE_PROCESSING_TEMP
,      TL_OVERHEAD_TEMP
,      PL_MATERIAL_TEMP
,      PL_MATERIAL_OVERHEAD_TEMP
,      PL_RESOURCE_TEMP
,      PL_OUTSIDE_PROCESSING_TEMP
,      PL_OVERHEAD_TEMP
,      TL_RESOURCE_VAR
,      TL_OUTSIDE_PROCESSING_VAR
,      TL_OVERHEAD_VAR
,      PL_MATERIAL_VAR
,      PL_MATERIAL_OVERHEAD_VAR
,      PL_RESOURCE_VAR
,      PL_OUTSIDE_PROCESSING_VAR
,      PL_OVERHEAD_VAR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      WIP_ENTITY_TYPE
,      PL_MATERIAL_IN_APULL
,      PL_MATERIAL_OVERHEAD_IN_APULL
,      PL_RESOURCE_IN_APULL
,      PL_OUTSIDE_PROCESSING_IN_APULL
,      PL_OVERHEAD_IN_APULL
,      PL_MATERIAL_TEMP_VAR
,      PL_MATERIAL_OVERHEAD_TEMP_VAR
,      PL_RESOURCE_TEMP_VAR
,      PL_OVERHEAD_TEMP_VAR
,      PL_OUTSIDE_PROCESSING_TEMP_VAR
,      UNRELIEVED_SCRAP_QUANTITY
,      SCRAP_PULL_MATERIAL
,      SCRAP_PULL_MATERIAL_OVERHEAD
,      SCRAP_PULL_RESOURCE
,      SCRAP_PULL_OUTSIDE_PROCESSING
,      SCRAP_PULL_OVERHEAD
,      RELIEVED_SCRAP_QTY
FROM WIP.WIP_PAC_PERIOD_BALANCES;

Dependencies

[top of page]

WIP.WIP_PAC_PERIOD_BALANCES does not reference any database object

WIP.WIP_PAC_PERIOD_BALANCES is referenced by following:

SchemaWIP
ViewWIP_PAC_PERIOD_BALANCES#