[Home] [Help] [Dependency Information]
Object Name: | OZF_REASON_CODES_ALL_B# |
---|---|
Object Type: | VIEW |
Owner: | OZF |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
This view returns the reaons and the receivable reason codes that have been defined for claims
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REASON_CODE_ID | NUMBER | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REASON_TYPE | VARCHAR2 | (30) | ||
REASON_CODE | VARCHAR2 | (30) | ||
REASON_TYPE_ID | NUMBER | |||
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ORG_ID | NUMBER | Yes | ||
SECURITY_GROUP_ID | NUMBER | |||
ADJUSTMENT_REASON_CODE | VARCHAR2 | (30) | ||
ORDER_TYPE_ID | NUMBER | |||
PARTNER_ACCESS_FLAG | VARCHAR2 | (1) | ||
INVOICING_REASON_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT REASON_CODE_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REASON_TYPE
, REASON_CODE
, REASON_TYPE_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, SECURITY_GROUP_ID
, ADJUSTMENT_REASON_CODE
, ORDER_TYPE_ID
, PARTNER_ACCESS_FLAG
, INVOICING_REASON_CODE
FROM OZF.OZF_REASON_CODES_ALL_B#;
|
|
|