eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.WIP_JOB_SCHEDULE_INTERFACE_V

Object Details

Object Name:	WIP_JOB_SCHEDULE_INTERFACE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_JOB_SCHEDULE_INTERFACE_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Row identifier (internal use only)
INTERFACE_ID	NUMBER		Interface identifier
REQUEST_ID	NUMBER		Extended Who column
GROUP_ID	NUMBER		Processing group identifier
LOAD_TYPE_MEANING	VARCHAR2	(80)	Load type meaning
PROCESS_PHASE_MEANING	VARCHAR2	(80)	Process phase meaning
PROCESS_STATUS_MEANING	VARCHAR2	(80)	Process status meaning
FIRM_PLANNED_MEANING	VARCHAR2	(80)	Firm planned flag meaning
LOAD_TYPE	NUMBER		Type of interface load
PROCESS_PHASE	NUMBER		Process Phase
PROCESS_STATUS	NUMBER		Process Status
ORGANIZATION_CODE	VARCHAR2	(3)	Organization Code
JOB_NAME	VARCHAR2	(240)	WIP job name
STATUS_TYPE_MEANING	VARCHAR2	(80)	Job or repetitive schedule status meaning
CLASS_CODE	VARCHAR2	(10)	Accounting class associated with job or repetitive assembly
START_QUANTITY	NUMBER		Job start quantity
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)	Alternate bill of material used in job or schedule
BOM_REVISION	VARCHAR2	(3)	BOM revision
BOM_REVISION_DATE	DATE		Date of inventory item revision used to explode the bill of materials used in the job or schedule
WIP_SUPPLY_TYPE_MEANING	VARCHAR2	(80)	Supply type meaning
WIP_SUPPLY_TYPE	NUMBER		Method of material consumption within WIP
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(10)	Alternate routing used in a job or repetitive schedule
ROUTING_REVISION	VARCHAR2	(3)	Routing Revision
ROUTING_REVISION_DATE	DATE		Routing revision date
COMPLETION_SUBINVENTORY	VARCHAR2	(10)	Completion Subinventory
LOCATOR	VARCHAR2	(2000)	Concatenated flexfield name for the locator
FIRST_UNIT_START_DATE	DATE		Date job or repetitive schedule will start
FIRST_UNIT_COMPLETION_DATE	DATE		Date job or repetitive schedule when the first unit will be completed
LAST_UNIT_START_DATE	DATE		Date job or repetitive schedule when the last unit processing starts
LAST_UNIT_COMPLETION_DATE	DATE		Date job or repetitive schedule will end
PROCESSING_WORK_DAYS	NUMBER		Processing days of repetitive schedule
DAILY_PRODUCTION_RATE	NUMBER		Daily production rate of schedule to be created
TOTAL_QUANTITY	NUMBER		Total quantity for a repetitive schedule
SOURCE_CODE	VARCHAR2	(30)	Code of the process that generated the interface record
SOURCE_LINE_ID	NUMBER		Identifier of the source system that generated the interface record
LOT_NUMBER	VARCHAR2	(80)	Default lot number to assign to assemblies completed from the job
FIRM_PLANNED_FLAG	NUMBER		Control for MRP rescheduling
DEMAND_CLASS	VARCHAR2	(30)	Classification of demand for which the job or schedule will supply
DESCRIPTION	VARCHAR2	(240)	Descriptive text
LAST_UPDATED_BY_NAME	VARCHAR2	(100)	Last updated by name
CREATED_BY_NAME	VARCHAR2	(100)	Created by name
SCHEDULE_GROUP_NAME	VARCHAR2	(30)	Schedule Group name
BUILD_SEQUENCE	NUMBER		Build sequence
PROJECT_NUMBER	VARCHAR2	(25)	Project Number
TASK_NUMBER	VARCHAR2	(25)	Task number
LINE_CODE	VARCHAR2	(10)	WIP line code
NET_QUANTITY	NUMBER		Job net quantity
SCHEDULING_METHOD	NUMBER		Methods of scheduling the discrete job or repetitive schedule
SCHEDULING_METHOD_MEANING	VARCHAR2	(80)	Scheduling methods meaning
STATUS_TYPE	NUMBER		Status of the job or repetitive schedule to be loaded
LAST_UPDATED_BY	NUMBER		Standard Who column
CREATED_BY	NUMBER		Standard Who column
ORGANIZATION_ID	NUMBER		Organization identifier
LINE_ID	NUMBER		WIP line identifier
PRIMARY_ITEM_ID	NUMBER		Inventory item identifier of the assembly the job or repetitive schedule creates
WIP_ENTITY_ID	NUMBER		WIP job or repetitive assembly identifier
REPETITIVE_SCHEDULE_ID	NUMBER		WIP repetitive schedule identifier
BOM_REFERENCE_ID	NUMBER		Assembly identifier used as bill of material reference for explosions of nonstandard job
ROUTING_REFERENCE_ID	NUMBER		Assembly identifier used as routing reference for scheduling of nonstandard job
COMPLETION_LOCATOR_ID	NUMBER		Completion Locator Id
SCHEDULE_GROUP_ID	NUMBER		Schedule Group ID
PROJECT_ID	NUMBER		Project ID
TASK_ID	NUMBER		Task ID
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)	Assembly unit number identifier to support Project Manufacturing in Model Unit Effectivity.
LAST_UPDATE_DATE	DATE		Standard Who column
CREATION_DATE	DATE		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
PROGRAM_ID	NUMBER		Extended Who column
PROGRAM_APPLICATION_ID	NUMBER		Extended Who column
PROGRAM_UPDATE_DATE	DATE		Extended Who column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)	Descriptive flexfield segment
ASSET_NUMBER	VARCHAR2	(30)
ASSET_GROUP_ID	NUMBER
REBUILD_ITEM_ID	NUMBER
SERIAL_NUMBER	VARCHAR2	(30)
ENTITY_TYPE	NUMBER

