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

VIEW: APPS.MRP_SC_BILL_BOM_V

Object Details
Object Name: MRP_SC_BILL_BOM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_SC_BILL_BOM_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
ASSEMBLY_ITEM_ORG VARCHAR2 (44)
Assembly item organization
COMPONENT_ITEM_ORG VARCHAR2 (86)
Component item organization
ASSIGNMENT_SET_ID NUMBER
Yes Assignment set identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ITEM_NAME VARCHAR2 (40)
Item name
OPERATION_SEQ_NUM NUMBER
Yes Manufacturing operation sequence number
COMPONENT_ITEM_ID NUMBER

Component item identifier
COMPONENT_NAME VARCHAR2 (40)
Component name
EFFECTIVE_DATE DATE
Yes Effective date
USAGE NUMBER
Yes Usage quantity
Query Text

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


SELECT ASSEMBLY_ITEM_ORG
,      COMPONENT_ITEM_ORG
,      ASSIGNMENT_SET_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      INVENTORY_ITEM_ID
,      ITEM_NAME
,      OPERATION_SEQ_NUM
,      COMPONENT_ITEM_ID
,      COMPONENT_NAME
,      EFFECTIVE_DATE
,      USAGE
FROM APPS.MRP_SC_BILL_BOM_V;

Dependencies

[top of page]

APPS.MRP_SC_BILL_BOM_V references the following:

SchemaAPPS
ViewBOM_BILL_OF_MATERIALS
SynonymBOM_CALENDAR_DATES
ViewBOM_INVENTORY_COMPONENTS
SynonymENG_REVISED_ITEMS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymMRP_ASSIGNMENT_SETS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.MRP_SC_BILL_BOM_V is not referenced by any database object