[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_PO_SUPPLY_VIEW |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PO.PO_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 |
|---|---|---|---|---|
| ITEM_ID | NUMBER | Inventory item identifier | ||
| ORGANIZATION_ID | NUMBER | Destination organization identifier | ||
| PO_HEADER_ID | NUMBER | Purchase Order header identifier | ||
| VENDOR_ID | NUMBER | Vendor identifier | ||
| VENDOR_SITE_ID | NUMBER | |||
| EXPECTED_DOCK_DATE | DATE | Expected receipt date | ||
| PO_NUMBER | VARCHAR2 | (62) | Purchase Order number | |
| QUANTITY | NUMBER | Yes | Quantity in the Purchase Order unit of measure | |
| PO_UOM_CODE | VARCHAR2 | (3) | Yes | Purchase Order unit of measure |
| PRIMARY_UOM_QUANTITY | NUMBER | Quantity in the primary unit of measure of the item | ||
| PRIMARY_UOM | VARCHAR2 | (25) | Primary unit of measure of the item | |
| UNIT_PRICE | NUMBER | Price per item | ||
| LINE_NUM | NUMBER | Yes | Purchase Order line number | |
| DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Yes | Destination type |
| PRINTED_DATE | DATE | Purchase Order firm date | ||
| PO_REVISION_NUM | NUMBER | Purchase Order revision number | ||
| FIRM_PLANNED_STATUS_FLAG | VARCHAR2 | (25) | Indicates whether the Purchase Order was firmed or not | |
| MRP_EXPECTED_DELIVERY_DATE | DATE | MRP expected delivery date | ||
| MRP_PRIMARY_QUANTITY | NUMBER | MRP quantity in the primary unit of measure of the item | ||
| MRP_PRIMARY_UOM | VARCHAR2 | (25) | MRP primary unit of measure of the item | |
| MRP_DESTINATION_TYPE_CODE | VARCHAR2 | (25) | MRP destination type | |
| MRP_TO_ORGANIZATION_ID | NUMBER | MRP destination organziation identifier | ||
| MRP_TO_SUBINVENTORY | VARCHAR2 | (10) | MRP destination subinventory identifier | |
| PO_LINE_ID | NUMBER | Purchase Order line identifier | ||
| PO_LINE_LOCATION_ID | NUMBER | Purchase Order line location identifier | ||
| PO_DISTRIBUTION_ID | NUMBER | Purchase Order distribution identifier | ||
| ITEM_REVISION | VARCHAR2 | (3) | ||
| EXPECTED_DELIVERY_DATE | DATE | |||
| TO_ORG_PRIMARY_QUANTITY | NUMBER | |||
| TO_ORGANIZATION_ID | NUMBER | |||
| PROJECT_ID | NUMBER | Project Identifier (number) | ||
| TASK_ID | NUMBER | Task Identifier (number) | ||
| END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
| TO_SUBINVENTORY | VARCHAR2 | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_ID
, ORGANIZATION_ID
, PO_HEADER_ID
, VENDOR_ID
, VENDOR_SITE_ID
, EXPECTED_DOCK_DATE
, PO_NUMBER
, QUANTITY
, PO_UOM_CODE
, PRIMARY_UOM_QUANTITY
, PRIMARY_UOM
, UNIT_PRICE
, LINE_NUM
, DESTINATION_TYPE_CODE
, PRINTED_DATE
, PO_REVISION_NUM
, FIRM_PLANNED_STATUS_FLAG
, MRP_EXPECTED_DELIVERY_DATE
, MRP_PRIMARY_QUANTITY
, MRP_PRIMARY_UOM
, MRP_DESTINATION_TYPE_CODE
, MRP_TO_ORGANIZATION_ID
, MRP_TO_SUBINVENTORY
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID
, ITEM_REVISION
, EXPECTED_DELIVERY_DATE
, TO_ORG_PRIMARY_QUANTITY
, TO_ORGANIZATION_ID
, PROJECT_ID
, TASK_ID
, END_ITEM_UNIT_NUMBER
, TO_SUBINVENTORY
FROM APPS.PO_PO_SUPPLY_VIEW;
APPS
MTL_SUPPLY
MTL_UNITS_OF_MEASURE
PO_DISTRIBUTIONS_ALL
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_RELEASES_ALL
APPS
GMPMPACT
- show dependent code
GMPMRACT
- show dependent code
MRP_PO_SUPPLY_VIEW
|
|
|
|