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

TABLE: WIP.WIP_BIS_PROD_DEPT_YIELD_TEMP

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


Temporary table that contains information about yield with reference to a job, assembly, and department. It includes information about assemblies scrapped at each department operation.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization Identifier.
WIP_ENTITY_ID NUMBER

Discrete job or flow schedule Identifier.
INVENTORY_ITEM_ID NUMBER

Inventory item Identifier for the assembly the job or schedule creates.
OPERATION_SEQ_NUM NUMBER

Operation sequence number.
DEPARTMENT_ID NUMBER

Department identifier.
DEPARTMENT_CODE VARCHAR2 (10)
Short code uniquely identifying the department.
TRANSACTION_DATE DATE

Date the transaction takes place.
TOTAL_QUANTITY NUMBER

Total number of distinct assemblies worked on by the department/resource combination.
SCRAP_QUANTITY NUMBER

Total number of distinct assemblies scrapped by the department/resource combination.
EXISTING_FLAG NUMBER

Flag to differentiate between the existing data and newly generated data.
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.
LAST_UPDATE_LOGIN NUMBER

Standard Who column.
REQUEST_ID NUMBER

Standard Who column.
PROGRAM_APPLICATION_ID NUMBER

Standard Who column.
PROGRAM_ID NUMBER

Standard Who column.
PROGRAM_UPDATE_DATE DATE

Standard Who column.
SET_OF_BOOKS_ID NUMBER

Set of books Identifier.
SET_OF_BOOKS_NAME VARCHAR2 (30)
Name of set of books.
LEGAL_ENTITY_ID NUMBER

Legal entity Identifier.
LEGAL_ENTITY_NAME VARCHAR2 (240)
Name of legal entity.
OPERATING_UNIT_ID NUMBER

Operating unit Identifier.
OPERATING_UNIT_NAME VARCHAR2 (240)
Name of operating unit.
ORGANIZATION_NAME VARCHAR2 (240)
Name of organization.
LOCATION_ID NUMBER

Identifies the geographic location.
AREA_CODE VARCHAR2 (30)
Short code that uniquely identifies the geographic area.
AREA_NAME VARCHAR2 (80)
Name of geographic area.
COUNTRY_CODE VARCHAR2 (60)
Short code that uniquely identifies the country that the organization is located in.
COUNTRY_NAME VARCHAR2 (80)
Name of the country.
REGION_CODE VARCHAR2 (30)
Short code that uniquely identifies the region of the country in which the organization is located.
REGION_NAME VARCHAR2 (80)
Name of the region in which the organization is located.
PERIOD_SET_NAME VARCHAR2 (15)
Accounting calendar.
YEAR VARCHAR2 (15)
Period name for period type accounting calendar year.
QUARTER VARCHAR2 (15)
Period name for period type accounting calendar quarter.
MONTH VARCHAR2 (15)
Period name for period type accounting calendar month.
Query Text

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


SELECT ORGANIZATION_ID
,      WIP_ENTITY_ID
,      INVENTORY_ITEM_ID
,      OPERATION_SEQ_NUM
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      TRANSACTION_DATE
,      TOTAL_QUANTITY
,      SCRAP_QUANTITY
,      EXISTING_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SET_OF_BOOKS_ID
,      SET_OF_BOOKS_NAME
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      ORGANIZATION_NAME
,      LOCATION_ID
,      AREA_CODE
,      AREA_NAME
,      COUNTRY_CODE
,      COUNTRY_NAME
,      REGION_CODE
,      REGION_NAME
,      PERIOD_SET_NAME
,      YEAR
,      QUARTER
,      MONTH
FROM WIP.WIP_BIS_PROD_DEPT_YIELD_TEMP;

Dependencies

[top of page]

WIP.WIP_BIS_PROD_DEPT_YIELD_TEMP does not reference any database object

WIP.WIP_BIS_PROD_DEPT_YIELD_TEMP is referenced by following:

SchemaAPPS
SynonymWIP_BIS_PROD_DEPT_YIELD_TEMP