Product: | IGS - Student System |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGS_FI_CONTROL_V |
SELECT CTRL.ROWID ROW_ID
, CTRL.REC_INSTALLED REC_INSTALLED
, LKV.MEANING
, CTRL.ACCOUNTING_METHOD
, CTRL.INTERFACE_LINE_CONTEXT
, CTRL.INTERFACE_LINE_ATTRIBUTE
, CTRL.BATCH_SOURCE_ID
, NULL
, CTRL.CUST_TRX_TYPE_ID
, NULL
, CTRL.TERM_ID
, NULL
, CTRL.LOCKBOX_CONTEXT
, CTRL.LOCKBOX_NUMBER_ATTRIBUTE
, CTRL.NEXT_INVOICE_NUMBER
, CTRL.LAST_ACCOUNT_TRANS LAST_ACCOUNT_TRANS
, CTRL.LAST_PAY_TERM_TRANS LAST_PAY_TERM_TRANS
, CTRL.LAST_PAYMENT_TRANS LAST_PAYMENT_TRANS
, CTRL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CTRL.LAST_UPDATED_BY LAST_UPDATED_BY
, CTRL.CREATION_DATE CREATION_DATE
, CTRL.CREATED_BY CREATED_BY
, CTRL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CTRL.ORG_ID
, CTRL.REFUND_DR_GL_CCID
, CTRL.REFUND_CR_GL_CCID
, CTRL.REFUND_DR_ACCOUNT_CD
, ACC1.DESCRIPTION
, CTRL.REFUND_CR_ACCOUNT_CD
, ACC2.DESCRIPTION
, CTRL.REFUND_DT_ALIAS
, DA1.DESCRIPTION
, CTRL.SET_OF_BOOKS_ID
, SB.NAME SET_OF_BOOKS_NAME
, NULL
, NULL
, CTRL.FEE_CALC_MTHD_CODE
, LKV1.MEANING
, CTRL.AR_INT_ORG_ID
, CTRL.PLANNED_CREDITS_IND
, CTRL.REC_GL_CCID
, CTRL.CASH_GL_CCID
, CTRL.UNAPP_GL_CCID
, CTRL.REC_ACCOUNT_CD
, ACC3.DESCRIPTION
, CTRL.REV_ACCOUNT_CD
, NULL
, CTRL.CASH_ACCOUNT_CD
, ACC5.DESCRIPTION
, CTRL.UNAPP_ACCOUNT_CD
, ACC6.DESCRIPTION
, CTRL.CONV_PROCESS_RUN_IND
, CTRL.CURRENCY_CD
, CURR.NAME
, CTRL.RFND_DESTINATION
, LKV2.MEANING
, CTRL.AP_ORG_ID
, HRO.NAME
, CTRL.DFLT_SUPPLIER_SITE_NAME
, CTRL.MANAGE_ACCOUNTS
, CTRL.ACCT_CONV_FLAG
, NULL
, NULL
, CTRL.POST_WAIVER_GL_FLAG
, CTRL.WAIVER_NOTIFY_FINAID_FLAG
FROM IGS_FI_CONTROL CTRL
, IGS_LOOKUP_VALUES LKV
, IGS_LOOKUP_VALUES LKV1
, IGS_CA_DA DA1
, IGS_FI_ACC ACC1
, IGS_FI_ACC ACC2
, GL_SETS_OF_BOOKS SB
, IGS_FI_ACC ACC3
, IGS_FI_ACC ACC5
, IGS_FI_ACC ACC6
, FND_CURRENCIES_TL CURR
, IGS_LOOKUP_VALUES LKV2
, HR_OPERATING_UNITS HRO
WHERE CTRL.ACCOUNTING_METHOD = LKV.LOOKUP_CODE (+)
AND LKV.LOOKUP_TYPE (+) = 'IGS_FI_ACCT_METHOD'
AND SB.SET_OF_BOOKS_ID (+) = CTRL.SET_OF_BOOKS_ID
AND CTRL.FEE_CALC_MTHD_CODE = LKV1.LOOKUP_CODE(+)
AND LKV1.LOOKUP_TYPE(+) = 'IGS_FI_FEE_CALC_MTHD'
AND CTRL.REFUND_DT_ALIAS=DA1.DT_ALIAS(+)
AND CTRL.REFUND_DR_ACCOUNT_CD=ACC1.ACCOUNT_CD(+)
AND CTRL.REFUND_CR_ACCOUNT_CD=ACC2.ACCOUNT_CD(+)
AND CTRL.REC_ACCOUNT_CD=ACC3.ACCOUNT_CD(+)
AND CTRL.CASH_ACCOUNT_CD=ACC5.ACCOUNT_CD(+)
AND CTRL.UNAPP_ACCOUNT_CD=ACC6.ACCOUNT_CD(+)
AND CTRL.CURRENCY_CD= CURR.CURRENCY_CODE(+)
AND CTRL.RFND_DESTINATION=LKV2.LOOKUP_CODE(+)
AND LKV2.LOOKUP_TYPE(+) = 'IGS_FI_REFUND_DESTINATION'
AND CTRL.AP_ORG_ID = HRO.ORGANIZATION_ID(+)
AND CURR.LANGUAGE = USERENV('LANG')