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


VIEW: APPS.WIPFV_WIP_JOBS

Object Details
Object Name: WIPFV_WIP_JOBS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIPFV_WIP_JOBS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about discrete jobs. Job information includes the assembly being built, the revision of the assembly, the job quantity, the status of the job, the material control method, the job start and end dates, and the WIP accounting class.


[View Source]

Columns
Name Datatype Length Mandatory Comments
MFG_ORDER_NAME VARCHAR2 (240) Yes
_LA:JOB_STATUS CHAR (53)
_LA:FIRMED_PLANNED_FLAG CHAR (55)
_LA:JOB_TYPE CHAR (52)
_LA:WIP_SUPPLY_TYPE CHAR (53)
SCHEDULED_START_DATE DATE
Yes
SCHEDULED_COMPLETION_DATE DATE
Yes
START_QUANTITY NUMBER
Yes
RELEASE_DATE DATE

COMPLETION_DATE DATE

CLOSED_DATE DATE

QUANTITY_COMPLETED NUMBER
Yes
QUANTITY_SCRAPPED NUMBER
Yes
MRP_NET_QUANTITY NUMBER
Yes
BOM_REVISION_DATE DATE

ROUTING_REVISION_DATE DATE

LOT_NUMBER VARCHAR2 (80)
ALTERNATE_BOM VARCHAR2 (10)
ALTERNATE_ROUTING VARCHAR2 (10)
BUILD_SEQUENCE NUMBER

DEMAND_CLASS VARCHAR2 (30)
PO_CREATION_TIME CHAR (64)
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
_LA:OVERCOMP_TOLERANCE_TYPE CHAR (75)
OVERCOMPLETION_TOLERANCE_VALUE NUMBER

JOB_DESCRIPTION VARCHAR2 (240)
ORGANIZATION_CODE VARCHAR2 (3)
ORGANIZATION_NAME VARCHAR2 (240) Yes
_KF:ITEM_NUMBER CHAR (16)
_KF:ITEM_NUMBE:BOM_REFERENCE CHAR (16)
_KF:ITEM_NAME:RTG_REFERENCE CHAR (16)
_KF:ITEM_NUMBER:COMMON_BOM CHAR (16)
_KF:ITEM_NUMBER:COMMON_RTG CHAR (16)
LOCATOR_NAME VARCHAR2 (50)
SCHEDULE_GROUP_NAME VARCHAR2 (30)
LINE_NAME VARCHAR2 (10)
PROJECT_NUMBER VARCHAR2 (25)
PROJECT_NAME VARCHAR2 (30)
TASK_NUMBER VARCHAR2 (25)
TASK_NAME VARCHAR2 (20)
KANBAN_CARD_NUMBER VARCHAR2 (30)
_KF:ACCT:MATERIAL:_CO CHAR (17)
_KF:ACCT:MATERIAL_OVHD:_CO CHAR (17)
_KF:ACCT:RESOURCE:_CO CHAR (17)
_KF:ACCT:OUT_PROCESS:_CO CHAR (17)
_KF:ACCT:MATERIAL_VAR:_CO CHAR (17)
_KF:ACCT:RESOURCE_VAR:_CO CHAR (17)
_KF:ACCT:OUT_PROC_VAR:_CO CHAR (17)
_KF:ACCT:STD_CST_ADJUST:_CO CHAR (17)
_KF:ACCT:OVERHEAD:_CO CHAR (17)
_KF:ACCT:OVERHEAD_VAR:_CO CHAR (18)
_DF CHAR (28)
WIP_ENTITY_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
PRIMARY_ITEM_ID NUMBER

CLASS_CODE VARCHAR2 (10) Yes
BOM_REFERENCE_ID NUMBER

ROUTING_REFERENCE_ID NUMBER

COMMON_BOM_SEQUENCE_ID NUMBER

COMMON_ROUTING_SEQUENCE_ID NUMBER

BOM_REVISION VARCHAR2 (3)
ROUTING_REVISION VARCHAR2 (3)
COMPLETION_SUBINVENTORY VARCHAR2 (10)
COMPLETION_LOCATIOR_ID NUMBER

SCHEDULE_GROUP_ID NUMBER

LINE_ID NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

KANBAN_CARD_ID NUMBER

MATERIAL_ACCOUNT NUMBER

MATERIAL_OVERHEAD_ACCOUNT NUMBER

RESOURCE_ACCOUNT NUMBER

OUTSIDE_PROCESSING_ACCOUNT NUMBER

