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

VIEW: APPS.IGS_AD_APP_REQ_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


Shows the applicant's application requirement


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
APP_REQ_ID NUMBER (15) Yes Identifier for applicant requirement
PERSON_ID NUMBER (15) Yes Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
ADMISSION_APPL_NUMBER NUMBER (2) Yes OBSOLETED column
NOMINATED_COURSE_CD VARCHAR2 (0)
OBSOLETED column
SEQUENCE_NUMBER VARCHAR2 (0)
OBSOLETED Sequence number
APPLICANT_FEE_TYPE NUMBER (15) Yes Applicant fee type
FEE_TYPE VARCHAR2 (10) Yes Fee type
FEE_DESCRIPTION VARCHAR2 (30) Yes Fee description
APPLICANT_FEE_STATUS NUMBER (15) Yes Applicant fee
FEE_STATUS VARCHAR2 (10) Yes Fee status
DESCRIPTION VARCHAR2 (30) Yes Description
FEE_DATE DATE
Yes Fee date
FEE_PAYMENT_METHOD NUMBER (15)
Fee payment method
PAYMENT_METHOD VARCHAR2 (10)
Payment method
PAYMENT_DESCRIPTION VARCHAR2 (30)
Payment desciption
FEE_AMOUNT NUMBER
Yes Fee amount
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
REFERENCE_NUM VARCHAR2 (60)
This is used to store the manually recorded transaction reference details
CREDIT_CARD_CODE VARCHAR2 (30)
No longer used
CREDIT_CARD_HOLDER_NAME VARCHAR2 (80)
No longer used
CREDIT_CARD_NUMBER VARCHAR2 (30)
No longer used
CREDIT_CARD_EXPIRATION_DATE DATE

No longer used
CREDIT_CARD_STATUS_CODE VARCHAR2 (30)
Credit Card Status
CREDIT_CARD_PAYEE_CD VARCHAR2 (80)
No longer used
CREDIT_CARD_TANGIBLE_CD VARCHAR2 (80)
No longer used
REV_GL_CCID NUMBER (38)
Revenue general ledger code combination identifier
CASH_GL_CCID NUMBER (38)
Cash general ledger code combination identifier
REV_ACCOUNT_CD VARCHAR2 (40)
Revenue account code
CASH_ACCOUNT_CD VARCHAR2 (40)
Cash account code
GL_DATE DATE

General ledger date
GL_POSTED_DATE DATE

General ledge posted date
POSTING_CONTROL_ID NUMBER (15)
Posting control identifier
Query Text

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


SELECT ROW_ID
,      APP_REQ_ID
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      SEQUENCE_NUMBER
,      APPLICANT_FEE_TYPE
,      FEE_TYPE
,      FEE_DESCRIPTION
,      APPLICANT_FEE_STATUS
,      FEE_STATUS
,      DESCRIPTION
,      FEE_DATE
,      FEE_PAYMENT_METHOD
,      PAYMENT_METHOD
,      PAYMENT_DESCRIPTION
,      FEE_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REFERENCE_NUM
,      CREDIT_CARD_CODE
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_STATUS_CODE
,      CREDIT_CARD_PAYEE_CD
,      CREDIT_CARD_TANGIBLE_CD
,      REV_GL_CCID
,      CASH_GL_CCID
,      REV_ACCOUNT_CD
,      CASH_ACCOUNT_CD
,      GL_DATE
,      GL_POSTED_DATE
,      POSTING_CONTROL_ID
FROM APPS.IGS_AD_APP_REQ_V;

Dependencies

[top of page]

APPS.IGS_AD_APP_REQ_V references the following:

SchemaAPPS
SynonymIGS_AD_APP_REQ
SynonymIGS_AD_CODE_CLASSES
APPS.IGS_AD_APP_REQ_V is referenced by following:

SchemaAPPS
Package BodyIGS_AD_VAL_ACAI - show dependent code