DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.POR_RCV_REQ_PURCH_RECEIPTS_V

Object Details
Object Name: POR_RCV_REQ_PURCH_RECEIPTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.POR_RCV_REQ_PURCH_RECEIPTS_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


View to query receipts based on transaction source type 'PO' for a requisition


[View Source]

Columns
Name Datatype Length Mandatory Comments
APPROVED_FLAG VARCHAR2 (1)
Approved Flag
RCV_TRANSACTION_ID NUMBER
Yes Receiving Transaction ID
CREATION_DATE DATE
Yes Creation Date
TRANSACTION_TYPE VARCHAR2 (25) Yes Transaction type
TRANSACTION_DATE DATE
Yes Transaction date
EMPLOYEE_ID NUMBER (9)
Employee ID
QUANTITY NUMBER

Quantity ordered
NET_DELIVERED_QUANTITY NUMBER

Actually quantity received
QUANTITY_ORDERED NUMBER

Quantity ordered
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of measure
UNIT_OF_MEASURE_B VARCHAR2 (25)
Unit of measure
SHIPMENT_HEADER_ID NUMBER
Yes Shipment header ID
SHIPMENT_LINE_ID NUMBER
Yes Shipment Line ID
SOURCE_DOCUMENT_CODE CHAR (2)
Source document code
DESTINATION_TYPE_CODE VARCHAR2 (25)
Code of destination type
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
Primary unit of measure
GRANDPARENT_TRANSACTION_ID NUMBER

ID of the grandparent transaction
PO_HEADER_ID NUMBER

Purchase Order Header ID
PO_RELEASE_ID NUMBER

Purchase Order release ID
PO_LINE_ID NUMBER

Purchase Order line ID
PO_LINE_LOCATION_ID NUMBER

Purchase Order line location ID
PO_DISTRIBUTION_ID NUMBER

Purchase Order distribution ID
PO_REVISION_NUM NUMBER

Purchase Order revisition number
REQ_LINE_ID NUMBER
Yes Requisition line ID
REQ_LINE_NUM NUMBER
Yes Requisition line number
PO_UNIT_PRICE NUMBER

Purchase order unit price
CURRENCY_CODE VARCHAR2 (15)
Currency code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate
CURRENCY_CONVERSION_DATE DATE

Currency conversion date
ROUTING_ID NUMBER

Routing ID
ROUTING_STEP_ID NUMBER

Routing step ID
DELIVER_TO_PERSON_ID NUMBER (9)
ID of the person delivered to
DELIVER_TO_LOCATION_ID NUMBER

ID of the location delivered to
VENDOR_ID NUMBER

Vendor ID
VENDOR_SITE_ID NUMBER

Vendor site ID
ORGANIZATION_ID NUMBER

Organization ID
SUBINVENTORY VARCHAR2 (10)
Subinventory
LOCATOR_ID NUMBER

Locator ID
LOCATION_ID NUMBER

Location ID
RECEIPT_EXCEPTION_FLAG VARCHAR2 (1)
Receipt exception flag
INSPECTION_STATUS_CODE VARCHAR2 (25)
Inspection status code
VENDOR_LOT_NUM VARCHAR2 (30)
Vendor lot number
COMMENTS VARCHAR2 (240)
Comments
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Backup attribute
ATTRIBUTE2 VARCHAR2 (150)
Backup attribute
ATTRIBUTE3 VARCHAR2 (150)
Backup attribute
ATTRIBUTE4 VARCHAR2 (150)
Backup attribute
ATTRIBUTE5 VARCHAR2 (150)
Backup attribute
ATTRIBUTE6 VARCHAR2 (150)
Backup attribute
ATTRIBUTE7 VARCHAR2 (150)
Backup attribute
ATTRIBUTE8 VARCHAR2 (150)
Backup attribute
ATTRIBUTE9 VARCHAR2 (150)
Backup attribute
ATTRIBUTE10 VARCHAR2 (150)
Backup attribute
ATTRIBUTE11 VARCHAR2 (150)
Backup attribute
ATTRIBUTE12 VARCHAR2 (150)
Backup attribute
ATTRIBUTE13 VARCHAR2 (150)
Backup attribute
ATTRIBUTE14 VARCHAR2 (150)
Backup attribute
ATTRIBUTE15 VARCHAR2 (150)
Backup attribute
REQ_DISTRIBUTION_ID NUMBER

