[Home] [Help] [Dependency Information]
Object Name: | WIP_PAC_PERIOD_BALANCES |
---|---|
Object Type: | TABLE |
Owner: | WIP |
FND Design Data: | WIP.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WIP_PAC_PERIOD_BALANCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PAC_PERIOD_ID
COST_GROUP_ID WIP_ENTITY_ID OPERATION_SEQ_NUM LINE_ID ORGANIZATION_ID |
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 |
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;
WIP.WIP_PAC_PERIOD_BALANCES does not reference any database object
WIP.WIP_PAC_PERIOD_BALANCES is referenced by following:
|
|
|