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.CRP_FORM_QUERY_V

Object Details

Object Name:	CRP_FORM_QUERY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CRP.CRP_FORM_QUERY_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier
QUERY_ID	NUMBER		Yes	Query identifier
ORGANIZATION_ID	NUMBER			Organization identifier
DEPARTMENT_CODE	VARCHAR2	(10)		Department code
DEPARTMENT_ID	NUMBER			Department identifier
RESOURCE_CODE	VARCHAR2	(10)		Resource code
RESOURCE_ID	NUMBER			Resource identifier
LINE_CODE	VARCHAR2	(10)		Line name
LINE_ID	NUMBER			WIP line identifier
RESOURCE_START_DATE	DATE			Start date of resource requirement
RESOURCE_END_DATE	DATE			End date of resource requirement
SCHEDULE_START_DATE	DATE			Start date of the supply entry
RATE_END_DATE	DATE			Repetitive production rate end date
OP_SEQ_NUMBER	VARCHAR2	(255)		Operation sequence number
FIRM	NUMBER			Supply firm type
REQUIRED_HOURS	NUMBER			Resource hours required
LOAD_RATE	NUMBER			Load rate for repetitive schedules
DAILY_RESOURCE_HOURS	NUMBER			Daily available resource hours
SCHEDULE_QUANTITY	NUMBER			Schedule quantity
DAILY_RATE	NUMBER			Daily production rate for repetitive schedules
ORDER_TYPE	VARCHAR2	(80)		Order type
REQUIREMENT_TYPE	VARCHAR2	(80)		Resource requirement type
ORDER_NUMBER	VARCHAR2	(240)		Order number
USING_ASSEMBLY	VARCHAR2	(40)		Assembly for which the supply is defined
SOURCE_ITEM	VARCHAR2	(40)		The item that generated the resource requirement
ASSEMBLY_ITEM_ID	NUMBER			Assembly item identifier
SOURCE_ITEM_ID	NUMBER			Source item identifier
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			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column

Query Text

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


SELECT ROW_ID
,      QUERY_ID
,      ORGANIZATION_ID
,      DEPARTMENT_CODE
,      DEPARTMENT_ID
,      RESOURCE_CODE
,      RESOURCE_ID
,      LINE_CODE
,      LINE_ID
,      RESOURCE_START_DATE
,      RESOURCE_END_DATE
,      SCHEDULE_START_DATE
,      RATE_END_DATE
,      OP_SEQ_NUMBER
,      FIRM
,      REQUIRED_HOURS
,      LOAD_RATE
,      DAILY_RESOURCE_HOURS
,      SCHEDULE_QUANTITY
,      DAILY_RATE
,      ORDER_TYPE
,      REQUIREMENT_TYPE
,      ORDER_NUMBER
,      USING_ASSEMBLY
,      SOURCE_ITEM
,      ASSEMBLY_ITEM_ID
,      SOURCE_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.CRP_FORM_QUERY_V;

Dependencies

[top of page]

APPS.CRP_FORM_QUERY_V references the following:

APPS: BOM_DEPARTMENTS; BOM_RESOURCES; CRP_FORM_QUERY; MFG_LOOKUPS; MTL_ITEM_FLEXFIELDS; WIP_ENTITIES; WIP_LINES

APPS.CRP_FORM_QUERY_V is not referenced by any database object