MATERIAL_VARIANCE_ACCOUNT NUMBER

RESOURCE_VARIANCE_ACCOUNT NUMBER

OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER

STD_COST_ADJUSTMENT_ACCOUNT NUMBER

OVERHEAD_ACCOUNT NUMBER

OVERHEAD_VARIANCE_ACCOUNT NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
UPDATED_BY NUMBER
Yes
Query Text

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


SELECT MFG_ORDER_NAME
,      _LA:JOB_STATUS
,      _LA:FIRMED_PLANNED_FLAG
,      _LA:JOB_TYPE
,      _LA:WIP_SUPPLY_TYPE
,      SCHEDULED_START_DATE
,      SCHEDULED_COMPLETION_DATE
,      START_QUANTITY
,      RELEASE_DATE
,      COMPLETION_DATE
,      CLOSED_DATE
,      QUANTITY_COMPLETED
,      QUANTITY_SCRAPPED
,      MRP_NET_QUANTITY
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      LOT_NUMBER
,      ALTERNATE_BOM
,      ALTERNATE_ROUTING
,      BUILD_SEQUENCE
,      DEMAND_CLASS
,      PO_CREATION_TIME
,      END_ITEM_UNIT_NUMBER
,      _LA:OVERCOMP_TOLERANCE_TYPE
,      OVERCOMPLETION_TOLERANCE_VALUE
,      JOB_DESCRIPTION
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      _KF:ITEM_NUMBER
,      _KF:ITEM_NUMBE:BOM_REFERENCE
,      _KF:ITEM_NAME:RTG_REFERENCE
,      _KF:ITEM_NUMBER:COMMON_BOM
,      _KF:ITEM_NUMBER:COMMON_RTG
,      LOCATOR_NAME
,      SCHEDULE_GROUP_NAME
,      LINE_NAME
,      PROJECT_NUMBER
,      PROJECT_NAME
,      TASK_NUMBER
,      TASK_NAME
,      KANBAN_CARD_NUMBER
,      _KF:ACCT:MATERIAL:_CO
,      _KF:ACCT:MATERIAL_OVHD:_CO
,      _KF:ACCT:RESOURCE:_CO
,      _KF:ACCT:OUT_PROCESS:_CO
,      _KF:ACCT:MATERIAL_VAR:_CO
,      _KF:ACCT:RESOURCE_VAR:_CO
,      _KF:ACCT:OUT_PROC_VAR:_CO
,      _KF:ACCT:STD_CST_ADJUST:_CO
,      _KF:ACCT:OVERHEAD:_CO
,      _KF:ACCT:OVERHEAD_VAR:_CO
,      _DF
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      PRIMARY_ITEM_ID
,      CLASS_CODE
,      BOM_REFERENCE_ID
,      ROUTING_REFERENCE_ID
,      COMMON_BOM_SEQUENCE_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      BOM_REVISION
,      ROUTING_REVISION
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATIOR_ID
,      SCHEDULE_GROUP_ID
,      LINE_ID
,      PROJECT_ID
,      TASK_ID
,      KANBAN_CARD_ID
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      MATERIAL_VARIANCE_ACCOUNT
,      RESOURCE_VARIANCE_ACCOUNT
,      OUTSIDE_PROC_VARIANCE_ACCOUNT
,      STD_COST_ADJUSTMENT_ACCOUNT
,      OVERHEAD_ACCOUNT
,      OVERHEAD_VARIANCE_ACCOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      UPDATED_BY
FROM APPS.WIPFV_WIP_JOBS;

Dependencies

[top of page]

APPS.WIPFV_WIP_JOBS references the following:

SchemaAPPS
ViewBOM_BILL_OF_MATERIALS
SynonymBOM_OPERATIONAL_ROUTINGS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_CODE_COMBINATIONS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_ITEM_REVISIONS
SynonymMTL_KANBAN_CARDS
SynonymMTL_PARAMETERS
SynonymMTL_RTG_ITEM_REVISIONS
SynonymMTL_SECONDARY_INVENTORIES
SynonymMTL_SYSTEM_ITEMS
SynonymPA_TASKS
ViewPJMFV_PROJECT_MFG_PROJECTS
SynonymPJM_UNIT_NUMBERS
SynonymWIP_ACCOUNTING_CLASSES
SynonymWIP_DISCRETE_JOBS
SynonymWIP_ENTITIES
SynonymWIP_LINES
SynonymWIP_SCHEDULE_GROUPS

APPS.WIPFV_WIP_JOBS is not referenced by any database object