Query Text

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


SELECT ROW_ID
,      INTERFACE_ID
,      REQUEST_ID
,      GROUP_ID
,      LOAD_TYPE_MEANING
,      PROCESS_PHASE_MEANING
,      PROCESS_STATUS_MEANING
,      FIRM_PLANNED_MEANING
,      LOAD_TYPE
,      PROCESS_PHASE
,      PROCESS_STATUS
,      ORGANIZATION_CODE
,      JOB_NAME
,      STATUS_TYPE_MEANING
,      CLASS_CODE
,      START_QUANTITY
,      ALTERNATE_BOM_DESIGNATOR
,      BOM_REVISION
,      BOM_REVISION_DATE
,      WIP_SUPPLY_TYPE_MEANING
,      WIP_SUPPLY_TYPE
,      ALTERNATE_ROUTING_DESIGNATOR
,      ROUTING_REVISION
,      ROUTING_REVISION_DATE
,      COMPLETION_SUBINVENTORY
,      LOCATOR
,      FIRST_UNIT_START_DATE
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UNIT_START_DATE
,      LAST_UNIT_COMPLETION_DATE
,      PROCESSING_WORK_DAYS
,      DAILY_PRODUCTION_RATE
,      TOTAL_QUANTITY
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      LOT_NUMBER
,      FIRM_PLANNED_FLAG
,      DEMAND_CLASS
,      DESCRIPTION
,      LAST_UPDATED_BY_NAME
,      CREATED_BY_NAME
,      SCHEDULE_GROUP_NAME
,      BUILD_SEQUENCE
,      PROJECT_NUMBER
,      TASK_NUMBER
,      LINE_CODE
,      NET_QUANTITY
,      SCHEDULING_METHOD
,      SCHEDULING_METHOD_MEANING
,      STATUS_TYPE
,      LAST_UPDATED_BY
,      CREATED_BY
,      ORGANIZATION_ID
,      LINE_ID
,      PRIMARY_ITEM_ID
,      WIP_ENTITY_ID
,      REPETITIVE_SCHEDULE_ID
,      BOM_REFERENCE_ID
,      ROUTING_REFERENCE_ID
,      COMPLETION_LOCATOR_ID
,      SCHEDULE_GROUP_ID
,      PROJECT_ID
,      TASK_ID
,      END_ITEM_UNIT_NUMBER
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ASSET_NUMBER
,      ASSET_GROUP_ID
,      REBUILD_ITEM_ID
,      SERIAL_NUMBER
,      ENTITY_TYPE
FROM APPS.WIP_JOB_SCHEDULE_INTERFACE_V;

Dependencies

[top of page]

APPS.WIP_JOB_SCHEDULE_INTERFACE_V references the following:

APPS: FND_USER; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MFG_LOOKUPS; ORG_ORGANIZATION_DEFINITIONS; PA_PROJECTS_ALL; PA_TASKS; PJM_SEIBAN_NUMBERS; WIP_DISCRETE_JOBS; WIP_ENTITIES; WIP_JOB_SCHEDULE_INTERFACE; WIP_LINES; WIP_SCHEDULE_GROUPS

APPS.WIP_JOB_SCHEDULE_INTERFACE_V is not referenced by any database object