[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_ORDER_HDR_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AS_ORDER_HDR_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view stores the document order information. This will store the information like student address, order status, payment type information related to the document request. One order can have multiple documents associated with the order.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row id | |
| ORDER_NUMBER | NUMBER | (15) | Yes | Request Number of the request for Documents. Sequence generated.Sequence Generated Column |
| ORDER_STATUS | VARCHAR2 | (30) | Status of the Document order | |
| ORDER_STATUS_DESC | VARCHAR2 | (80) | Yes | Order Status Description |
| DATE_COMPLETED | DATE | Date Completed | ||
| PERSON_ID | NUMBER | (15) | Yes | Person Identifier |
| 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 |
| COUNTRY_DESC | VARCHAR2 | (80) | Yes | Country Description |
| 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 | Document Fee of the Order. | ||
| REQUEST_TYPE | VARCHAR2 | (30) | Request Type | |
| REQUEST_TYPE_DESC | VARCHAR2 | (80) | Request Type Description | |
| SUBMIT_METHOD | VARCHAR2 | (30) | Submit Method | |
| 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 | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| REQUEST_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| PROGRAM_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| PROGRAM_UPDATE_DATE | DATE | Standard who column for concurrent programs | ||
| ORDER_PLACED_BY | NUMBER | (15) | Order Placed by (Admin Id) | |
| ORDER_DESCRIPTION | VARCHAR2 | (2000) | Order Description | |
| DEL_ALWD | VARCHAR2 | (4000) | Delete Allowed | |
| ORDER_PLACED_BY_DESC | VARCHAR2 | (360) | Order Placed By Person Description |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORDER_NUMBER
, ORDER_STATUS
, ORDER_STATUS_DESC
, DATE_COMPLETED
, PERSON_ID
, ADDR_LINE_1
, ADDR_LINE_2
, ADDR_LINE_3
, ADDR_LINE_4
, CITY
, STATE
, PROVINCE
, COUNTY
, COUNTRY
, COUNTRY_DESC
, 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
, REQUEST_TYPE
, REQUEST_TYPE_DESC
, SUBMIT_METHOD
, INVOICE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORDER_PLACED_BY
, ORDER_DESCRIPTION
, DEL_ALWD
, ORDER_PLACED_BY_DESC
FROM APPS.IGS_AS_ORDER_HDR_V;
APPS
FND_LOOKUP_VALUES
FND_TERRITORIES_TL
HZ_PARTIES
IGS_AS_ORDER_HDR
IGS_AS_SS_DOC_REQUEST
- show dependent code
APPS
IGS_AS_SS_DOC_REQUEST
- show dependent code
|
|
|
|