[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_ORDER_PAYMENT_INFO_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AS_ORDER_PAYMENT_INFO_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used to get the payment related information corresponding to the order for document placed by the user.
| 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) | Description for status of the documents order | |
| 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 |
| 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 | Order Fee | ||
| 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) | Program Application Id | |
| REQUEST_ID | NUMBER | (15) | Request id | |
| PROGRAM_ID | NUMBER | (15) | Program Id | |
| PROGRAM_UPDATE_DATE | DATE | Program Update Date | ||
| PAYMENT_DATE | DATE | Payment Date | ||
| PAYMENT_TYPE | VARCHAR2 | (60) | Yes | Payment Type |
| PAYMENT_TYPE_DESC | VARCHAR2 | (80) | Payment Type Description | |
| AUTHORIZATION_NUMBER | VARCHAR2 | (80) | Authorization number | |
| PAYMENT_AMOUNT | NUMBER | Payment Amount | ||
| BILL_DATE | DATE | Bill Date | ||
| BILLING_AMOUNT | NUMBER | Billing amount | ||
| INVOICE_AMOUNT_DUE | NUMBER | Yes | Invoice Amount Due | |
| BILL_NUMBER | VARCHAR2 | (50) | Bill Number |
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
, 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
, PAYMENT_DATE
, PAYMENT_TYPE
, PAYMENT_TYPE_DESC
, AUTHORIZATION_NUMBER
, PAYMENT_AMOUNT
, BILL_DATE
, BILLING_AMOUNT
, INVOICE_AMOUNT_DUE
, BILL_NUMBER
FROM APPS.IGS_AS_ORDER_PAYMENT_INFO_V;
APPS
IGS_AS_ORDER_HDR
IGS_FI_APPLICATIONS
IGS_FI_CREDITS_ALL
IGS_FI_INV_INT_ALL
IGS_LOOKUPS_VIEW
APPS.IGS_AS_ORDER_PAYMENT_INFO_V is not referenced by any database object
|
|
|
|