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: ViewAHL.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:

SchemaAPPS
ViewAHL_OPERATIONS_VL
SynonymAHL_OPERATION_RESOURCES
SynonymAHL_WORKORDERS
SynonymAHL_WORKORDER_OPERATIONS
SynonymBOM_RESOURCES
ViewFND_LOOKUP_VALUES_VL
ViewMFG_LOOKUPS
SynonymMTL_UNITS_OF_MEASURE
SynonymWIP_OPERATIONS
SynonymWIP_OPERATION_RESOURCES
APPS.AHL_PP_REQUIREMENT_V is referenced by following:

SchemaAPPS
ViewAHL_PP_ASSIGNMENT_V
Package BodyAHL_PP_RESRC_ASSIGN_PVT - show dependent code
Package BodyAHL_PRD_RESOURCE_TRANX_PVT - show dependent code
Package BodyAHL_PRD_UTIL_PKG - show dependent code
Package BodyAHL_VWP_PRICE_PVT - show dependent code