eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGF_AP_FA_BASE_REC

Source

View Text - Preformatted


SELECT FABASE.ROWID ,FABASE.BASE_ID ,FABASE.CI_CAL_TYPE ,FABASE.PERSON_ID ,FABASE.CI_SEQUENCE_NUMBER ,FABASE.ORG_ID ,FABASE.EFC_F ,FABASE.EFC_I ,FABASE.NEED_F ,FABASE.NEED_I ,FABASE.COA_PENDING ,FABASE.VERIFICATION_PROCESS_RUN ,FABASE.INST_VERIF_STATUS_DATE ,FABASE.MANUAL_VERIF_FLAG ,FABASE.FED_VERIF_STATUS ,FABASE.FED_VERIF_STATUS_DATE ,FABASE.INST_VERIF_STATUS ,FABASE.NSLDS_ELIGIBLE ,FABASE.EDE_CORRECTION_BATCH_ID ,FABASE.FA_PROCESS_STATUS_DATE ,FABASE.ISIR_CORR_STATUS ,FABASE.ISIR_CORR_STATUS_DATE ,FABASE.ISIR_STATUS ,FABASE.ISIR_STATUS_DATE ,FABASE.PROFILE_STATUS ,FABASE.PROFILE_STATUS_DATE ,FABASE.PROFILE_FC , NULL ,FABASE.COA_FIXED ,FABASE.COA_CODE_I ,FABASE.COA_F ,FABASE.COA_I ,FABASE.COA_PELL ,FABASE.DISBURSEMENT_HOLD ,FABASE.FA_PROCESS_STATUS ,FABASE.NOTIFICATION_STATUS ,FABASE.NOTIFICATION_STATUS_DATE ,NULL ,FABASE.NSLDS_DATA_OVERRIDE_FLG ,FABASE.PACKAGING_STATUS ,FABASE.PROF_JUDGEMENT_FLG ,FABASE.PACKAGING_STATUS_DATE ,FABASE.PAYMENT_ISIR_ID ,FABASE.TARGET_GROUP ,FABASE.TOTAL_PACKAGE_ACCEPTED ,FABASE.TOTAL_PACKAGE_OFFERED ,FABASE.ADMSTRUCT_ID ,FABASE.ADMSEGMENT_1 ,FABASE.ADMSEGMENT_2 ,FABASE.ADMSEGMENT_3 ,FABASE.ADMSEGMENT_4 ,FABASE.ADMSEGMENT_5 ,FABASE.ADMSEGMENT_6 ,FABASE.ADMSEGMENT_7 ,FABASE.ADMSEGMENT_8 ,FABASE.ADMSEGMENT_9 ,FABASE.ADMSEGMENT_10 ,FABASE.ADMSEGMENT_11 ,FABASE.ADMSEGMENT_12 ,FABASE.ADMSEGMENT_13 ,FABASE.ADMSEGMENT_14 ,FABASE.ADMSEGMENT_15 ,FABASE.ADMSEGMENT_16 ,FABASE.ADMSEGMENT_17 ,FABASE.ADMSEGMENT_18 ,FABASE.ADMSEGMENT_19 ,FABASE.ADMSEGMENT_20 ,FABASE.PACKSTRUCT_ID ,FABASE.PACKSEGMENT_1 ,FABASE.PACKSEGMENT_2 ,FABASE.PACKSEGMENT_3 ,FABASE.PACKSEGMENT_4 ,FABASE.PACKSEGMENT_5 ,FABASE.PACKSEGMENT_6 ,FABASE.PACKSEGMENT_7 ,FABASE.PACKSEGMENT_8 ,FABASE.PACKSEGMENT_9 ,FABASE.PACKSEGMENT_10 ,FABASE.PACKSEGMENT_11 ,FABASE.PACKSEGMENT_12 ,FABASE.PACKSEGMENT_13 ,FABASE.PACKSEGMENT_14 ,FABASE.PACKSEGMENT_15 ,FABASE.PACKSEGMENT_16 ,FABASE.PACKSEGMENT_17 ,FABASE.PACKSEGMENT_18 ,FABASE.PACKSEGMENT_19 ,FABASE.PACKSEGMENT_20 ,FABASE.MISCSTRUCT_ID ,FABASE.MISCSEGMENT_1 ,FABASE.MISCSEGMENT_2 ,FABASE.MISCSEGMENT_3 ,FABASE.MISCSEGMENT_4 ,FABASE.MISCSEGMENT_5 ,FABASE.MISCSEGMENT_6 ,FABASE.MISCSEGMENT_7 ,FABASE.MISCSEGMENT_8 ,FABASE.MISCSEGMENT_9 ,FABASE.MISCSEGMENT_10 ,FABASE.MISCSEGMENT_11 ,FABASE.MISCSEGMENT_12 ,FABASE.MISCSEGMENT_13 ,FABASE.MISCSEGMENT_14 ,FABASE.MISCSEGMENT_15 ,FABASE.MISCSEGMENT_16 ,FABASE.MISCSEGMENT_17 ,FABASE.MISCSEGMENT_18 ,FABASE.MISCSEGMENT_19 ,FABASE.MISCSEGMENT_20 ,FABASE.TOLERANCE_AMOUNT ,FABASE.CREATED_BY ,FABASE.CREATION_DATE ,FABASE.LAST_UPDATED_BY ,FABASE.LAST_UPDATE_DATE ,FABASE.LAST_UPDATE_LOGIN ,FABASE.REQUEST_ID ,FABASE.PROGRAM_APPLICATION_ID ,FABASE.PROGRAM_ID ,FABASE.PROGRAM_UPDATE_DATE ,FABASE.MANUAL_DISB_HOLD ,FABASE.PELL_ALT_EXPENSE ,FABASE.ASSOC_ORG_NUM ,FABASE.AWARD_FMLY_CONTRIBUTION_TYPE ,ISIR_LOCKED_BY ,FABASE.ADNL_UNSUB_LOAN_ELIG_FLAG ,FABASE.LOCK_AWD_FLAG ,FABASE.LOCK_COA_FLAG FROM igf_ap_fa_base_rec_all fabase WHERE NVL (fabase.org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT FABASE.ROWID
, FABASE.BASE_ID
, FABASE.CI_CAL_TYPE
, FABASE.PERSON_ID
, FABASE.CI_SEQUENCE_NUMBER
, FABASE.ORG_ID
, FABASE.EFC_F
, FABASE.EFC_I
, FABASE.NEED_F
, FABASE.NEED_I
, FABASE.COA_PENDING
, FABASE.VERIFICATION_PROCESS_RUN
, FABASE.INST_VERIF_STATUS_DATE
, FABASE.MANUAL_VERIF_FLAG
, FABASE.FED_VERIF_STATUS
, FABASE.FED_VERIF_STATUS_DATE
, FABASE.INST_VERIF_STATUS
, FABASE.NSLDS_ELIGIBLE
, FABASE.EDE_CORRECTION_BATCH_ID
, FABASE.FA_PROCESS_STATUS_DATE
, FABASE.ISIR_CORR_STATUS
, FABASE.ISIR_CORR_STATUS_DATE
, FABASE.ISIR_STATUS
, FABASE.ISIR_STATUS_DATE
, FABASE.PROFILE_STATUS
, FABASE.PROFILE_STATUS_DATE
, FABASE.PROFILE_FC
, NULL
, FABASE.COA_FIXED
, FABASE.COA_CODE_I
, FABASE.COA_F
, FABASE.COA_I
, FABASE.COA_PELL
, FABASE.DISBURSEMENT_HOLD
, FABASE.FA_PROCESS_STATUS
, FABASE.NOTIFICATION_STATUS
, FABASE.NOTIFICATION_STATUS_DATE
, NULL
, FABASE.NSLDS_DATA_OVERRIDE_FLG
, FABASE.PACKAGING_STATUS
, FABASE.PROF_JUDGEMENT_FLG
, FABASE.PACKAGING_STATUS_DATE
, FABASE.PAYMENT_ISIR_ID
, FABASE.TARGET_GROUP
, FABASE.TOTAL_PACKAGE_ACCEPTED
, FABASE.TOTAL_PACKAGE_OFFERED
, FABASE.ADMSTRUCT_ID
, FABASE.ADMSEGMENT_1
, FABASE.ADMSEGMENT_2
, FABASE.ADMSEGMENT_3
, FABASE.ADMSEGMENT_4
, FABASE.ADMSEGMENT_5
, FABASE.ADMSEGMENT_6
, FABASE.ADMSEGMENT_7
, FABASE.ADMSEGMENT_8
, FABASE.ADMSEGMENT_9
, FABASE.ADMSEGMENT_10
, FABASE.ADMSEGMENT_11
, FABASE.ADMSEGMENT_12
, FABASE.ADMSEGMENT_13
, FABASE.ADMSEGMENT_14
, FABASE.ADMSEGMENT_15
, FABASE.ADMSEGMENT_16
, FABASE.ADMSEGMENT_17
, FABASE.ADMSEGMENT_18
, FABASE.ADMSEGMENT_19
, FABASE.ADMSEGMENT_20
, FABASE.PACKSTRUCT_ID
, FABASE.PACKSEGMENT_1
, FABASE.PACKSEGMENT_2
, FABASE.PACKSEGMENT_3
, FABASE.PACKSEGMENT_4
, FABASE.PACKSEGMENT_5
, FABASE.PACKSEGMENT_6
, FABASE.PACKSEGMENT_7
, FABASE.PACKSEGMENT_8
, FABASE.PACKSEGMENT_9
, FABASE.PACKSEGMENT_10
, FABASE.PACKSEGMENT_11
, FABASE.PACKSEGMENT_12
, FABASE.PACKSEGMENT_13
, FABASE.PACKSEGMENT_14
, FABASE.PACKSEGMENT_15
, FABASE.PACKSEGMENT_16
, FABASE.PACKSEGMENT_17
, FABASE.PACKSEGMENT_18
, FABASE.PACKSEGMENT_19
, FABASE.PACKSEGMENT_20
, FABASE.MISCSTRUCT_ID
, FABASE.MISCSEGMENT_1
, FABASE.MISCSEGMENT_2
, FABASE.MISCSEGMENT_3
, FABASE.MISCSEGMENT_4
, FABASE.MISCSEGMENT_5
, FABASE.MISCSEGMENT_6
, FABASE.MISCSEGMENT_7
, FABASE.MISCSEGMENT_8
, FABASE.MISCSEGMENT_9
, FABASE.MISCSEGMENT_10
, FABASE.MISCSEGMENT_11
, FABASE.MISCSEGMENT_12
, FABASE.MISCSEGMENT_13
, FABASE.MISCSEGMENT_14
, FABASE.MISCSEGMENT_15
, FABASE.MISCSEGMENT_16
, FABASE.MISCSEGMENT_17
, FABASE.MISCSEGMENT_18
, FABASE.MISCSEGMENT_19
, FABASE.MISCSEGMENT_20
, FABASE.TOLERANCE_AMOUNT
, FABASE.CREATED_BY
, FABASE.CREATION_DATE
, FABASE.LAST_UPDATED_BY
, FABASE.LAST_UPDATE_DATE
, FABASE.LAST_UPDATE_LOGIN
, FABASE.REQUEST_ID
, FABASE.PROGRAM_APPLICATION_ID
, FABASE.PROGRAM_ID
, FABASE.PROGRAM_UPDATE_DATE
, FABASE.MANUAL_DISB_HOLD
, FABASE.PELL_ALT_EXPENSE
, FABASE.ASSOC_ORG_NUM
, FABASE.AWARD_FMLY_CONTRIBUTION_TYPE
, ISIR_LOCKED_BY
, FABASE.ADNL_UNSUB_LOAN_ELIG_FLAG
, FABASE.LOCK_AWD_FLAG
, FABASE.LOCK_COA_FLAG
FROM IGF_AP_FA_BASE_REC_ALL FABASE
WHERE NVL (FABASE.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)