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

TABLE: PO.RCV_TRANSACTIONS

Object Details
Object Name: RCV_TRANSACTIONS
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RCV_TRANSACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
RCV_TRANSACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_TRANSACTION_ID
RCV_TRANSACTIONS_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_ENTITY_ID
ColumnWIP_LINE_ID
ColumnWIP_OPERATION_SEQ_NUM
RCV_TRANSACTIONS_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTERFACE_TRANSACTION_ID
RCV_TRANSACTIONS_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_ID
ColumnREQUEST_ID
RCV_TRANSACTIONS_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEMPLOYEE_ID
ColumnCREATION_DATE
RCV_TRANSACTIONS_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVER_TO_PERSON_ID
RCV_TRANSACTIONS_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_DATE
ColumnLPN_GROUP_ID
RCV_TRANSACTIONS_N16 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNVL("INVOICE_STATUS_CODE",'NA')
RCV_TRANSACTIONS_N17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOE_ORDER_HEADER_ID
RCV_TRANSACTIONS_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOE_ORDER_LINE_ID
RCV_TRANSACTIONS_N19 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPA_ADDITION_FLAG
RCV_TRANSACTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIPMENT_HEADER_ID
RCV_TRANSACTIONS_N20 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_DISTRIBUTION_ID
RCV_TRANSACTIONS_N21 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSFER_LPN_ID
ColumnLPN_ID
ColumnORGANIZATION_ID
RCV_TRANSACTIONS_N22 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
RCV_TRANSACTIONS_N23 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_UPDATE_DATE
RCV_TRANSACTIONS_N24 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
RCV_TRANSACTIONS_N25 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_TRANSACTION_NUM
RCV_TRANSACTIONS_N26 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPLENISH_ORDER_LINE_ID
RCV_TRANSACTIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIPMENT_LINE_ID
RCV_TRANSACTIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_HEADER_ID
RCV_TRANSACTIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_LINE_ID
RCV_TRANSACTIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_LINE_LOCATION_ID
RCV_TRANSACTIONS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUISITION_LINE_ID
RCV_TRANSACTIONS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQ_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

LCM Shipment Line Identifier
UNIT_LANDED_COST NUMBER

LCM Unit Landed Cost
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
FROM PO.RCV_TRANSACTIONS;

Dependencies

[top of page]

PO.RCV_TRANSACTIONS does not reference any database object

PO.RCV_TRANSACTIONS is referenced by following:

SchemaAPPS
TriggerITG_IP_RCV_TRANSACTIONS_ARI
TriggerJAI_RCV_RT_ARIUD_T1
TriggerJAI_RCV_RT_BRIUD_T1
SynonymRCV_TRANSACTIONS