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_SUPPLY

Object Details

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

RCV_SUPPLY stores information about on-hand quantities in receiving/inspection. Oracle Purchasing uses this table to track item, quantity,
location, and source information for each receiving transaction.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCV_SUPPLY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RCV_TRANSACTION_ID
RCV_SUPPLY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLY_SOURCE_ID SUPPLY_TYPE_CODE
RCV_SUPPLY_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_LINE_ID
RCV_SUPPLY_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OE_ORDER_HEADER_ID
RCV_SUPPLY_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OE_ORDER_LINE_ID
RCV_SUPPLY_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LPN_ID
RCV_SUPPLY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_LINE_LOCATION_ID
RCV_SUPPLY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQ_LINE_ID REQ_HEADER_ID
RCV_SUPPLY_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_LINE_ID
RCV_SUPPLY_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_ID
RCV_SUPPLY_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID
RCV_SUPPLY_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_FLAG
RCV_SUPPLY_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_HEADER_ID
RCV_SUPPLY_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SUPPLY_TYPE_CODE	VARCHAR2	(25)	Yes	Identifies the stage in the Purchasing cycle
SUPPLY_SOURCE_ID	NUMBER		Yes	Supply unique identifier
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
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).
REQ_HEADER_ID	NUMBER			Requisition header identifier
REQ_LINE_ID	NUMBER			Requisition line identifier
PO_HEADER_ID	NUMBER			Purchase order header identifier
PO_RELEASE_ID	NUMBER			Purchase order release identifier
PO_LINE_ID	NUMBER			Purchase order line identifier
PO_LINE_LOCATION_ID	NUMBER			Purchase order shipment schedule identifier
PO_DISTRIBUTION_ID	NUMBER			Purchase order distribution identifier
SHIPMENT_HEADER_ID	NUMBER			Shipment header Identifier
SHIPMENT_LINE_ID	NUMBER			Shipment line Identifier
RCV_TRANSACTION_ID	NUMBER			Receiving transactions Identifier
ITEM_ID	NUMBER			Inventory item identifier
ITEM_REVISION	VARCHAR2	(3)		Item revision number
QUANTITY	NUMBER		Yes	Supply quantity stored in the transaction unit of measure
UNIT_OF_MEASURE	VARCHAR2	(25)	Yes	Transaction unit of measure
TO_ORG_PRIMARY_QUANTITY	NUMBER			Supply quantity in the primary unit of measure for the Item
TO_ORG_PRIMARY_UOM	VARCHAR2	(25)		Primary unit of measure for the Item
RECEIPT_DATE	DATE			Date of receipt
DESTINATION_TYPE_CODE	VARCHAR2	(25)		Destination type of shipment lines
LOCATION_ID	NUMBER			Location identifier
FROM_ORGANIZATION_ID	NUMBER			Sending organization identifier
FROM_SUBINVENTORY	VARCHAR2	(10)		Sending subinventory identifier
TO_ORGANIZATION_ID	NUMBER			Destination organization identifier
TO_SUBINVENTORY	VARCHAR2	(10)		Destination subinventory identifier
INTRANSIT_OWNING_ORG_ID	NUMBER			Owner organization identifier for Inter-organization shipment
CHANGE_FLAG	VARCHAR2	(1)		Flags records to be processed by the supply update function
CHANGE_TYPE	VARCHAR2	(25)		Flags records to be omitted by MRP processing
OE_ORDER_HEADER_ID	NUMBER			Sales order unique identifier
OE_ORDER_LINE_ID	NUMBER			Sales order unique identifier
TO_LOCATOR_ID	NUMBER			Sales order unique identifier
LPN_ID	NUMBER			Sales order unique identifier
SECONDARY_QUANTITY	NUMBER			Quantity in the secondary unit of measure
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)		Secondary unit of measure

Query Text

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


SELECT SUPPLY_TYPE_CODE
,      SUPPLY_SOURCE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQ_HEADER_ID
,      REQ_LINE_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      RCV_TRANSACTION_ID
,      ITEM_ID
,      ITEM_REVISION
,      QUANTITY
,      UNIT_OF_MEASURE
,      TO_ORG_PRIMARY_QUANTITY
,      TO_ORG_PRIMARY_UOM
,      RECEIPT_DATE
,      DESTINATION_TYPE_CODE
,      LOCATION_ID
,      FROM_ORGANIZATION_ID
,      FROM_SUBINVENTORY
,      TO_ORGANIZATION_ID
,      TO_SUBINVENTORY
,      INTRANSIT_OWNING_ORG_ID
,      CHANGE_FLAG
,      CHANGE_TYPE
,      OE_ORDER_HEADER_ID
,      OE_ORDER_LINE_ID
,      TO_LOCATOR_ID
,      LPN_ID
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
FROM PO.RCV_SUPPLY;

Dependencies

[top of page]

PO.RCV_SUPPLY does not reference any database object

PO.RCV_SUPPLY is referenced by following:

PO: RCV_SUPPLY#