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

Object Details

Object Name:	AHL_PP_REQUIREMENT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_PP_REQUIREMENT_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
REQUIREMENT_ID	NUMBER		Yes
RESOURCE_ID	NUMBER		Yes
OBJECT_VERSION_NUMBER	NUMBER		Yes
RESOURCE_CODE	VARCHAR2	(10)	Yes
RESOURCE_NAME	VARCHAR2	(240)
RESOURCE_SEQUENCE	NUMBER		Yes
JOB_ID	NUMBER		Yes
OPERATION_ID	NUMBER		Yes
OPERATION_SEQUENCE	NUMBER		Yes
OPERATION_STATUS_CODE	VARCHAR2	(30)	Yes
OPERATION_START_DATE	DATE		Yes
OPERATION_END_DATE	DATE		Yes
REQUIRED_START_DATE	DATE		Yes
REQUIRED_END_DATE	DATE		Yes
RESOURCE_TYPE_CODE	NUMBER
RESOURCE_TYPE_NAME	VARCHAR2	(80)
DURATION	NUMBER
UOM_CODE	VARCHAR2	(3)
UOM_NAME	VARCHAR2	(25)
QUANTITY	NUMBER
TOTAL_REQUIRED	NUMBER		Yes
OPERATION_CODE	CHAR	(1)
STATUS	VARCHAR2	(80)
VISIT_TASK_ID	NUMBER			Identifier for visit task id
JOB_STATUS_CODE	VARCHAR2	(30)	Yes	Identifier for job status code
JOB_STATUS_MEANING	VARCHAR2	(80)		Identifier for job status meaning
DEPARTMENT_ID	NUMBER		Yes	Department ID.
SCHEDULE_SEQ_NUM	NUMBER			Schedule Seq Num

Query Text

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


SELECT REQUIREMENT_ID
,      RESOURCE_ID
,      OBJECT_VERSION_NUMBER
,      RESOURCE_CODE
,      RESOURCE_NAME
,      RESOURCE_SEQUENCE
,      JOB_ID
,      OPERATION_ID
,      OPERATION_SEQUENCE
,      OPERATION_STATUS_CODE
,      OPERATION_START_DATE
,      OPERATION_END_DATE
,      REQUIRED_START_DATE
,      REQUIRED_END_DATE
,      RESOURCE_TYPE_CODE
,      RESOURCE_TYPE_NAME
,      DURATION
,      UOM_CODE
,      UOM_NAME
,      QUANTITY
,      TOTAL_REQUIRED
,      OPERATION_CODE
,      STATUS
,      VISIT_TASK_ID
,      JOB_STATUS_CODE
,      JOB_STATUS_MEANING
,      DEPARTMENT_ID
,      SCHEDULE_SEQ_NUM
FROM APPS.AHL_PP_REQUIREMENT_V;

Dependencies

[top of page]

APPS.AHL_PP_REQUIREMENT_V references the following:

APPS: AHL_OPERATIONS_VL; AHL_OPERATION_RESOURCES; AHL_WORKORDERS; AHL_WORKORDER_OPERATIONS; BOM_RESOURCES; FND_LOOKUP_VALUES_VL; MFG_LOOKUPS; MTL_UNITS_OF_MEASURE; WIP_OPERATIONS; WIP_OPERATION_RESOURCES

APPS.AHL_PP_REQUIREMENT_V is referenced by following:

APPS: AHL_PP_ASSIGNMENT_V; AHL_PP_RESRC_ASSIGN_PVT - show dependent code; AHL_PRD_RESOURCE_TRANX_PVT - show dependent code; AHL_PRD_UTIL_PKG - show dependent code; AHL_VWP_PRICE_PVT - show dependent code