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

VIEW: APPS.OKL_CS_CREDIT_MEMO_REQUEST_UV

Object Details
Object Name: OKL_CS_CREDIT_MEMO_REQUEST_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_CREDIT_MEMO_REQUEST_UV
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
REQUEST_NUMBER VARCHAR2 (30)
Request Number
REQUEST_ID NUMBER

Request Id
TAI_ID VARCHAR2 (40)
Foreign key to OKL_TRX_AR_INVOICES_B
DNZ_KHR_ID NUMBER

Contract Identifier
LSM_ID NUMBER

Foreign key to OKL_CNSLD_AR_STRMS_B
CREDIT_REQUEST_AMOUNT NUMBER (14)
Amount of Credit Requested
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CREATED_BY NUMBER (15)
Created By
REQUEST_STATUS_CODE VARCHAR2 (30)
Request Status Code
REQUEST_STATUS VARCHAR2 (80)
Request Status
REQUESTOR VARCHAR2 (100)
Requestor
REQUEST_DATE DATE

Request Date
REQUEST_TYPE_CODE VARCHAR2 (30)
Request Type Code
Query Text

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


SELECT REQUEST_NUMBER
,      REQUEST_ID
,      TAI_ID
,      DNZ_KHR_ID
,      LSM_ID
,      CREDIT_REQUEST_AMOUNT
,      CURRENCY_CODE
,      CREATED_BY
,      REQUEST_STATUS_CODE
,      REQUEST_STATUS
,      REQUESTOR
,      REQUEST_DATE
,      REQUEST_TYPE_CODE
FROM APPS.OKL_CS_CREDIT_MEMO_REQUEST_UV;

Dependencies

[top of page]

APPS.OKL_CS_CREDIT_MEMO_REQUEST_UV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymFND_USER
SynonymOKL_TRX_AR_INVOICES_B
SynonymOKL_TRX_REQUESTS

APPS.OKL_CS_CREDIT_MEMO_REQUEST_UV is not referenced by any database object