[Home] [Help] [Dependency Information]
Object Name: | MRP_SCATP_SUPPLY_SOURCES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_SCATP_SUPPLY_SOURCES_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | Session identifier | ||
SCHEDULE_GROUP_ID | NUMBER | Schedule group identifier | ||
ATP_GROUP_ID | NUMBER | Identifies a group of items and/or resources that will be passed to the ATP function as a group | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
SHIP_METHOD | VARCHAR2 | (30) | Ship method | |
SHIP_METHOD_TEXT | VARCHAR2 | (80) | Ship method description | |
INTRANSIT_LEAD_TIME | NUMBER | Intransit lead time | ||
VENDOR_ID | NUMBER | Supplier identifier | ||
VENDOR_NAME | VARCHAR2 | (240) | Supplier name | |
VENDOR_SITE_ID | NUMBER | Supplier site identifier | ||
VENDOR_SITE_CODE | VARCHAR2 | (15) | Supplier site code | |
GROUP_AVAILABLE_DATE | DATE | The earliest date that all the requested quantity for each item/resource in the group can be satisfied | ||
GROUP_ATP_CHECK | NUMBER | Flag to indicate if all the items under the same group id will be treated as a group ATP (i.e. return the same GROUP_AVAILABLE_DATE) |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, SCHEDULE_GROUP_ID
, ATP_GROUP_ID
, ORGANIZATION_ID
, ORGANIZATION_CODE
, SHIP_METHOD
, SHIP_METHOD_TEXT
, INTRANSIT_LEAD_TIME
, VENDOR_ID
, VENDOR_NAME
, VENDOR_SITE_ID
, VENDOR_SITE_CODE
, GROUP_AVAILABLE_DATE
, GROUP_ATP_CHECK
FROM APPS.MRP_SCATP_SUPPLY_SOURCES_V;
APPS.MRP_SCATP_SUPPLY_SOURCES_V is not referenced by any database object
|
|
|