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

VIEW: APPS.BOMBV_STD_OPRATN_RESOURCES

Object Details
Object Name: BOMBV_STD_OPRATN_RESOURCES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOMBV_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 operation that is included in at least one routing steps in order
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 (62)

_LA:BASIS_TYPE CHAR (47)

_LA:SCHEDULE_FLAG CHAR (51)

_LA:STANDARD_RATE_FLAG CHAR (56)

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
,      STANDARD_OPERATION_ID
,      RESOURCE_ID
,      ACTIVITY_ID
,      UPDATED_ON
,      UPDATED_BY
,      CREATED_ON
,      CREATED_BY
FROM APPS.BOMBV_STD_OPRATN_RESOURCES;

Dependencies

[top of page]

APPS.BOMBV_STD_OPRATN_RESOURCES references the following:

SchemaAPPS
SynonymBOM_STANDARD_OPERATIONS
SynonymBOM_STD_OP_RESOURCES
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS

APPS.BOMBV_STD_OPRATN_RESOURCES is not referenced by any database object