Requisition distribution id
DESTINATION_CONTEXT VARCHAR2 (30)
Destination context
LOCATOR_ATTRIBUTE VARCHAR2 (150)
Locator attribute
SOURCE_DOC_UNIT_OF_MEASURE VARCHAR2 (25)
Source document unit of measure
GOVERNMENT_CONTEXT VARCHAR2 (30)
Government context
REQ_HEADER_ID NUMBER
Yes Requisition header ID
REQ_NUMBER VARCHAR2 (20) Yes Requisition Number
RECEIPT_NUM VARCHAR2 (30)
Receipt Number
RCV_SHIPMENT_NUMBER VARCHAR2 (30)
Receiving Shipment Number
RCV_LINE_NUMBER NUMBER
Yes Receiving line number
PACKING_SLIP VARCHAR2 (25)
Packing slip
ITEM_ID NUMBER

Item ID
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
CATEGORY_ID NUMBER

Category ID
ITEM_REVISION VARCHAR2 (3)
Item revision
RECEIPT_SOURCE_CODE VARCHAR2 (25) Yes Receipt source code
PO_NUMBER VARCHAR2 (91)
Purchase Order number
PO_LINE_NUMBER VARCHAR2 (240)
Purchase Order line number
PO_SHIPMENT_NUMBER NUMBER

Purchase Order shipment number
PO_RELEASE_NUMBER NUMBER

Purchase Order release number
VENDOR VARCHAR2 (240)
Vendor
NOTE_TO_RECEIVER VARCHAR2 (480)
Note to receiver
INV_REQ_NOTE_TO_RECEIVER VARCHAR2 (4000)
Inv Req note to receiver
BILL_OF_LADING VARCHAR2 (25)
Bill of lading
FREIGHT_CARRIER VARCHAR2 (25)
Freight carrier
WAYBILL_AIRBILL_NUM VARCHAR2 (30)
Waybill/airbill number
VENDOR_ITEM_NUMBER VARCHAR2 (25)
Vendor item number
ORDERED_QTY NUMBER

Quantity ordered
ORDERED_UOM VARCHAR2 (25)
Unit of measure of the order
DUE_DATE_VENDOR DATE

Vendor due date
DUE_DATE_INTERNAL DATE

Internal due date
PERSON VARCHAR2 (240)
Person
WIP_ENTITY_ID NUMBER

WIP entity ID
WIP_LINE_ID NUMBER

WIP line ID
WIP_REPETITIVE_SCHEDULE_ID NUMBER

WIP Repetitive schedule ID
WIP_OPERATION_SEQ_NUM NUMBER

WIP operation sequence number
WIP_RESOURCE_SEQ_NUM NUMBER

WIP resource sequence number
DEPARTMENT_CODE VARCHAR2 (10)
Department code
BOM_RESOURCE_ID NUMBER

BOM resource ID
QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)
Exception code of receiving quantity
MOVEMENT_ID NUMBER

Movement ID
INSPECTION_QUALITY_CODE VARCHAR2 (25)
Inspection quality code
SUBSTITUTE_UNORDERED_CODE VARCHAR2 (25)
Substitute unordered code
PO_NO_RELEASE_NUMBER VARCHAR2 (50)
Purchase Order release number
ORDER_ID NUMBER

Order ID
SO_NUMBER NUMBER

