[Home] [Help] [Dependency Information]
Object Name: | MSC_WIP_JOB_COMPONENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSC.MSC_WIP_JOB_COMPONENTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains requests to add/delete/modify material for existing discrete jobs or repetitive schedules. This view is used in XML outbound
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_HEADER_ID | NUMBER | Identifies this row's parent in JOB_SCHEDULE_INTERFACE | ||
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (7) | Organization Code | |
OPERATION_SEQ_NUM | NUMBER | Operation sequence number | ||
OPERATION_SEQ_ID | NUMBER | Operation sequence id | ||
OPERATION_SEQ_CODE | VARCHAR2 | (4000) | Operation sequence code | |
INVENTORY_ITEM_ID_NEW | NUMBER | New material requirement identifier | ||
ITEM_NAME_NEW | VARCHAR2 | (4000) | Item name | |
QUANTITY_PER_ASSEMBLY | NUMBER | Part usage quantity | ||
DEPARTMENT_ID | NUMBER | Department Identifier | ||
DEPARTMENT_CODE | VARCHAR2 | (4000) | Department Code | |
WIP_SUPPLY_TYPE | NUMBER | Method of material consumption within WIP | ||
DATE_REQUIRED | DATE | Operation requirement start date | ||
REQUIRED_QUANTITY | NUMBER | Required Quantity | ||
QUANTITY_ISSUED | NUMBER | Issued Quantity | ||
UOM_CODE | VARCHAR2 | (3) | Unit of measure | |
SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Supply Subinventory | |
SUPPLY_LOCATOR_ID | NUMBER | Locator used to supply component to WIP | ||
SR_INSTANCE_ID | NUMBER | Source Instance id | ||
INSTANCE_CODE | VARCHAR2 | (3) | Yes | Source instance code |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_HEADER_ID
, ORGANIZATION_ID
, ORGANIZATION_CODE
, OPERATION_SEQ_NUM
, OPERATION_SEQ_ID
, OPERATION_SEQ_CODE
, INVENTORY_ITEM_ID_NEW
, ITEM_NAME_NEW
, QUANTITY_PER_ASSEMBLY
, DEPARTMENT_ID
, DEPARTMENT_CODE
, WIP_SUPPLY_TYPE
, DATE_REQUIRED
, REQUIRED_QUANTITY
, QUANTITY_ISSUED
, UOM_CODE
, SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID
, SR_INSTANCE_ID
, INSTANCE_CODE
FROM APPS.MSC_WIP_JOB_COMPONENTS_V;
APPS.MSC_WIP_JOB_COMPONENTS_V is not referenced by any database object
|
|
|