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: ViewWIP.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 Mandatory 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:

SchemaAPPS
SynonymFND_USER
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewMFG_LOOKUPS
ViewORG_ORGANIZATION_DEFINITIONS
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
SynonymPJM_SEIBAN_NUMBERS
SynonymWIP_DISCRETE_JOBS
SynonymWIP_ENTITIES
SynonymWIP_JOB_SCHEDULE_INTERFACE
SynonymWIP_LINES
SynonymWIP_SCHEDULE_GROUPS

APPS.WIP_JOB_SCHEDULE_INTERFACE_V is not referenced by any database object