[Home] [Help] [Dependency Information]
Object Name: | MSC_SUPPLIES_OUTBOUND_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSC.MSC_SUPPLIES_OUTBOUND_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view lists all the supplies for the plan. This view is used in XML-outbound
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_INSTANCE_ID | NUMBER | Yes | Source application instance identifier of the item org | |
PLAN_ID | NUMBER | Yes | Plan identifier | |
TRANSACTION_ID | NUMBER | Yes | Unique identifier for the row | |
ORGANIZATION_ID | NUMBER | Yes | Organization ID | |
ORGANIZATION_CODE | VARCHAR2 | (7) | Organization Code | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ITEM_NAME | VARCHAR2 | (250) | Item Name | |
REVISION | VARCHAR2 | (10) | Inventory item revision code | |
UNIT_NUMBER | VARCHAR2 | (30) | Unit number of the item | |
STATUS | VARCHAR2 | (6) | Attribute used for online replanning | |
NEW_SCHEDULE_DATE | DATE | Yes | End date of the supply (Completion date of first unit) | |
LAST_UNIT_START_DATE | DATE | Last unit start date for recommended repetitive schedule | ||
ORDER_QUANTITY | NUMBER | Quantity ordered | ||
OLD_ORDER_QUANTITY | NUMBER | Old supply quantity | ||
LINE_TYPE | NUMBER | Implement order type None (1), Purchase requisition (2), Discrete job (3) | ||
SUPPLIER_ID | NUMBER | Supplier identifier | ||
SUPPLIER_NAME | VARCHAR2 | (4000) | Supplier name | |
SUPPLIER_SITE_ID | NUMBER | Supplier site identifier | ||
SUPPLIER_SITE_CODE | VARCHAR2 | (4000) | Supplier site code | |
IMPLEMENTED_QUANTITY | VARCHAR2 | (1) | Planned order implemented quantity | |
FIRM_PLANNED_TYPE | NUMBER | Yes | Flag indicating whether the order is firm | |
FIRM_FLAG | VARCHAR2 | (3) | Flag to indicate the status of FIRM_PLANNED_TYPE. If FIRM_PLANNED_TYPE is 1 then it returns 'yes' otherwise 'no' | |
RELEASE_STATUS | NUMBER | Flag indicating release status | ||
NEW_SHIP_DATE | DATE | New ship date | ||
PROJECT_ID | NUMBER | (15) | Project identifier | |
PROJECT_NUMBER | VARCHAR2 | (4000) | Project number | |
TASK_ID | NUMBER | (15) | Task identifier | |
TASK_NUMBER | VARCHAR2 | (4000) | Task number | |
PLANNING_GROUP | VARCHAR2 | (30) | Project planning group | |
DEMAND_CLASS | VARCHAR2 | (34) | Demand class code | |
UOM_CODE | VARCHAR2 | (3) | Yes | UOM code |
SOURCE_SUPPLIER_ID | NUMBER | Source supplier identifier | ||
SOURCE_SUPPLIER_SITE_ID | NUMBER | Source supplier site identifier |
Cut, paste (and edit) the following text to query this object:
SELECT SR_INSTANCE_ID
, PLAN_ID
, TRANSACTION_ID
, ORGANIZATION_ID
, ORGANIZATION_CODE
, INVENTORY_ITEM_ID
, ITEM_NAME
, REVISION
, UNIT_NUMBER
, STATUS
, NEW_SCHEDULE_DATE
, LAST_UNIT_START_DATE
, ORDER_QUANTITY
, OLD_ORDER_QUANTITY
, LINE_TYPE
, SUPPLIER_ID
, SUPPLIER_NAME
, SUPPLIER_SITE_ID
, SUPPLIER_SITE_CODE
, IMPLEMENTED_QUANTITY
, FIRM_PLANNED_TYPE
, FIRM_FLAG
, RELEASE_STATUS
, NEW_SHIP_DATE
, PROJECT_ID
, PROJECT_NUMBER
, TASK_ID
, TASK_NUMBER
, PLANNING_GROUP
, DEMAND_CLASS
, UOM_CODE
, SOURCE_SUPPLIER_ID
, SOURCE_SUPPLIER_SITE_ID
FROM APPS.MSC_SUPPLIES_OUTBOUND_V;
APPS.MSC_SUPPLIES_OUTBOUND_V is not referenced by any database object
|
|
|