SO Number
SOURCE_ORGANIZATION VARCHAR2 (0)
Source Organization
MATCHING_BASIS VARCHAR2 (30)
Matching Basis
OPERATING_UNIT VARCHAR2 (240) Yes Operating unit
CLOSED_CODE VARCHAR2 (30)
Closed Code
CANCEL_FLAG VARCHAR2 (1)
Cancel Flag
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPROVED_FLAG
,      RCV_TRANSACTION_ID
,      CREATION_DATE
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      EMPLOYEE_ID
,      QUANTITY
,      NET_DELIVERED_QUANTITY
,      QUANTITY_ORDERED
,      UNIT_OF_MEASURE
,      UNIT_OF_MEASURE_B
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      SOURCE_DOCUMENT_CODE
,      DESTINATION_TYPE_CODE
,      PRIMARY_UNIT_OF_MEASURE
,      GRANDPARENT_TRANSACTION_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PO_REVISION_NUM
,      REQ_LINE_ID
,      REQ_LINE_NUM
,      PO_UNIT_PRICE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      ROUTING_ID
,      ROUTING_STEP_ID
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_LOCATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ORGANIZATION_ID
,      SUBINVENTORY
,      LOCATOR_ID
,      LOCATION_ID
,      RECEIPT_EXCEPTION_FLAG
,      INSPECTION_STATUS_CODE
,      VENDOR_LOT_NUM
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQ_DISTRIBUTION_ID
,      DESTINATION_CONTEXT
,      LOCATOR_ATTRIBUTE
,      SOURCE_DOC_UNIT_OF_MEASURE
,      GOVERNMENT_CONTEXT
,      REQ_HEADER_ID
,      REQ_NUMBER
,      RECEIPT_NUM
,      RCV_SHIPMENT_NUMBER
,      RCV_LINE_NUMBER
,      PACKING_SLIP
,      ITEM_ID
,      ITEM_DESCRIPTION
,      CATEGORY_ID
,      ITEM_REVISION
,      RECEIPT_SOURCE_CODE
,      PO_NUMBER
,      PO_LINE_NUMBER
,      PO_SHIPMENT_NUMBER
,      PO_RELEASE_NUMBER
,      VENDOR
,      NOTE_TO_RECEIVER
,      INV_REQ_NOTE_TO_RECEIVER
,      BILL_OF_LADING
,      FREIGHT_CARRIER
,      WAYBILL_AIRBILL_NUM
,      VENDOR_ITEM_NUMBER
,      ORDERED_QTY
,      ORDERED_UOM
,      DUE_DATE_VENDOR
,      DUE_DATE_INTERNAL
,      PERSON
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      DEPARTMENT_CODE
,      BOM_RESOURCE_ID
,      QTY_RCV_EXCEPTION_CODE
,      MOVEMENT_ID
,      INSPECTION_QUALITY_CODE
,      SUBSTITUTE_UNORDERED_CODE
,      PO_NO_RELEASE_NUMBER
,      ORDER_ID
,      SO_NUMBER
,      SOURCE_ORGANIZATION
,      MATCHING_BASIS
,      OPERATING_UNIT
,      CLOSED_CODE
,      CANCEL_FLAG
FROM APPS.POR_RCV_REQ_PURCH_RECEIPTS_V;

Dependencies

[top of page]

APPS.POR_RCV_REQ_PURCH_RECEIPTS_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_UNITS_OF_MEASURE
SynonymPER_ALL_PEOPLE_F
ViewPER_PEOPLE_F
PL/SQL PackagePO_CLM_INTG_GRP - show dependent code
SynonymPO_DISTRIBUTIONS_ALL
ViewPO_DISTRIBUTIONS_TRX_V
SynonymPO_HEADERS_ALL
ViewPO_LINES_TRX_V
ViewPO_LINE_LOCATIONS_TRX_V
SynonymPO_RELEASES_ALL
SynonymPO_REQUISITION_HEADERS
SynonymPO_REQUISITION_LINES
SynonymPO_REQ_DISTRIBUTIONS
ViewPO_VENDORS
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS

APPS.POR_RCV_REQ_PURCH_RECEIPTS_V is not referenced by any database object