[Home] [Help] [Dependency Information]
Object Name: | POR_RCV_INTERNAL_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.POR_RCV_INTERNAL_ITEMS_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
View to query requisition lines that are from source type 'INVENTORY' in receiving pages
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECEIPT_DATE | DATE | Receipt date | ||
REQUESTOR_ID | NUMBER | (9) | Yes | Requestor ID |
PO_HEADER_ID | NUMBER | Yes | Purchase Order Header ID | |
PO_NUMBER | VARCHAR2 | (0) | Purchase Order Number | |
PO_LINE_ID | NUMBER | Purchase Order Line ID | ||
PO_LINE_LOCATION_ID | NUMBER | Purchase Order Line Location ID | ||
PO_RELEASE_NUMBER | NUMBER | Purchase Order Release Number | ||
PO_LINE_NUMBER | VARCHAR2 | (0) | Purchase Order Line Number | |
PO_SHIPMENT_NUMBER | NUMBER | Purchase Order Shipment Number | ||
TO_ORGANIZATION_ID | NUMBER | ID of the organization delivered to | ||
ITEM_ID | NUMBER | Item ID | ||
PRIMARY_UOM | VARCHAR2 | (25) | Primary Unit of Measure | |
PRIMARY_UOM_CLASS | VARCHAR2 | (10) | Yes | Primary Unit of Measure Class |
QUANTITY_DELIVERED | NUMBER | Quantity Delivered | ||
EXPECTED_RECEIPT_QTY | NUMBER | Expected receipt quantity | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Yes | Item Description |
SHIP_TO_LOCATION_ID | NUMBER | ID of ship-to location | ||
VENDOR_ID | NUMBER | Vendor ID | ||
SOURCE | VARCHAR2 | (240) | Yes | Source Code |
VENDOR_SITE_ID | NUMBER | ID of vendor site | ||
SUPPLIER_SITE | VARCHAR2 | (0) | Supplier Site | |
NEED_BY_DATE | DATE | Need by date | ||
PROMISED_DATE | DATE | Promised date | ||
EXPECTED_RECEIPT_DATE | DATE | Expected receipt date | ||
ORDERED_QTY | NUMBER | Quantity ordered | ||
ORDERED_UOM | VARCHAR2 | (25) | Unit of measure of the order | |
PO_DISTRIBUTION_ID | NUMBER | Purchase Order distribution ID | ||
DELIVER_TO_LOCATION_ID | NUMBER | ID of the location delivered to | ||
REQ_DISTRIBUTION_ID | NUMBER | Req distribution ID | ||
PO_DISTRIBUTION_NUM | NUMBER | Purchase Order distribution Number | ||
VENDOR_PRODUCT_NUM | VARCHAR2 | (0) | Vendor Product Number | |
PO_NUM_REL_NUM | VARCHAR2 | (40) | Purchase Number release number | |
ORDER_ID | NUMBER | Yes | ID of the order | |
ORDER_NUMBER | NUMBER | Yes | Number of the order | |
REQ_LINE_ID | NUMBER | Yes | Requistion Line ID | |
REQ_HEADER_ID | NUMBER | Yes | Requisition Header ID | |
REQUISITION_NUMBER | VARCHAR2 | (20) | Yes | Requistion Number |
ORDER_TYPE_CODE | CHAR | (3) | Code of Order Type | |
MANUFACTURER_PART_NUMBER | VARCHAR2 | (150) | Manufacturer part number | |
OPERATING_UNIT | VARCHAR2 | (0) | Operating Unit | |
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Destination Type Code | |
QUANTITY_INVOICED | NUMBER | Quantity Invoiced | ||
MATCHING_BASIS | VARCHAR2 | (30) | Yes | Matching Basis |
GL_ENCUMBERED_DATE | DATE | GL Encumbered Date |
Cut, paste (and edit) the following text to query this object:
SELECT RECEIPT_DATE
, REQUESTOR_ID
, 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
, VENDOR_SITE_ID
, SUPPLIER_SITE
, NEED_BY_DATE
, PROMISED_DATE
, EXPECTED_RECEIPT_DATE
, ORDERED_QTY
, ORDERED_UOM
, PO_DISTRIBUTION_ID
, DELIVER_TO_LOCATION_ID
, REQ_DISTRIBUTION_ID
, PO_DISTRIBUTION_NUM
, VENDOR_PRODUCT_NUM
, PO_NUM_REL_NUM
, ORDER_ID
, ORDER_NUMBER
, REQ_LINE_ID
, REQ_HEADER_ID
, REQUISITION_NUMBER
, ORDER_TYPE_CODE
, MANUFACTURER_PART_NUMBER
, OPERATING_UNIT
, DESTINATION_TYPE_CODE
, QUANTITY_INVOICED
, MATCHING_BASIS
, GL_ENCUMBERED_DATE
FROM APPS.POR_RCV_INTERNAL_ITEMS_V;
APPS.POR_RCV_INTERNAL_ITEMS_V is not referenced by any database object
|
|
|