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]

TABLE: PO.RCV_TRANSACTIONS

Object Details

Object Name:	RCV_TRANSACTIONS
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.RCV_TRANSACTIONS
Subobject Name:
Status:	VALID

RCV_TRANSACTIONS stores historical information about receiving
transactions that you have performed. When you enter a receiving
transaction and the receiving transaction processor processes your
transaction, the transaction is recorded in this table.
.
Once a row has been inserted into this table, it will never be
updated. When you correct a transaction, the net transaction quantity
is maintained in RCV_SUPPLY. The original transaction quantity does
not get updated. You can only delete rows from this table using the
Purge feature of Oracle Purchasing.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCV_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
RCV_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TRANSACTION_ID
RCV_TRANSACTIONS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID WIP_LINE_ID WIP_OPERATION_SEQ_NUM
RCV_TRANSACTIONS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERFACE_TRANSACTION_ID
RCV_TRANSACTIONS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ID REQUEST_ID
RCV_TRANSACTIONS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMPLOYEE_ID CREATION_DATE
RCV_TRANSACTIONS_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVER_TO_PERSON_ID
RCV_TRANSACTIONS_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_DATE LPN_GROUP_ID
RCV_TRANSACTIONS_N16	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NVL("INVOICE_STATUS_CODE",'NA')
RCV_TRANSACTIONS_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OE_ORDER_HEADER_ID
RCV_TRANSACTIONS_N18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OE_ORDER_LINE_ID
RCV_TRANSACTIONS_N19	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PA_ADDITION_FLAG
RCV_TRANSACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_HEADER_ID
RCV_TRANSACTIONS_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_DISTRIBUTION_ID
RCV_TRANSACTIONS_N21	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFER_LPN_ID LPN_ID ORGANIZATION_ID
RCV_TRANSACTIONS_N22	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
RCV_TRANSACTIONS_N23	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
RCV_TRANSACTIONS_N24	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
RCV_TRANSACTIONS_N25	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_TRANSACTION_NUM
RCV_TRANSACTIONS_N26	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPLENISH_ORDER_LINE_ID
RCV_TRANSACTIONS_N27	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIPT_CONFIRMATION_EXTRACTED
RCV_TRANSACTIONS_N29	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERFACE_SOURCE_LINE_ID
RCV_TRANSACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_LINE_ID
RCV_TRANSACTIONS_N30	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	XML_DOCUMENT_ID
RCV_TRANSACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID
RCV_TRANSACTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_LINE_ID
RCV_TRANSACTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_LINE_LOCATION_ID
RCV_TRANSACTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUISITION_LINE_ID
RCV_TRANSACTIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQ_DISTRIBUTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Receiving transaction unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
TRANSACTION_TYPE	VARCHAR2	(25)	Yes	Receiving transaction type
TRANSACTION_DATE	DATE		Yes	Transaction date
QUANTITY	NUMBER			Transaction quantity
UNIT_OF_MEASURE	VARCHAR2	(25)		Transaction unit of measure
SHIPMENT_HEADER_ID	NUMBER		Yes	Receipt shipment header unique identifier
SHIPMENT_LINE_ID	NUMBER		Yes	Receipt shipment line unique identifier
USER_ENTERED_FLAG	VARCHAR2	(1)	Yes	User-entered or automatically generated transaction
INTERFACE_SOURCE_CODE	VARCHAR2	(25)		Interface transaction source
INTERFACE_SOURCE_LINE_ID	NUMBER			Interface transaction source line
INV_TRANSACTION_ID	NUMBER			Inventory transaction unique identifier
SOURCE_DOCUMENT_CODE	VARCHAR2	(25)		Source document type
DESTINATION_TYPE_CODE	VARCHAR2	(25)		Destination type
PRIMARY_QUANTITY	NUMBER			Transaction quantity in terms of the item's primary unit of measure
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)		Item primary unit of measure
UOM_CODE	VARCHAR2	(3)		Abbreviated unit of measure code
EMPLOYEE_ID	NUMBER	(9)		Receiver unique identifier
PARENT_TRANSACTION_ID	NUMBER			Parent receiving transaction unique identifier
PO_HEADER_ID	NUMBER			Purchase order header unique identifier
PO_RELEASE_ID	NUMBER			Purchase order release unique identifier
PO_LINE_ID	NUMBER			Purchase order line unique identifier
PO_LINE_LOCATION_ID	NUMBER			Purchase order shipment unique identifier
PO_DISTRIBUTION_ID	NUMBER			Purchase order distribution unique identifier
PO_REVISION_NUM	NUMBER			Purchase order revision number
REQUISITION_LINE_ID	NUMBER			Requisition line unique identifier
PO_UNIT_PRICE	NUMBER			Unit price at time of receipt
CURRENCY_CODE	VARCHAR2	(15)		Source document foreign currency
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Foreign currency conversion type
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
ROUTING_HEADER_ID	NUMBER			Receiving routing unique identifier
ROUTING_STEP_ID	NUMBER			Not currently used
DELIVER_TO_PERSON_ID	NUMBER	(9)		Requester unique identifier
DELIVER_TO_LOCATION_ID	NUMBER			Deliver-to location unique identifier
VENDOR_ID	NUMBER			Supplier unique identifier
VENDOR_SITE_ID	NUMBER			Supplier site unique identifier
ORGANIZATION_ID	NUMBER			Destination organization unique identifier
SUBINVENTORY	VARCHAR2	(10)		Destination subinventory name
LOCATOR_ID	NUMBER			Destination locator unique identifier
WIP_ENTITY_ID	NUMBER			WIP job or repetitive assembly identifier
WIP_LINE_ID	NUMBER			WIP line identifier
WIP_REPETITIVE_SCHEDULE_ID	NUMBER			WIP repetitive schedule identifier
WIP_OPERATION_SEQ_NUM	NUMBER			WIP operation sequence number within a routing
WIP_RESOURCE_SEQ_NUM	NUMBER			WIP resource sequence number
BOM_RESOURCE_ID	NUMBER			BOM resource unique identifier
LOCATION_ID	NUMBER			Receiving location unique identifier
SUBSTITUTE_UNORDERED_CODE	VARCHAR2	(25)		Substitute or unordered receipt indicator
RECEIPT_EXCEPTION_FLAG	VARCHAR2	(1)		Receipt exception indicator
INSPECTION_STATUS_CODE	VARCHAR2	(25)		Quality inspection status
ACCRUAL_STATUS_CODE	VARCHAR2	(25)		Receiving transaction accrual status
INSPECTION_QUALITY_CODE	VARCHAR2	(25)		Quality inspection code
VENDOR_LOT_NUM	VARCHAR2	(30)		Supplier lot number
RMA_REFERENCE	VARCHAR2	(30)		RMA reference number
COMMENTS	VARCHAR2	(240)		Receiver comments
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
REQ_DISTRIBUTION_ID	NUMBER			Requisition distribution unique identifier
DEPARTMENT_CODE	VARCHAR2	(10)		WIP department name
REASON_ID	NUMBER			Transaction reason unique identifier
DESTINATION_CONTEXT	VARCHAR2	(30)		Destination descriptive flexfield context
LOCATOR_ATTRIBUTE	VARCHAR2	(150)		Locator flexfield context
CHILD_INSPECTION_FLAG	VARCHAR2	(1)		Release 9 inspection transaction indicator
SOURCE_DOC_UNIT_OF_MEASURE	VARCHAR2	(25)		Source document unit of measure
SOURCE_DOC_QUANTITY	NUMBER			Transaction quantity in terms of the source document's unit of measure
INTERFACE_TRANSACTION_ID	NUMBER			Original interface transaction unique identifier
GROUP_ID	NUMBER			Original interface group unique identifier
MOVEMENT_ID	NUMBER			Movement identification number
INVOICE_ID	NUMBER			Transaction 857 Invoice unique identifier
INVOICE_STATUS_CODE	VARCHAR2	(25)		Eligibility status for automated Oracle Payables invoice creation
QA_COLLECTION_ID	NUMBER			Primary key for Oracle Quality results
MRC_CURRENCY_CONVERSION_TYPE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, foreign currency conversion type pairs
MRC_CURRENCY_CONVERSION_DATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, currency conversion date pairs
MRC_CURRENCY_CONVERSION_RATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, currency conversion rate pairs
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	(2)		Code for the country of manufacture
MVT_STAT_STATUS	VARCHAR2	(30)		Indicator of whether the transaction has been processed by the Movement Statistics concurrent program
QUANTITY_BILLED	NUMBER			Quantity billed
MATCH_FLAG	VARCHAR2	(1)		Indicator of whether the purchase order or receipt must be matched to an invoice
AMOUNT_BILLED	NUMBER			Amount billed by Payable.
MATCH_OPTION	VARCHAR2	(25)		Indicator of whether the invoice for this transaction should be matched to the purchase order or the receipt
OE_ORDER_HEADER_ID	NUMBER			Sales order unique identifier
OE_ORDER_LINE_ID	NUMBER			Sales order line unique identifier
CUSTOMER_ID	NUMBER			Customer unique identifier
CUSTOMER_SITE_ID	NUMBER			Customer site unique identifier
LPN_ID	NUMBER			License Plate Number Identifier in which the material was received through Oracle WMS
TRANSFER_LPN_ID	NUMBER			Transfer License Plate Number Identifier in which the material was transfered to during the receiving process through Oracle WMS
MOBILE_TXN	VARCHAR2	(2)		Y/N for a row created through Oracle WMS mobile form
SECONDARY_QUANTITY	NUMBER			Transaction quantity in terms of the item's secondary unit of measure
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)		Transaction secondary unit of measure
QC_GRADE	VARCHAR2	(150)		Quality grade of the Item received
SECONDARY_UOM_CODE	VARCHAR2	(3)		Abbreviated secondary unit of measure code
PA_ADDITION_FLAG	VARCHAR2	(1)		Flag that indicates if project related receipts have been transferred to Oracle Projects
CONSIGNED_FLAG	VARCHAR2	(1)		Indicates receipt is consigned
SOURCE_TRANSACTION_NUM	VARCHAR2	(25)		Source Transaction Number
FROM_SUBINVENTORY	VARCHAR2	(240)		Parent Subinventory name
FROM_LOCATOR_ID	NUMBER			Parent locator id
AMOUNT	NUMBER			Amount for services
DROPSHIP_TYPE_CODE	NUMBER			Dropship type for global procurement
LPN_GROUP_ID	NUMBER			Iinterface lpn group identifier
JOB_ID	NUMBER			Job Identifier for services
TIMECARD_ID	NUMBER			Timecard Identifier
TIMECARD_OVN	NUMBER			Timecard revision
PROJECT_ID	NUMBER			Project Identifier for timecards
TASK_ID	NUMBER			Task identifier for timecards
REQUESTED_AMOUNT	NUMBER			Requested amount in a Work Confirmation line
MATERIAL_STORED_AMOUNT	NUMBER			material stored amount in a Work Confirmation line.
REPLENISH_ORDER_LINE_ID	NUMBER			Replenishment sales order line unique identifier for chargeable subcontracting component
LCM_SHIPMENT_LINE_ID	NUMBER			Shipment Line ID
UNIT_LANDED_COST	NUMBER			Unit landed Cost
RECEIPT_CONFIRMATION_EXTRACTED	VARCHAR2	(1)		Receipt Confirmation extracted
LCM_ADJUSTMENT_NUM	NUMBER			LCM Adjustment Num
XML_DOCUMENT_ID	NUMBER			XML Document ID

