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_PARAMETERS

Object Details

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

RCV_PARAMETERS stores receiving options for each organization in
which you want to be able to receive items. The table contains one
row for each organization.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCV_PARAMETERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization 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_UPDATED_LOGIN	NUMBER			Standard Who column
QTY_RCV_TOLERANCE	NUMBER			Receiving quantity tolerance
QTY_RCV_EXCEPTION_CODE	VARCHAR2	(25)		Receiving quantity tolerance exception level
ENFORCE_SHIP_TO_LOCATION_CODE	VARCHAR2	(25)		Ship-to location control exception level
ALLOW_EXPRESS_DELIVERY_FLAG	VARCHAR2	(1)		Allow express delivery of items
DAYS_EARLY_RECEIPT_ALLOWED	NUMBER			Number of days allowed for an early receipt
DAYS_LATE_RECEIPT_ALLOWED	NUMBER			Number of days allowed for a late receipt
RECEIPT_DAYS_EXCEPTION_CODE	VARCHAR2	(25)		Receipt days exception level
RECEIVING_ROUTING_ID	NUMBER			Routing header identifier
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	VARCHAR2	(1)		Allow receipt of substitute items
ALLOW_UNORDERED_RECEIPTS_FLAG	VARCHAR2	(1)		Allow receipt of unordered items
BLIND_RECEIVING_FLAG	VARCHAR2	(1)		Use blind receiving
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).
RECEIVING_ACCOUNT_ID	NUMBER			Receiving account identifier
ALLOW_CASCADE_TRANSACTIONS	VARCHAR2	(1)		Allow cascade delivery of items
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality
RECEIPT_ASN_EXISTS_CODE	VARCHAR2	(30)		This field holds the action to be taken when the user selects a purchase order shipment even though an Advance Shipment Notice (ASN) exists
USER_DEFINED_RECEIPT_NUM_CODE	VARCHAR2	(25)		Code for receipt number generation - Manual or Automatic
MANUAL_RECEIPT_NUM_TYPE	VARCHAR2	(25)		Type of numbers being generated for manual setting - Numeric or Alphanumeric
NEXT_RECEIPT_NUM	NUMBER			Number for the next receipt
CLEARING_ACCOUNT_ID	NUMBER			Clearing Account Identifier
RETROPRICE_ADJ_ACCOUNT_ID	NUMBER			Retroactive pricing account identifier
ENFORCE_RMA_SERIAL_NUM	VARCHAR2	(1)		Enforce Serial Numbers as on RMA
RMA_RECEIPT_ROUTING_ID	NUMBER			Receipt Routing Id for RMA's
ENFORCE_RMA_LOT_NUM	VARCHAR2	(1)		Enforce Lot Numbers as on RMA
ADVANCED_PRICING	VARCHAR2	(1)		Flag to identify if Advanced Pricing is used to capture Charges.
TRANSPORTATION_EXECUTION	VARCHAR2	(1)		Flag to identify if Transportation Execution is used to estimate charges.
PRE_RECEIVE	VARCHAR2	(1)		Flag to indicate if pre-receive lcm flow is allowed or not.
LCM_ACCOUNT_ID	NUMBER			Landed Cost Absorption Account Identifier
INV_VARIANCE_ACCOUNT_ID	NUMBER			Invoice Variance Account Identifier
EXCHANGE_VARIANCE_ACCOUNT_ID	NUMBER			Exchange Variance Account Identifier
TAX_VARIANCE_ACCOUNT_ID	NUMBER			Tax Variance Account Identifier
DEF_CHARGES_ACCOUNT_ID	NUMBER			Default Charges Account Identifier

Query Text

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


SELECT ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_LOGIN
,      QTY_RCV_TOLERANCE
,      QTY_RCV_EXCEPTION_CODE
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      ALLOW_EXPRESS_DELIVERY_FLAG
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      RECEIPT_DAYS_EXCEPTION_CODE
,      RECEIVING_ROUTING_ID
,      ALLOW_SUBSTITUTE_RECEIPTS_FLAG
,      ALLOW_UNORDERED_RECEIPTS_FLAG
,      BLIND_RECEIVING_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RECEIVING_ACCOUNT_ID
,      ALLOW_CASCADE_TRANSACTIONS
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      RECEIPT_ASN_EXISTS_CODE
,      USER_DEFINED_RECEIPT_NUM_CODE
,      MANUAL_RECEIPT_NUM_TYPE
,      NEXT_RECEIPT_NUM
,      CLEARING_ACCOUNT_ID
,      RETROPRICE_ADJ_ACCOUNT_ID
,      ENFORCE_RMA_SERIAL_NUM
,      RMA_RECEIPT_ROUTING_ID
,      ENFORCE_RMA_LOT_NUM
,      ADVANCED_PRICING
,      TRANSPORTATION_EXECUTION
,      PRE_RECEIVE
,      LCM_ACCOUNT_ID
,      INV_VARIANCE_ACCOUNT_ID
,      EXCHANGE_VARIANCE_ACCOUNT_ID
,      TAX_VARIANCE_ACCOUNT_ID
,      DEF_CHARGES_ACCOUNT_ID
FROM PO.RCV_PARAMETERS;

Dependencies

[top of page]

PO.RCV_PARAMETERS does not reference any database object

PO.RCV_PARAMETERS is referenced by following:

APPS: RCV_PARAMETERS