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

TABLE: WIP.WIP_BIS_PROD_ASSY_YIELD_TEMP

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


Temporary table that contains information about completions and scrap transactions with reference to a job and assembly.


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.
TRANSACTION_DATE DATE

Date the transaction takes place.
COMPLETED_QUANTITY NUMBER

Total number of distinct assemblies completed 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.
CATEGORY_ID NUMBER

Identifies the category that the item belongs to.
CATEGORY_NAME VARCHAR2 (163)
Name of category item belongs to.
INVENTORY_ITEM_NAME VARCHAR2 (40)
Name of assembly inventory item job or schedule creates.
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
,      TRANSACTION_DATE
,      COMPLETED_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
,      CATEGORY_ID
,      CATEGORY_NAME
,      INVENTORY_ITEM_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_ASSY_YIELD_TEMP;

Dependencies

[top of page]

WIP.WIP_BIS_PROD_ASSY_YIELD_TEMP does not reference any database object

WIP.WIP_BIS_PROD_ASSY_YIELD_TEMP is referenced by following:

SchemaWIP
ViewWIP_BIS_PROD_ASSY_YIELD_TEMP#