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

VIEW: APPS.BOMFV_STD_OPRATN_RESOURCES

Object Details
Object Name: BOMFV_STD_OPRATN_RESOURCES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOMFV_STD_OPRATN_RESOURCES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about resources which are used by a basic or
typical operationthat is included in at least one routing step used to
build an assembly.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_SEQUENCE_NUMBER NUMBER
Yes
ORGANIZATION_CODE VARCHAR2 (3)

ORGANIZATION_NAME VARCHAR2 (240) Yes
OPERATION_CODE VARCHAR2 (4) Yes
USAGE_RATE_OR_AMOUNT NUMBER
Yes
INVERSE_RATE_OR_AMOUNT NUMBER
Yes
ASSIGNED_UNITS NUMBER


_LA:AUTOCHARGE_TYPE CHAR (63)

_LA:BASIS_TYPE CHAR (48)

_LA:SCHEDULE_FLAG CHAR (52)

_LA:STANDARD_RATE_FLAG CHAR (57)

ACTIVITY VARCHAR2 (10)

RESOURCE_CODE VARCHAR2 (10) Yes
STANDARD_OPERATION_ID NUMBER
Yes
RESOURCE_ID NUMBER
Yes
ACTIVITY_ID NUMBER


UPDATED_ON DATE
Yes
UPDATED_BY NUMBER
Yes
CREATED_ON DATE
Yes
CREATED_BY NUMBER
Yes
Query Text

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


SELECT RESOURCE_SEQUENCE_NUMBER
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      OPERATION_CODE
,      USAGE_RATE_OR_AMOUNT
,      INVERSE_RATE_OR_AMOUNT
,      ASSIGNED_UNITS
,      _LA:AUTOCHARGE_TYPE
,      _LA:BASIS_TYPE
,      _LA:SCHEDULE_FLAG
,      _LA:STANDARD_RATE_FLAG
,      ACTIVITY
,      RESOURCE_CODE
,      STANDARD_OPERATION_ID
,      RESOURCE_ID
,      ACTIVITY_ID
,      UPDATED_ON
,      UPDATED_BY
,      CREATED_ON
,      CREATED_BY
FROM APPS.BOMFV_STD_OPRATN_RESOURCES;

Dependencies

[top of page]

APPS.BOMFV_STD_OPRATN_RESOURCES references the following:

SchemaAPPS
SynonymBOM_RESOURCES
SynonymBOM_STANDARD_OPERATIONS
SynonymBOM_STD_OP_RESOURCES
SynonymCST_ACTIVITIES
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS

APPS.BOMFV_STD_OPRATN_RESOURCES is not referenced by any database object