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

VIEW: APPS.MRPBV_BILL_OF_RESOURCE_REQS

Object Details
Object Name: MRPBV_BILL_OF_RESOURCE_REQS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRPBV_BILL_OF_RESOURCE_REQS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows resources or repetitive lines required to build an assembly from its lowest level components.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BILL_OF_RESOURCES VARCHAR2 (10)
RESOURCE_HOURS NUMBER

RESOURCE_UNITS NUMBER

SETBACK_DAYS NUMBER

ASSEMBLY_USAGE NUMBER

OPERATION_BASIS VARCHAR2 (80)
ORIGINATION_TYPE VARCHAR2 (80)
RESOURCE_SEQUENCE_NUMBER NUMBER

OPERATION_SEQUENCE_NUMBER NUMBER

BILL_OF_RESOURCE_REQ_ID NUMBER

ORGANIZATION_ID NUMBER

ASSEMBLY_ITEM_ID NUMBER

DEPARTMENT_ID NUMBER

RESOURCE_ID NUMBER

LINE_ID NUMBER

SOURCE_ITEM_ID NUMBER

OPERATION_SEQUENCE_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

Query Text

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


SELECT BILL_OF_RESOURCES
,      RESOURCE_HOURS
,      RESOURCE_UNITS
,      SETBACK_DAYS
,      ASSEMBLY_USAGE
,      OPERATION_BASIS
,      ORIGINATION_TYPE
,      RESOURCE_SEQUENCE_NUMBER
,      OPERATION_SEQUENCE_NUMBER
,      BILL_OF_RESOURCE_REQ_ID
,      ORGANIZATION_ID
,      ASSEMBLY_ITEM_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      LINE_ID
,      SOURCE_ITEM_ID
,      OPERATION_SEQUENCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.MRPBV_BILL_OF_RESOURCE_REQS;

Dependencies

[top of page]

APPS.MRPBV_BILL_OF_RESOURCE_REQS references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymBOM_RESOURCES
SynonymCRP_RESOURCE_HOURS
ViewMFG_LOOKUPS
SynonymWIP_LINES

APPS.MRPBV_BILL_OF_RESOURCE_REQS is not referenced by any database object