Query Text

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


SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      QUANTITY
,      UNIT_OF_MEASURE
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      USER_ENTERED_FLAG
,      INTERFACE_SOURCE_CODE
,      INTERFACE_SOURCE_LINE_ID
,      INV_TRANSACTION_ID
,      SOURCE_DOCUMENT_CODE
,      DESTINATION_TYPE_CODE
,      PRIMARY_QUANTITY
,      PRIMARY_UNIT_OF_MEASURE
,      UOM_CODE
,      EMPLOYEE_ID
,      PARENT_TRANSACTION_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PO_REVISION_NUM
,      REQUISITION_LINE_ID
,      PO_UNIT_PRICE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      ROUTING_HEADER_ID
,      ROUTING_STEP_ID
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_LOCATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ORGANIZATION_ID
,      SUBINVENTORY
,      LOCATOR_ID
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      BOM_RESOURCE_ID
,      LOCATION_ID
,      SUBSTITUTE_UNORDERED_CODE
,      RECEIPT_EXCEPTION_FLAG
,      INSPECTION_STATUS_CODE
,      ACCRUAL_STATUS_CODE
,      INSPECTION_QUALITY_CODE
,      VENDOR_LOT_NUM
,      RMA_REFERENCE
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQ_DISTRIBUTION_ID
,      DEPARTMENT_CODE
,      REASON_ID
,      DESTINATION_CONTEXT
,      LOCATOR_ATTRIBUTE
,      CHILD_INSPECTION_FLAG
,      SOURCE_DOC_UNIT_OF_MEASURE
,      SOURCE_DOC_QUANTITY
,      INTERFACE_TRANSACTION_ID
,      GROUP_ID
,      MOVEMENT_ID
,      INVOICE_ID
,      INVOICE_STATUS_CODE
,      QA_COLLECTION_ID
,      MRC_CURRENCY_CONVERSION_TYPE
,      MRC_CURRENCY_CONVERSION_DATE
,      MRC_CURRENCY_CONVERSION_RATE
,      COUNTRY_OF_ORIGIN_CODE
,      MVT_STAT_STATUS
,      QUANTITY_BILLED
,      MATCH_FLAG
,      AMOUNT_BILLED
,      MATCH_OPTION
,      OE_ORDER_HEADER_ID
,      OE_ORDER_LINE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      LPN_ID
,      TRANSFER_LPN_ID
,      MOBILE_TXN
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      QC_GRADE
,      SECONDARY_UOM_CODE
,      PA_ADDITION_FLAG
,      CONSIGNED_FLAG
,      SOURCE_TRANSACTION_NUM
,      FROM_SUBINVENTORY
,      FROM_LOCATOR_ID
,      AMOUNT
,      DROPSHIP_TYPE_CODE
,      LPN_GROUP_ID
,      JOB_ID
,      TIMECARD_ID
,      TIMECARD_OVN
,      PROJECT_ID
,      TASK_ID
,      REQUESTED_AMOUNT
,      MATERIAL_STORED_AMOUNT
,      REPLENISH_ORDER_LINE_ID
,      LCM_SHIPMENT_LINE_ID
,      UNIT_LANDED_COST
,      RECEIPT_CONFIRMATION_EXTRACTED
,      LCM_ADJUSTMENT_NUM
,      XML_DOCUMENT_ID
FROM PO.RCV_TRANSACTIONS;

Dependencies

[top of page]

PO.RCV_TRANSACTIONS does not reference any database object

PO.RCV_TRANSACTIONS is referenced by following:

PO: RCV_TRANSACTIONS#