eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.POFV_RECEIVING_TRANSACTIONS

Object Details

Object Name:	POFV_RECEIVING_TRANSACTIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POFV_RECEIVING_TRANSACTIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows transactions recording physical and/or logical movement of a set of goods or services into, within, or out of the receiving-inspection business unit.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes
_LA:TRANSACTION_TYPE	CHAR	(76)
TRANSACTION_DATE	DATE		Yes
TRANSACTION_QUANTITY	NUMBER
COMMENTS	VARCHAR2	(240)
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_RATE_DATE	DATE
_LA:DESTINATION_TYPE	CHAR	(81)
INSPECTION_QUALITY	VARCHAR2	(25)
_LA:INSPECTION_STATUS	CHAR	(79)
INVOICE_STATUS	VARCHAR2	(25)
PRIMARY_QUANTITY	NUMBER
SOURCE_DOCUMENT_QUANTITY	NUMBER
PURCHASE_ORDER_UNIT_PRICE	NUMBER
_LA:RECEIPT_EXCEPTION_FLAG	CHAR	(68)
RMA_REFERENCE_NUMBER	VARCHAR2	(30)
_LA:SOURCE_DOCUMENT_TYPE	CHAR	(89)
SUBSTITUTE_UNORDERED_INDICATOR	VARCHAR2	(25)
SUPPLIER_LOT_NUMBER	VARCHAR2	(30)
_LA:USER_ENTERED_FLAG	CHAR	(63)
TRANSACTION_REASON_NAME	VARCHAR2	(30)
_DF	CHAR	(26)
SHIPMENT_ID	NUMBER		Yes
SHIPMENT_NUMBER	VARCHAR2	(30)
SHIPMENT_LINE_ID	NUMBER		Yes
SHIPMENT_LINE_NUMBER	NUMBER		Yes
INVENTORY_TRANSACTION_ID	NUMBER
TRANSACTION_UNIT_OF_MEASURE	VARCHAR2	(25)
TRANSACTION_UOM_CLASS	VARCHAR2	(10)	Yes
TRANSACTION_UOM_DESCRIPTION	VARCHAR2	(50)
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)
PRIMARY_UOM_CLASS	VARCHAR2	(10)
PRIMARY_UOM_DESCRIPTION	VARCHAR2	(50)
SOURCE_DOC_UNIT_OF_MEASURE	VARCHAR2	(25)
SOURCE_DOC_UOM_CLASS	VARCHAR2	(10)
SOURCE_DOC_UOM_DESCRIPTION	VARCHAR2	(50)
RECEIVER_ID	NUMBER	(9)
RECEIVER_EMPLOYEE_NUMBER	VARCHAR2	(30)
RECEIVER_NAME	VARCHAR2	(240)
PARENT_TRANSACTION_ID	NUMBER
_LA:PARENT_TRANSACTION_TYPE	CHAR	(76)
OPERATING_UNIT_ID	NUMBER
OPERATING_UNIT_NAME	VARCHAR2	(240)
PURCHASE_ORDER_ID	NUMBER
PURCHASE_ORDER_NUMBER	VARCHAR2	(20)
_LA:PURCHASE_ORDER_TYPE	CHAR	(72)
PO_RELEASE_ID	NUMBER
PO_RELEASE_NUMBER	NUMBER
PO_LINE_ID	NUMBER
PO_LINE_NUMBER	NUMBER
PO_SHIPMENT_ID	NUMBER
PO_SHIPMENT_NUMBER	NUMBER
_LA:PO_SHIPMENT_TYPE	CHAR	(66)
PO_DISTRIBUTION_ID	NUMBER
PO_DISTRIBUTION_NUMBER	NUMBER
REQUISITION_LINE_ID	NUMBER
REQUISITION_DOCUMENT_NUMBER	VARCHAR2	(20)
REQUISITION_LINE_NUMBER	NUMBER
REQ_DISTRIBUTION_ID	NUMBER
REQ_DISTRIBUTION_NUMBER	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
CURRENCY	VARCHAR2	(80)
CURRENCY_CONVERSION_RATE_TYPE	VARCHAR2	(30)
RATE_TYPE_NAME	VARCHAR2	(30)
RATE_TYPE_DESCRIPTION	VARCHAR2	(240)
RECEIVING_ROUTING_ID	NUMBER
RECEIVING_ROUTING_NAME	VARCHAR2	(80)
DELIVER_TO_PERSON_ID	NUMBER	(9)
DELIVER_TO_PERSON	VARCHAR2	(240)
DELIVER_TO_LOCATION_ID	NUMBER
DELIVER_TO_LOCATION	VARCHAR2	(60)
SUPPLIER_ID	NUMBER
SUPPLIER_NAME	VARCHAR2	(240)
SUPPLIER_SITE_ID	NUMBER
SUPPLIER_SITE	VARCHAR2	(15)
DESTINATION_ORGANIZATION_ID	NUMBER
DESTINATION_ORGANIZATION_CODE	VARCHAR2	(3)
DESTINATION_ORGANIZATION_NAME	VARCHAR2	(240)
DESTINATION_SUBINVENTORY	VARCHAR2	(10)
DESTINATION_LOCATOR_ID	NUMBER
DESTINATION_LOCATOR	VARCHAR2	(50)
BILL_OF_MATERIAL_RESOURCE_ID	NUMBER
BILL_OF_MATERIAL_RESOURCE	VARCHAR2	(10)
WIP_DEPARTMENT_CODE	VARCHAR2	(10)
WIP_DEPARTMENT_NAME	VARCHAR2	(240)
WIP_ENTITY_ID	NUMBER
WIP_JOB_NAME	VARCHAR2	(240)
WIP_LINE_ID	NUMBER
WIP_LINE_CODE	VARCHAR2	(10)
WIP_OPERATION_SEQUENCE_NUMBER	NUMBER
WIP_REPETITIVE_SCHEDULE_ID	NUMBER
WIP_RESOURCE_SEQUENCE_NUMBER	NUMBER
INVOICE_ID	NUMBER
INVOICE_NUMBER	VARCHAR2	(50)
CREATED_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
MVT_STAT_STATUS	VARCHAR2	(30)
QUANTITY_BILLED	NUMBER
AMOUNT_BILLED	NUMBER
_LA:MATCH_FLAG	CHAR	(56)
MATCH_OPTION	VARCHAR2	(25)
SECONDARY_QUANTITY	NUMBER
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)
SECONDARY_UOM_CODE	VARCHAR2	(3)
QC_GRADE	VARCHAR2	(150)
DROP_SHIP_FLAG	VARCHAR2	(1)		Indicates whether the Shipment has a backing Sales Order Line.
SALES_ORDER_UPDATE_DATE	DATE			The date/time when any of referenced data elements on the backing Sales Order Line is updated.
_LA:PA_ADDITION_FLAG	CHAR	(62)
_LA:CONSIGNED_FLAG	CHAR	(60)

