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

VIEW: APPS.RCV_RECEIVING_PARAMETERS_V

Object Details
Object Name: RCV_RECEIVING_PARAMETERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.RCV_RECEIVING_PARAMETERS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

ORGANIZATION_ID NUMBER
Yes
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


QTY_RCV_TOLERANCE NUMBER


QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)

ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)

ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2 (1)

DAYS_EARLY_RECEIPT_ALLOWED NUMBER


DAYS_LATE_RECEIPT_ALLOWED NUMBER


RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 (25)

RECEIVING_ROUTING_ID NUMBER


ROUTING_NAME VARCHAR2 (80)

ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 (1)

ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2 (1)

BLIND_RECEIVING_FLAG VARCHAR2 (1)

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


ALLOW_CASCADE_TRANSACTIONS VARCHAR2 (1)

RECEIPT_ASN_EXISTS_CODE VARCHAR2 (30)
Holds the exception action if the user tries to receive against a PO when ASN exists
USER_DEFINED_RECEIPT_NUM_CODE VARCHAR2 (25)
MANUAL_RECEIPT_NUM_TYPE VARCHAR2 (25)
NEXT_RECEIPT_NUM NUMBER

RETROPRICE_ADJ_ACCOUNT_ID NUMBER

retroprice adjustment account
CLEARING_ACCOUNT_ID NUMBER

Clearing Account
ENFORCE_RMA_SERIAL_NUM VARCHAR2 (1)
Enforce Serial Numbers as on RMA
RMA_RECEIPT_ROUTING_ID NUMBER

RMA_ROUTING_NAME VARCHAR2 (80)
ENFORCE_RMA_LOT_NUM VARCHAR2 (1)
Enforce Serial Numbers as on RMA
Query Text

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


SELECT ROW_ID
,      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
,      ROUTING_NAME
,      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
,      RECEIPT_ASN_EXISTS_CODE
,      USER_DEFINED_RECEIPT_NUM_CODE
,      MANUAL_RECEIPT_NUM_TYPE
,      NEXT_RECEIPT_NUM
,      RETROPRICE_ADJ_ACCOUNT_ID
,      CLEARING_ACCOUNT_ID
,      ENFORCE_RMA_SERIAL_NUM
,      RMA_RECEIPT_ROUTING_ID
,      RMA_ROUTING_NAME
,      ENFORCE_RMA_LOT_NUM
FROM APPS.RCV_RECEIVING_PARAMETERS_V;

Dependencies

[top of page]

APPS.RCV_RECEIVING_PARAMETERS_V references the following:

SchemaAPPS
SynonymRCV_PARAMETERS
ViewRCV_ROUTING_HEADERS
APPS.RCV_RECEIVING_PARAMETERS_V is referenced by following:

SchemaAPPS
Package BodyPO_POXDLPDT_XMLP_PKG - show dependent code
Package BodyPO_POXRRVDR_XMLP_PKG - show dependent code