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.POBV_RECEIVING_TRANSACTIONS

Object Details

Object Name:	POBV_RECEIVING_TRANSACTIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POBV_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)
SHIPMENT_ID	NUMBER		Yes
SHIPMENT_LINE_ID	NUMBER		Yes
INVENTORY_TRANSACTION_ID	NUMBER
TRANSACTION_UNIT_OF_MEASURE	VARCHAR2	(25)
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)
SOURCE_DOC_UNIT_OF_MEASURE	VARCHAR2	(25)
RECEIVER_ID	NUMBER	(9)
PARENT_TRANSACTION_ID	NUMBER
PURCHASE_ORDER_ID	NUMBER
PO_RELEASE_ID	NUMBER
PO_LINE_ID	NUMBER
PO_SHIPMENT_ID	NUMBER
PO_DISTRIBUTION_ID	NUMBER
REQUISITION_LINE_ID	NUMBER
REQ_DISTRIBUTION_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
CURRENCY_CONVERSION_RATE_TYPE	VARCHAR2	(30)
RECEIVING_ROUTING_ID	NUMBER
ROUTING_STEP_ID	NUMBER
DELIVER_TO_PERSON_ID	NUMBER	(9)
DELIVER_TO_LOCATION_ID	NUMBER
SUPPLIER_ID	NUMBER
SUPPLIER_SITE_ID	NUMBER
DESTINATION_ORGANIZATION_ID	NUMBER
DESTINATION_SUBINVENTORY	VARCHAR2	(10)
DESTINATION_LOCATOR_ID	NUMBER
BILL_OF_MATERIAL_RESOURCE_ID	NUMBER
WIP_DEPARTMENT_CODE	VARCHAR2	(10)
WIP_ENTITY_ID	NUMBER
WIP_LINE_ID	NUMBER
WIP_OPERATION_SEQUENCE_NUMBER	NUMBER
WIP_REPETITIVE_SCHEDULE_ID	NUMBER
WIP_RESOURCE_SEQUENCE_NUMBER	NUMBER
INVOICE_ID	NUMBER
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)
_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
,      SHIPMENT_ID
,      SHIPMENT_LINE_ID
,      INVENTORY_TRANSACTION_ID
,      TRANSACTION_UNIT_OF_MEASURE
,      PRIMARY_UNIT_OF_MEASURE
,      SOURCE_DOC_UNIT_OF_MEASURE
,      RECEIVER_ID
,      PARENT_TRANSACTION_ID
,      PURCHASE_ORDER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_SHIPMENT_ID
,      PO_DISTRIBUTION_ID
,      REQUISITION_LINE_ID
,      REQ_DISTRIBUTION_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE_TYPE
,      RECEIVING_ROUTING_ID
,      ROUTING_STEP_ID
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_LOCATION_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      DESTINATION_LOCATOR_ID
,      BILL_OF_MATERIAL_RESOURCE_ID
,      WIP_DEPARTMENT_CODE
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_OPERATION_SEQUENCE_NUMBER
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_RESOURCE_SEQUENCE_NUMBER
,      INVOICE_ID
,      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
,      _LA:PA_ADDITION_FLAG
,      _LA:CONSIGNED_FLAG
FROM APPS.POBV_RECEIVING_TRANSACTIONS;

Dependencies

[top of page]

APPS.POBV_RECEIVING_TRANSACTIONS references the following:

APPS: MTL_TRANSACTION_REASONS; RCV_TRANSACTIONS

APPS.POBV_RECEIVING_TRANSACTIONS is not referenced by any database object