[Home] [Help] [Dependency Information]
Object Name: | MSD_SOP_BOM_COMP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is obsolete. This view provides the global collapsed bom comp for a SOP plan.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_INSTANCE_ID | VARCHAR2 | (30) | The source instance ID. | |
DEMAND_PLAN_ID | NUMBER | SOP Plan unique ID. | ||
SUPPLY_PLAN | VARCHAR2 | (240) | Designator name corresponding to ASCP custom stream . | |
COMPONENT_PK | NUMBER | Yes | Primary key for the component. | |
COMPONENT | VARCHAR2 | (240) | Yes | Name of the component. |
ASSEMBLY_PK | NUMBER | Yes | Primary key for the assembly. | |
ASSEMBLY_NAME | VARCHAR2 | (240) | Yes | Name of the assembly. |
EFFECTIVITY_DATE | DATE | Effective date for collapse bom structure. | ||
DISABLE_DATE | DATE | Disable date for Collapse bom structure. | ||
QUANTITY_PER | NUMBER | Capacity or usage ratio. | ||
LEAD_TIME | NUMBER | Lead Time | ||
OPTIONAL_FLAG | CHAR | (1) | Optional flag. | |
RES_COMP | VARCHAR2 | (240) | Flag to denote whether is is resource or component I- Item , R- Resource , L-Flow Resource. |
Cut, paste (and edit) the following text to query this object:
SELECT SR_INSTANCE_ID
, DEMAND_PLAN_ID
, SUPPLY_PLAN
, COMPONENT_PK
, COMPONENT
, ASSEMBLY_PK
, ASSEMBLY_NAME
, EFFECTIVITY_DATE
, DISABLE_DATE
, QUANTITY_PER
, LEAD_TIME
, OPTIONAL_FLAG
, RES_COMP
FROM APPS.MSD_SOP_BOM_COMP_V;
APPS.MSD_SOP_BOM_COMP_V is not referenced by any database object
|
|
|