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


VIEW: APPS.OKL_FUND_REQ_HEADERS_UV

Object Details
Object Name: OKL_FUND_REQ_HEADERS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_FUND_REQ_HEADERS_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
FUND_ID NUMBER
Yes
FUND_NUMBER VARCHAR2 (240)
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
CURRENCY_NAME VARCHAR2 (80) Yes
PAYMENT_METHOD_CODE VARCHAR2 (30)
PAYMENT_METHOD_NAME VARCHAR2 (80) Yes
FUNDING_TYPE_CODE VARCHAR2 (30)
FUNDING_TYPE_NAME VARCHAR2 (80) Yes
VENDOR_SITE_ID NUMBER
Yes
CONTRACT_ID NUMBER

DATE_ENTERED DATE
Yes
FUND_DUE_DATE DATE
Yes
FUND_APPROVED_DATE DATE

FUND_TOTAL NUMBER

TRX_STATUS_CODE VARCHAR2 (30) Yes Transaction Status
TRX_STATUS_NAME VARCHAR2 (80) Yes
FUND_TRX_TYPE_ID NUMBER
Yes
FUND_DESCRIPTION VARCHAR2 (1995)
VENDOR_ID NUMBER
Yes
VENDOR_NUMBER VARCHAR2 (30) Yes
VENDOR_NAME VARCHAR2 (240)
VENDOR_SITE_CODE VARCHAR2 (15) Yes
PAY_SITE_FLAG VARCHAR2 (1)
VENDOR_SITE_ADDRESS VARCHAR2 (80)
ORG_ID NUMBER (15)
Operating Unit identifier
INVOICE_TYPE VARCHAR2 (240)
Invoice type
INVOICE_TYPE_NAME VARCHAR2 (80) Yes Invoice Type name
PAY_GROUP_LOOKUP_CODE VARCHAR2 (30)
Lookup code for Payment Group
PAY_GROUP_LOOKUP_MEANING VARCHAR2 (80)
Lookup meaning of payment group
TERM_ID NUMBER

Term identifier
TERM_NAME VARCHAR2 (50)
Term name
Query Text

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


SELECT FUND_ID
,      FUND_NUMBER
,      CURRENCY_CODE
,      CURRENCY_NAME
,      PAYMENT_METHOD_CODE
,      PAYMENT_METHOD_NAME
,      FUNDING_TYPE_CODE
,      FUNDING_TYPE_NAME
,      VENDOR_SITE_ID
,      CONTRACT_ID
,      DATE_ENTERED
,      FUND_DUE_DATE
,      FUND_APPROVED_DATE
,      FUND_TOTAL
,      TRX_STATUS_CODE
,      TRX_STATUS_NAME
,      FUND_TRX_TYPE_ID
,      FUND_DESCRIPTION
,      VENDOR_ID
,      VENDOR_NUMBER
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      PAY_SITE_FLAG
,      VENDOR_SITE_ADDRESS
,      ORG_ID
,      INVOICE_TYPE
,      INVOICE_TYPE_NAME
,      PAY_GROUP_LOOKUP_CODE
,      PAY_GROUP_LOOKUP_MEANING
,      TERM_ID
,      TERM_NAME
FROM APPS.OKL_FUND_REQ_HEADERS_UV;

Dependencies

[top of page]

APPS.OKL_FUND_REQ_HEADERS_UV references the following:

SchemaAPPS
ViewAP_TERMS_V
SynonymFND_CURRENCIES_TL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
PL/SQL PackageOKL_FUNDING_PVT - show dependent code
SynonymOKL_TRX_AP_INVOICES_B
SynonymOKL_TRX_AP_INVOICES_TL
ViewPO_LOOKUP_CODES
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.OKL_FUND_REQ_HEADERS_UV is not referenced by any database object