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

VIEW: APPS.IGSBV_AS_DOCUMENT_ORDERS

Object Details
Object Name: IGSBV_AS_DOCUMENT_ORDERS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_AS_DOCUMENT_ORDERS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Shows the Orders placed for Transcripts and Enrollment Certificates.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORDER_NUMBER NUMBER (15) Yes Request Number of the request for Documents.
ORDER_DESCRIPTION VARCHAR2 (2000)
Order Description
_LA:ORDER_STATUS CHAR (62)
Status of Document Order
DATE_COMPLETED DATE

Date of completion
ADDR_LINE_1 VARCHAR2 (240) Yes Address Line 1
ADDR_LINE_2 VARCHAR2 (240)
Address Line 2
ADDR_LINE_3 VARCHAR2 (240)
Address Line 3
ADDR_LINE_4 VARCHAR2 (240)
Address Line 4
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
COUNTRY VARCHAR2 (60) Yes Country
POSTAL_CODE VARCHAR2 (60)
Postal Code
EMAIL_ADDRESS VARCHAR2 (2000)
E Mail Address
PHONE_COUNTRY_CODE VARCHAR2 (10)
Phone Country Code
PHONE_AREA_CODE VARCHAR2 (10)
Phone Area Code
PHONE_NUMBER VARCHAR2 (40)
Phone Number
PHONE_EXTENSION VARCHAR2 (20)
Phone Extension
FAX_COUNTRY_CODE VARCHAR2 (10)
Fax Country Code
FAX_AREA_CODE VARCHAR2 (10)
Fax Area Code
FAX_NUMBER VARCHAR2 (40)
Fax Number
DELIVERY_FEE NUMBER

Holds the Delivery Fee Details
ORDER_FEE NUMBER

Fee associated with document order
_LA:REQUEST_TYPE CHAR (61)
Request Type
SUBMIT_METHOD VARCHAR2 (30)
Submit Method
PERSON_ID NUMBER (15) Yes Person Identifier
ORDER_PLACED_BY NUMBER (15)
Order Placed by (Admin Id)
INVOICE_ID NUMBER

Invoice ID from Student Finance
CREATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
Query Text

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


SELECT ORDER_NUMBER
,      ORDER_DESCRIPTION
,      _LA:ORDER_STATUS
,      DATE_COMPLETED
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_LINE_4
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      POSTAL_CODE
,      EMAIL_ADDRESS
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      FAX_COUNTRY_CODE
,      FAX_AREA_CODE
,      FAX_NUMBER
,      DELIVERY_FEE
,      ORDER_FEE
,      _LA:REQUEST_TYPE
,      SUBMIT_METHOD
,      PERSON_ID
,      ORDER_PLACED_BY
,      INVOICE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_AS_DOCUMENT_ORDERS;

Dependencies

[top of page]

APPS.IGSBV_AS_DOCUMENT_ORDERS references the following:

SchemaAPPS
SynonymIGS_AS_ORDER_HDR

APPS.IGSBV_AS_DOCUMENT_ORDERS is not referenced by any database object