[Home] [Help] [Dependency Information]
Object Name: | OZF_CLAIM_REQ_HEADER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_HEADER_ID | NUMBER | Yes | ||
REQUEST_NUMBER | VARCHAR2 | (30) | Yes | |
REQUEST_NAME | VARCHAR2 | (240) | ||
REQUEST_TYPE | VARCHAR2 | (80) | Yes | |
START_DATE | DATE | |||
END_DATE | DATE | |||
STATUS_CODE | VARCHAR2 | (30) | Yes | |
ACTIVITY | VARCHAR2 | (80) | ||
AGREEMENT_NUMBER | VARCHAR2 | (30) | ||
TOTAL_APPROVED_AMOUNT | NUMBER | |||
TOTAL_CLAIMED_AMOUNT | NUMBER | |||
TOTAL_AMOUNT_PAID | NUMBER | |||
TOTAL_OUTSTANDING_AMOUNT | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_HEADER_ID
, REQUEST_NUMBER
, REQUEST_NAME
, REQUEST_TYPE
, START_DATE
, END_DATE
, STATUS_CODE
, ACTIVITY
, AGREEMENT_NUMBER
, TOTAL_APPROVED_AMOUNT
, TOTAL_CLAIMED_AMOUNT
, TOTAL_AMOUNT_PAID
, TOTAL_OUTSTANDING_AMOUNT
, CURRENCY_CODE
FROM APPS.OZF_CLAIM_REQ_HEADER_V;
APPS.OZF_CLAIM_REQ_HEADER_V is not referenced by any database object
|
|
|