[Home] [Help]
[Dependency Information]
VIEW: APPS.MSD_DEM_AVAIL_SUPPLIER_CAP_V
Object Details
Object Name: | MSD_DEM_AVAIL_SUPPLIER_CAP_V |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
PLAN_ID |
NUMBER |
|
Yes |
|
SUPPLY_PLAN |
VARCHAR2 |
(10) |
Yes |
|
ORG_CODE |
VARCHAR2 |
(7) |
|
|
ITEM_CODE |
VARCHAR2 |
(250) |
|
|
SITE_CODE |
VARCHAR2 |
(286) |
|
|
QUANTITY |
NUMBER |
|
|
|
SDATE |
DATE |
|
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, SUPPLY_PLAN
, ORG_CODE
, ITEM_CODE
, SITE_CODE
, QUANTITY
, SDATE
FROM APPS.MSD_DEM_AVAIL_SUPPLIER_CAP_V;
Dependencies
[top of page]
APPS.MSD_DEM_AVAIL_SUPPLIER_CAP_V references the following:
-
APPS
-
FND_PROFILE
- show dependent code
-
MSC_CALENDAR_DATES
-
MSC_ITEM_SOURCING
-
MSC_ITEM_SUPPLIERS
-
MSC_PLANS
-
MSC_SUPPLIER_CAPACITIES
-
MSC_SUPPLIES
-
MSC_SYSTEM_ITEMS
-
MSC_TRADING_PARTNERS
-
MSC_TRADING_PARTNER_SITES
-
MSD_DEM_COMMON_UTILITIES
- show dependent code
-
PUBLIC
-
DUAL
-
-
APPS.MSD_DEM_AVAIL_SUPPLIER_CAP_V is not referenced by any database object