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

VIEW: APPS.POS_RCV_TRANSACTIONS_V

Object Details
Object Name: POS_RCV_TRANSACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_RCV_TRANSACTIONS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This View is used to display Receiving Transaction Information for Purchase Orders for all Organizations


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization Identifier
PARENT_TRANSACTION_ID NUMBER

Parent Transaction Identifier
SHIPMENT_HEADER_ID NUMBER
Yes Shipment Header Identifier
SHIPMENT_LINE_ID NUMBER
Yes Shipment Line Identifier
TRANSACTION_ID NUMBER
Yes Transaction Identifier
TRANSACTION_TYPE VARCHAR2 (25) Yes Transaction Type
TRANSACTION_DATE DATE
Yes Transaction Date
TRANSACT_QTY NUMBER

Transaction Quantity
TRANSACT_UOM VARCHAR2 (25)
Transaction Unit of Measure
PRIMARY_UOM VARCHAR2 (25)
Primary Unit of Measure
PRIMARY_QUANTITY NUMBER

Primary Quantity
NET_PRIMARY_QUANTITY NUMBER

Net Primary Quantity
ITEM_ID NUMBER

Item Identifier
ITEM_REV VARCHAR2 (3)
Item Rev.
ITEM_DESC VARCHAR2 (240)
Item Description
VENDOR_ITEM_NUM VARCHAR2 (25)
Vendor Item Number
DESTINATION_TYPE VARCHAR2 (25)
Destination Type
PO_HEADER_ID NUMBER

Purchase Order Header 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
PO_RELEASE_ID NUMBER

Purcahse Order Release Identifier
ROUTING_HEADER_ID NUMBER

Routing Header Identifier
SHIP_TO_LOCATION_ID NUMBER

Ship-to Location Identifier
SHIP_TO_LOCATION VARCHAR2 (60)
Ship-to Location
EMPLOYEE_ID NUMBER (9)
Employee Identifier
RECEIVER VARCHAR2 (240)
Receiver
DELIVER_TO_LOCATION_ID NUMBER

Deliver-to Location Identifier
SUBINVENTORY VARCHAR2 (10)
Sub-inventory
SOURCE_DOC_CODE VARCHAR2 (25)
Source Document Code
SOURCE_DOC_UOM VARCHAR2 (25)
Source Document Unit of Measure
SOURCE_DOC_QTY NUMBER

Source Document Quantity
SOURCE_TYPE VARCHAR2 (25) Yes Source Type
SUPPLIER_ID NUMBER

Supplier Identifier
SUPPLIER VARCHAR2 (240)
Supplier
VENDOR_ID NUMBER

Vendor Identifier
VENDOR_NAME VARCHAR2 (240)
Vendor Name
VENDOR_NUMBER VARCHAR2 (30) Yes Vendor Number
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
SUPPLIER_SITE VARCHAR2 (15) Yes Supplier Site
FROM_ORGANIZATION_ID NUMBER

From Organization Identifier
INSPECTION_STATUS_CODE VARCHAR2 (25)
Inspection Status Code
COMMENTS VARCHAR2 (240)
Comments
VENDOR_LOT_NUM VARCHAR2 (30)
Vednor Lot Number
RMA_REFERENCE VARCHAR2 (30)
RMA Reference
RECEIPT_NUM VARCHAR2 (30)
Receipt Number
RECEIPT_DATE DATE
Yes Receipt Date
PO_NUM VARCHAR2 (61)
Purchase Order Number
PO_LINE NUMBER
Yes Purchase Order Line
PO_SHIPMENT NUMBER

Shipment Number
SHIPMENT_NUM VARCHAR2 (30)
Shipment Number ASN
BILL_OF_LADING VARCHAR2 (25)
Bill of Lading
PACKING_SLIP VARCHAR2 (25)
Packing Slip
FREIGHT_CARRIER VARCHAR2 (25)
Freight Carrier
PO_RELEASE NUMBER

Purchase Order Release
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Unit of Measure Lookup Code
NEED_BY_DATE DATE

Need-by Date
PROMISED_DATE DATE

Promised Date
REASON VARCHAR2 (0)
Reason
ROUTING VARCHAR2 (0)
Routing
SUPPLIER_URL VARCHAR2 (150)
Supplier Url
ITEM_URL VARCHAR2 (240)
Item Url
ITEM_NUM VARCHAR2 (40)
Item Number
DELIVERY_STATUS VARCHAR2 (0)
Delivery Status
WAYBILL_AIRBILL_NUM VARCHAR2 (20)
Waybill Airbill Number
PO_ORG_ID NUMBER

Purchase Order Organization Identifier
ORG_NAME VARCHAR2 (240)
Organization Name
CONSIGNED_FLAG VARCHAR2 (1)
Consigned Flag
VENDOR_SITE_ID NUMBER

VENDOR_SITE_ID column from po_vendors_sites_all
GLOBAL_AGREEMENT_FLAG VARCHAR2 (1)
GLOBAL_AGREEMENT_FLAG from PO_HEADES_ALL table. Will have Y if the corresponding column value is Y; else N
SUPPLIER_REF_NUMBER VARCHAR2 (150)
Supplier Ref Number or Configuration ID
Query Text

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


SELECT ORGANIZATION_ID
,      PARENT_TRANSACTION_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      TRANSACTION_ID
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      TRANSACT_QTY
,      TRANSACT_UOM
,      PRIMARY_UOM
,      PRIMARY_QUANTITY
,      NET_PRIMARY_QUANTITY
,      ITEM_ID
,      ITEM_REV
,      ITEM_DESC
,      VENDOR_ITEM_NUM
,      DESTINATION_TYPE
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PO_RELEASE_ID
,      ROUTING_HEADER_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      EMPLOYEE_ID
,      RECEIVER
,      DELIVER_TO_LOCATION_ID
,      SUBINVENTORY
,      SOURCE_DOC_CODE
,      SOURCE_DOC_UOM
,      SOURCE_DOC_QTY
,      SOURCE_TYPE
,      SUPPLIER_ID
,      SUPPLIER
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_NUMBER
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      FROM_ORGANIZATION_ID
,      INSPECTION_STATUS_CODE
,      COMMENTS
,      VENDOR_LOT_NUM
,      RMA_REFERENCE
,      RECEIPT_NUM
,      RECEIPT_DATE
,      PO_NUM
,      PO_LINE
,      PO_SHIPMENT
,      SHIPMENT_NUM
,      BILL_OF_LADING
,      PACKING_SLIP
,      FREIGHT_CARRIER
,      PO_RELEASE
,      UNIT_MEAS_LOOKUP_CODE
,      NEED_BY_DATE
,      PROMISED_DATE
,      REASON
,      ROUTING
,      SUPPLIER_URL
,      ITEM_URL
,      ITEM_NUM
,      DELIVERY_STATUS
,      WAYBILL_AIRBILL_NUM
,      PO_ORG_ID
,      ORG_NAME
,      CONSIGNED_FLAG
,      VENDOR_SITE_ID
,      GLOBAL_AGREEMENT_FLAG
,      SUPPLIER_REF_NUMBER
FROM APPS.POS_RCV_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.POS_RCV_TRANSACTIONS_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL_TL
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPER_ALL_PEOPLE_F
PL/SQL PackagePOS_PO_RCV_QTY - show dependent code
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS

APPS.POS_RCV_TRANSACTIONS_V is not referenced by any database object