[Home] [Help] [Dependency Information]
Object Name: | MRP_PO_SUPPLY_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_PO_SUPPLY_VIEW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
COMPILE_DESIGNATOR | VARCHAR2 | (10) | MPS, MRP or DRP plan identifier | |
MPS_ORGANIZATION_ID | NUMBER | MPS organization identifier | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
SUPPLY_HEADER_ID | NUMBER | Supply header identifier | ||
VENDOR_ID | NUMBER | Supplier identifier | ||
SUPPLY_TYPE | NUMBER | Supply type | ||
MPS_DELIVERY_SCHEDULE_DATE | DATE | MPS delivery schedule date | ||
DELIVERY_SCHEDULE_DATE | DATE | PO expected delivery date | ||
MPS_SUPPLY_QUANTITY | NUMBER | MPS supply quantity | ||
SUPPLY_QUANTITY | NUMBER | PO supply quantity | ||
MPS_SUPPLY_SCRAP_QUANTITY | NUMBER | MPS supply scrap quantity | ||
SUPPLY_SCRAP_QUANTITY | NUMBER | PO supply scrap quantity | ||
SUPPLY_DELIVERY_BALANCE | NUMBER | Supply delivery balance | ||
SUPPLY_UNIT_PRICE | NUMBER | Supply unit price | ||
SUPPLY_STATUS | NUMBER | Supply status | ||
SUPPLY_LINE_NUM | NUMBER | PO line number | ||
SUPPLY_FIRM_PLANNED_STATUS | NUMBER | Whether PO was firmed or not | ||
DOCK_DATE | DATE | Expected receipt date | ||
SUPPLY_NUMBER | VARCHAR2 | (62) | Supply number | |
REVISION_NUM | VARCHAR2 | (3) | Revision number | |
PRINTED_DATE | DATE | Printed date | ||
UOM_CODE | VARCHAR2 | (3) | Unit of measure | |
SUPPLY_LINE_ID | NUMBER | Supply line identifier | ||
MRP_DESTINATION_TYPE_CODE | VARCHAR2 | (25) | MRP destination type | |
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Destination type | |
PROJECT_ID | NUMBER | Project identifier | ||
TASK_ID | NUMBER | Task identifier | ||
END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Unit number | |
TO_SUBINVENTORY | VARCHAR2 | (10) | Value specified in PO | |
VENDOR_SITE_ID | NUMBER | Supplier site identifier | ||
FROM_ORGANIZATION_ID | NUMBER | From Organiztion Id |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, COMPILE_DESIGNATOR
, MPS_ORGANIZATION_ID
, ORGANIZATION_ID
, SUPPLY_HEADER_ID
, VENDOR_ID
, SUPPLY_TYPE
, MPS_DELIVERY_SCHEDULE_DATE
, DELIVERY_SCHEDULE_DATE
, MPS_SUPPLY_QUANTITY
, SUPPLY_QUANTITY
, MPS_SUPPLY_SCRAP_QUANTITY
, SUPPLY_SCRAP_QUANTITY
, SUPPLY_DELIVERY_BALANCE
, SUPPLY_UNIT_PRICE
, SUPPLY_STATUS
, SUPPLY_LINE_NUM
, SUPPLY_FIRM_PLANNED_STATUS
, DOCK_DATE
, SUPPLY_NUMBER
, REVISION_NUM
, PRINTED_DATE
, UOM_CODE
, SUPPLY_LINE_ID
, MRP_DESTINATION_TYPE_CODE
, DESTINATION_TYPE_CODE
, PROJECT_ID
, TASK_ID
, END_ITEM_UNIT_NUMBER
, TO_SUBINVENTORY
, VENDOR_SITE_ID
, FROM_ORGANIZATION_ID
FROM APPS.MRP_PO_SUPPLY_VIEW;
APPS.MRP_PO_SUPPLY_VIEW is not referenced by any database object
|
|
|