VIEW: APPS.IGS_FI_CONTROL_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')