[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | POR_RCV_ALL_ITEMS_V1 |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ICX.POR_RCV_ALL_ITEMS_V1
|
| Subobject Name: | |
| Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
POR_RCV_ALL_ITEMS_V1 is a view that returns details of all items receivable for a requisition like requisition number, line id, delivery and item information like unit of measure, supplier, etc
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RECEIPT_DATE | DATE | Receipt date | ||
| REQUESTOR_ID | NUMBER | Requester identifier | ||
| REQUESTER | VARCHAR2 | (240) | Requester | |
| PO_HEADER_ID | NUMBER | Yes | PO header unique identifier | |
| PO_NUMBER | VARCHAR2 | (20) | Yes | PO number |
| PO_LINE_ID | NUMBER | Yes | PO line identifier | |
| PO_LINE_LOCATION_ID | NUMBER | Yes | PO line location identifier | |
| PO_RELEASE_NUMBER | NUMBER | PO Release number | ||
| PO_LINE_NUMBER | NUMBER | Yes | PO line number | |
| PO_SHIPMENT_NUMBER | NUMBER | PO shipment number | ||
| TO_ORGANIZATION_ID | NUMBER | Ship to Organization identifier | ||
| ITEM_ID | NUMBER | Item identifier | ||
| PRIMARY_UOM | VARCHAR2 | (25) | Primary Unit of Measure | |
| PRIMARY_UOM_CLASS | VARCHAR2 | (10) | Primary Uom Class | |
| QUANTITY_DELIVERED | NUMBER | Quantity delivered | ||
| EXPECTED_RECEIPT_QTY | NUMBER | Expected receipt quantity | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
| SHIP_TO_LOCATION_ID | NUMBER | Delivery location identifier | ||
| VENDOR_ID | NUMBER | Supplier (vendor) identifier | ||
| SOURCE | VARCHAR2 | (240) | Supplier name | |
| NEED_BY_DATE | DATE | Date needed by | ||
| PROMISED_DATE | DATE | Date promised by | ||
| EXPECTED_RECEIPT_DATE | DATE | Expected receipt date | ||
| ORDERED_QTY | NUMBER | Ordered quantity | ||
| ORDERED_UOM | VARCHAR2 | (25) | Ordered Quantity UOM | |
| PO_DISTRIBUTION_ID | NUMBER | Yes | PO Distribution Id | |
| PO_NUM_REL_NUM | VARCHAR2 | (61) | PO number concatenated with Release Number | |
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Flag indicating if a receipt is required | |
| DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Destination Type Code | |
| REVISION_NUM | NUMBER | Revision Number | ||
| REQUISITION_CREATION_DATE | DATE | Requisition creation date | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
| UNIT_PRICE | NUMBER | Unit Price | ||
| MATCHING_BASIS | VARCHAR2 | (30) | Yes | Matching Basis |
| PURCHASE_BASIS | VARCHAR2 | (30) | Yes | Purchase Basis |
| QUANTITY_INVOICED | NUMBER | Quantity Invoiced | ||
| JOB | VARCHAR2 | (700) | Job | |
| START_DATE | DATE | Start Date | ||
| END_DATE | DATE | End Date | ||
| WF_ITEM_KEY | VARCHAR2 | (240) | Workflow Item Key | |
| INVOICED_VAL_IN_NTFN | NUMBER | Invoiced value in notification | ||
| PRIMARY_UOM_NON_TL | VARCHAR2 | (25) | Primary UOM |
Cut, paste (and edit) the following text to query this object:
SELECT RECEIPT_DATE
, REQUESTOR_ID
, REQUESTER
, PO_HEADER_ID
, PO_NUMBER
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, PO_RELEASE_NUMBER
, PO_LINE_NUMBER
, PO_SHIPMENT_NUMBER
, TO_ORGANIZATION_ID
, ITEM_ID
, PRIMARY_UOM
, PRIMARY_UOM_CLASS
, QUANTITY_DELIVERED
, EXPECTED_RECEIPT_QTY
, ITEM_DESCRIPTION
, SHIP_TO_LOCATION_ID
, VENDOR_ID
, SOURCE
, NEED_BY_DATE
, PROMISED_DATE
, EXPECTED_RECEIPT_DATE
, ORDERED_QTY
, ORDERED_UOM
, PO_DISTRIBUTION_ID
, PO_NUM_REL_NUM
, RECEIPT_REQUIRED_FLAG
, DESTINATION_TYPE_CODE
, REVISION_NUM
, REQUISITION_CREATION_DATE
, CURRENCY_CODE
, UNIT_PRICE
, MATCHING_BASIS
, PURCHASE_BASIS
, QUANTITY_INVOICED
, JOB
, START_DATE
, END_DATE
, WF_ITEM_KEY
, INVOICED_VAL_IN_NTFN
, PRIMARY_UOM_NON_TL
FROM APPS.POR_RCV_ALL_ITEMS_V1;
APPS
FND_GLOBAL
- show dependent code
MTL_UNITS_OF_MEASURE
PER_ALL_PEOPLE_F
PER_JOBS
PO_DISTRIBUTIONS_ALL
PO_HEADERS
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_LOOKUP_CODES
PO_RELEASES_ALL
PO_VENDORS
APPS
PORCPTWF
- show dependent code
|
|
|
|