Query Text

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


SELECT TRANSACTION_ID
,      _LA:TRANSACTION_TYPE
,      TRANSACTION_DATE
,      TRANSACTION_QUANTITY
,      COMMENTS
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_RATE_DATE
,      _LA:DESTINATION_TYPE
,      INSPECTION_QUALITY
,      _LA:INSPECTION_STATUS
,      INVOICE_STATUS
,      PRIMARY_QUANTITY
,      SOURCE_DOCUMENT_QUANTITY
,      PURCHASE_ORDER_UNIT_PRICE
,      _LA:RECEIPT_EXCEPTION_FLAG
,      RMA_REFERENCE_NUMBER
,      _LA:SOURCE_DOCUMENT_TYPE
,      SUBSTITUTE_UNORDERED_INDICATOR
,      SUPPLIER_LOT_NUMBER
,      _LA:USER_ENTERED_FLAG
,      TRANSACTION_REASON_NAME
,      _DF
,      SHIPMENT_ID
,      SHIPMENT_NUMBER
,      SHIPMENT_LINE_ID
,      SHIPMENT_LINE_NUMBER
,      INVENTORY_TRANSACTION_ID
,      TRANSACTION_UNIT_OF_MEASURE
,      TRANSACTION_UOM_CLASS
,      TRANSACTION_UOM_DESCRIPTION
,      PRIMARY_UNIT_OF_MEASURE
,      PRIMARY_UOM_CLASS
,      PRIMARY_UOM_DESCRIPTION
,      SOURCE_DOC_UNIT_OF_MEASURE
,      SOURCE_DOC_UOM_CLASS
,      SOURCE_DOC_UOM_DESCRIPTION
,      RECEIVER_ID
,      RECEIVER_EMPLOYEE_NUMBER
,      RECEIVER_NAME
,      PARENT_TRANSACTION_ID
,      _LA:PARENT_TRANSACTION_TYPE
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      PURCHASE_ORDER_ID
,      PURCHASE_ORDER_NUMBER
,      _LA:PURCHASE_ORDER_TYPE
,      PO_RELEASE_ID
,      PO_RELEASE_NUMBER
,      PO_LINE_ID
,      PO_LINE_NUMBER
,      PO_SHIPMENT_ID
,      PO_SHIPMENT_NUMBER
,      _LA:PO_SHIPMENT_TYPE
,      PO_DISTRIBUTION_ID
,      PO_DISTRIBUTION_NUMBER
,      REQUISITION_LINE_ID
,      REQUISITION_DOCUMENT_NUMBER
,      REQUISITION_LINE_NUMBER
,      REQ_DISTRIBUTION_ID
,      REQ_DISTRIBUTION_NUMBER
,      CURRENCY_CODE
,      CURRENCY
,      CURRENCY_CONVERSION_RATE_TYPE
,      RATE_TYPE_NAME
,      RATE_TYPE_DESCRIPTION
,      RECEIVING_ROUTING_ID
,      RECEIVING_ROUTING_NAME
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_PERSON
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_LOCATION
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_ORGANIZATION_CODE
,      DESTINATION_ORGANIZATION_NAME
,      DESTINATION_SUBINVENTORY
,      DESTINATION_LOCATOR_ID
,      DESTINATION_LOCATOR
,      BILL_OF_MATERIAL_RESOURCE_ID
,      BILL_OF_MATERIAL_RESOURCE
,      WIP_DEPARTMENT_CODE
,      WIP_DEPARTMENT_NAME
,      WIP_ENTITY_ID
,      WIP_JOB_NAME
,      WIP_LINE_ID
,      WIP_LINE_CODE
,      WIP_OPERATION_SEQUENCE_NUMBER
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_RESOURCE_SEQUENCE_NUMBER
,      INVOICE_ID
,      INVOICE_NUMBER
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      MVT_STAT_STATUS
,      QUANTITY_BILLED
,      AMOUNT_BILLED
,      _LA:MATCH_FLAG
,      MATCH_OPTION
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      SECONDARY_UOM_CODE
,      QC_GRADE
,      DROP_SHIP_FLAG
,      SALES_ORDER_UPDATE_DATE
,      _LA:PA_ADDITION_FLAG
,      _LA:CONSIGNED_FLAG
FROM APPS.POFV_RECEIVING_TRANSACTIONS;

Dependencies

[top of page]

APPS.POFV_RECEIVING_TRANSACTIONS references the following:

APPS: AP_INVOICES_ALL; BOM_DEPARTMENTS; BOM_RESOURCES; FND_CURRENCIES_VL; FND_GLOBAL - show dependent code; GL_DAILY_CONVERSION_TYPES; HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_LOCATIONS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MTL_ITEM_LOCATIONS; MTL_MATERIAL_TRANSACTIONS; MTL_PARAMETERS; MTL_SECONDARY_INVENTORIES; MTL_TRANSACTION_REASONS; MTL_UNITS_OF_MEASURE; PER_PEOPLE_F; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL; PO_REQ_DISTRIBUTIONS_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL; RCV_ROUTING_HEADERS; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS; WIP_ENTITIES; WIP_LINES; WIP_OPERATIONS; WIP_OPERATION_RESOURCES

APPS.POFV_RECEIVING_TRANSACTIONS is not referenced by any database object