VIEW: APPS.GL_JE_JOURNAL_LINES_V

Source

View Text - Preformatted

SELECT b.rowid BATCH_ROW_ID, b.je_batch_id JE_BATCH_ID, h.ledger_id LEDGER_ID, b.default_period_name PERIOD_NAME, ps.period_year PERIOD_YEAR, ps.period_num PERIOD_NUM, ps.effective_period_num EFFECTIVE_PERIOD_NUM, b.actual_flag ACTUAL_FLAG, b.status BATCH_STATUS, b.budgetary_control_status BUDGETARY_CONTROL_STATUS, b.name BATCH_NAME, b.description BATCH_DESCRIPTION, b.date_created BATCH_DATE_CREATED, b.posted_date BATCH_POSTED_DATE, b.ussgl_transaction_code BATCH_USSGL_TRANSACTION_CODE, b.control_total BATCH_CONTROL_TOTAL, b.running_total_dr BATCH_RUNNING_TOTAL_DR, b.running_total_cr BATCH_RUNNING_TOTAL_CR, decode ( lr.relationship_type_code, 'BALANCE', null, b.running_total_accounted_dr ) BATCH_RUN_TOTAL_ACCOUNTED_DR, decode ( lr.relationship_type_code, 'BALANCE', null, b.running_total_accounted_cr ) BATCH_RUN_TOTAL_ACCOUNTED_CR, b.status_verified BATCH_STATUS_VERIFIED, b.default_effective_date BATCH_EFFECTIVE_DATE, b.status_reset_flag BATCH_STATUS_RESET_FLAG, b.unique_date BATCH_UNIQUE_DATE, b.earliest_postable_date BATCH_EARLIEST_POSTABLE_DATE, b.packet_id PACKET_ID, b.unreservation_packet_id UNRESERVATION_PACKET_ID, b.posting_run_id POSTING_RUN_ID, b.request_id REQUEST_ID, b.ATTRIBUTE1 BATCH_ATTRIBUTE1, b.ATTRIBUTE2 BATCH_ATTRIBUTE2, b.ATTRIBUTE3 BATCH_ATTRIBUTE3, b.ATTRIBUTE4 BATCH_ATTRIBUTE4, b.ATTRIBUTE5 BATCH_ATTRIBUTE5, b.ATTRIBUTE6 BATCH_ATTRIBUTE6, b.ATTRIBUTE7 BATCH_ATTRIBUTE7, b.ATTRIBUTE8 BATCH_ATTRIBUTE8, b.ATTRIBUTE9 BATCH_ATTRIBUTE9, b.ATTRIBUTE10 BATCH_ATTRIBUTE10, b.CONTEXT BATCH_CONTEXT, b.CONTEXT2 BATCH_CONTEXT2, b.creation_date BATCH_CREATION_DATE, b.created_by BATCH_CREATED_BY, b.last_update_date BATCH_LAST_UPDATE_DATE, b.last_updated_by BATCH_LAST_UPDATED_BY, b.last_update_login BATCH_LAST_UPDATE_LOGIN, h.rowid HEADER_ROW_ID, h.je_header_id JE_HEADER_ID, h.name HEADER_NAME, h.je_source JE_SOURCE, h.je_category JE_CATEGORY, h.description HEADER_DESCRIPTION, h.external_reference EXTERNAL_REFERENCE, h.doc_sequence_id DOC_SEQUENCE_ID, h.doc_sequence_value DOC_SEQUENCE_VALUE, h.encumbrance_type_id ENCUMBRANCE_TYPE_ID, h.budget_version_id BUDGET_VERSION_ID, h.default_effective_date HEADER_EFFECTIVE_DATE, h.USSGL_TRANSACTION_CODE HEADER_USSGL_TRANSACTION_CODE, h.currency_code CURRENCY_CODE, h.currency_conversion_date CURRENCY_CONVERSION_DATE, h.currency_conversion_type CURRENCY_CONVERSION_TYPE, h.currency_conversion_rate CURRENCY_CONVERSION_RATE, h.accrual_rev_flag ACCRUAL_REV_FLAG, h.accrual_rev_period_name ACCRUAL_REV_PERIOD_NAME, h.accrual_rev_status ACCRUAL_REV_STATUS, h.control_total HEADER_CONTROL_TOTAL, h.running_total_dr HEADER_RUNNING_TOTAL_DR, h.running_total_cr HEADER_RUNNING_TOTAL_CR, decode ( lr.relationship_type_code, 'BALANCE', null, h.running_total_accounted_dr ) HEADER_RUN_TOTAL_ACCOUNTED_DR, decode ( lr.relationship_type_code, 'BALANCE', null, h.RUNNING_TOTAL_ACCOUNTED_CR ) HEADER_RUN_TOTAL_ACCOUNTED_CR, h.status HEADER_STATUS, h.date_created HEADER_DATE_CREATED, h.multi_bal_seg_flag MULTI_BAL_SEG_FLAG, h.conversion_flag CONVERSION_FLAG, h.balanced_je_flag BALANCED_JE_FLAG, h.balancing_segment_value BALANCING_SEGMENT_VALUE, h.from_recurring_header_id FROM_RECURRING_HEADER_ID, h.unique_date HEADER_UNIQUE_DATE, h.earliest_postable_date HEADER_EARLIEST_POSTABLE_DATE, h.posted_date HEADER_POSTED_DATE, h.accrual_rev_effective_date ACCRUAL_REV_EFFECTIVE_DATE, h.accrual_rev_je_header_id ACCRUAL_REV_JE_HEADER_ID, h.accrual_rev_change_sign_flag ACCRUAL_REV_CHANGE_SIGN_FLAG, h.parent_je_header_id PARENT_JE_HEADER_ID, h.ATTRIBUTE1 HEADER_ATTRIBUTE1, h.ATTRIBUTE2 HEADER_ATTRIBUTE2, h.ATTRIBUTE3 HEADER_ATTRIBUTE3, h.ATTRIBUTE4 HEADER_ATTRIBUTE4, h.ATTRIBUTE5 HEADER_ATTRIBUTE5, h.ATTRIBUTE6 HEADER_ATTRIBUTE6, h.ATTRIBUTE7 HEADER_ATTRIBUTE7, h.ATTRIBUTE8 HEADER_ATTRIBUTE8, h.ATTRIBUTE9 HEADER_ATTRIBUTE9, h.ATTRIBUTE10 HEADER_ATTRIBUTE10, h.CONTEXT HEADER_CONTEXT, h.CONTEXT2 HEADER_CONTEXT2, h.creation_date HEADER_CREATION_DATE, h.created_by HEADER_CREATED_BY, h.last_update_date HEADER_LAST_UPDATE_DATE, h.last_updated_by HEADER_LAST_UPDATED_BY, h.last_update_login HEADER_LAST_UPDATE_LOGIN, lines.rowid ROW_ID, lines.ledger_id LINE_LEDGER_ID, lines.je_line_num LINE_JE_LINE_NUM, lines.code_combination_id LINE_CODE_COMBINATION_ID, lines.period_name LINE_PERIOD_NAME, lines.effective_date LINE_EFFECTIVE_DATE, lines.entered_dr LINE_ENTERED_DR_NUM, lines.entered_cr LINE_ENTERED_CR_NUM, lines.entered_dr LINE_ENTERED_DR, lines.entered_cr LINE_ENTERED_CR, decode ( lr.relationship_type_code, 'BALANCE', null, lines.accounted_dr ) LINE_ACCOUNTED_DR, decode ( lr.relationship_type_code, 'BALANCE', null, lines.accounted_cr ) LINE_ACCOUNTED_CR, lines.description LINE_DESCRIPTION, lines.reference_1 LINE_REFERENCE_1, lines.reference_2 LINE_REFERENCE_2, lines.reference_3 LINE_REFERENCE_3, lines.reference_4 LINE_REFERENCE_4, lines.reference_5 LINE_REFERENCE_5, lines.reference_6 LINE_REFERENCE_6, lines.reference_7 LINE_REFERENCE_7, lines.reference_8 LINE_REFERENCE_8, lines.reference_9 LINE_REFERENCE_9, lines.reference_10 LINE_REFERENCE_10, lines.attribute1 LINE_ATTRIBUTE1, lines.attribute2 LINE_ATTRIBUTE2, lines.attribute3 LINE_ATTRIBUTE3, lines.attribute4 LINE_ATTRIBUTE4, lines.attribute5 LINE_ATTRIBUTE5, lines.attribute6 LINE_ATTRIBUTE6, lines.attribute7 LINE_ATTRIBUTE7, lines.attribute8 LINE_ATTRIBUTE8, lines.attribute9 LINE_ATTRIBUTE9, lines.attribute10 LINE_ATTRIBUTE10, lines.attribute11 LINE_ATTRIBUTE11, lines.attribute12 LINE_ATTRIBUTE12, lines.attribute13 LINE_ATTRIBUTE13, lines.attribute14 LINE_ATTRIBUTE14, lines.attribute15 LINE_ATTRIBUTE15, lines.attribute16 LINE_ATTRIBUTE16, lines.attribute17 LINE_ATTRIBUTE17, lines.attribute18 LINE_ATTRIBUTE18, lines.attribute19 LINE_ATTRIBUTE19, lines.attribute20 LINE_ATTRIBUTE20, lines.context LINE_CONTEXT, lines.context2 LINE_CONTEXT2, lines.context3 LINE_CONTEXT3, lines.context4 LINE_CONTEXT4, lines.invoice_date LINE_INVOICE_DATE, lines.tax_code LINE_TAX_CODE, lines.invoice_identifier LINE_INVOICE_IDENTIFIER, lines.invoice_amount LINE_INVOICE_AMOUNT, lines.no1 LINE_NO1, lines.stat_amount LINE_STAT_AMOUNT, lines.ignore_rate_flag LINE_IGNORE_RATE_FLAG, lines.ussgl_transaction_code LINE_USSGL_TRANSACTION_CODE, lines.subledger_doc_sequence_id SUBLEDGER_DOC_SEQUENCE_ID, lines.subledger_doc_sequence_value SUBLEDGER_DOC_SEQUENCE_VALUE, lines.creation_date CREATION_DATE, lines.created_by CREATED_BY, lines.last_update_date LAST_UPDATE_DATE, lines.last_updated_by LAST_UPDATED_BY, lines.last_update_login LAST_UPDATE_LOGIN, lr.target_ledger_name LEDGER_NAME, lr.target_currency_code LEDGER_CURRENCY FROM gl_period_statuses ps, gl_je_lines lines, gl_je_headers h, gl_je_batches b, gl_ledger_relationships lr WHERE lr.source_ledger_id = lr.target_ledger_id AND lr.target_currency_code = decode ( GLR03300_pkg.get_ledger_currency, 'ALL123456789012345', lr.target_currency_code, GLR03300_pkg.get_ledger_currency ) AND lr.application_id = 101 AND b.average_journal_flag = 'N' AND b.je_batch_id = h.je_batch_id AND b.actual_flag = decode ( GLR03300_pkg.get_actual_flag, 'E', decode ( LR.relationship_type_code, 'BALANCE', 'X', GLR03300_pkg.get_actual_flag ) , GLR03300_pkg.get_actual_flag ) AND h.je_header_id = lines.je_header_id AND h.currency_code = decode ( GLR03300_PKG.get_entered_currency_code, 'ALL123456789012345', h.currency_code, NULL, h.currency_code, GLR03300_pkg.get_entered_currency_code ) AND h.ledger_id = lr.source_ledger_id AND lines.period_name = ps.period_name AND ps.ledger_id = lines.ledger_id AND ps.application_id = 101

View Text - HTML Formatted

SELECT B.ROWID BATCH_ROW_ID
, B.JE_BATCH_ID JE_BATCH_ID
, H.LEDGER_ID LEDGER_ID
, B.DEFAULT_PERIOD_NAME PERIOD_NAME
, PS.PERIOD_YEAR PERIOD_YEAR
, PS.PERIOD_NUM PERIOD_NUM
, PS.EFFECTIVE_PERIOD_NUM EFFECTIVE_PERIOD_NUM
, B.ACTUAL_FLAG ACTUAL_FLAG
, B.STATUS BATCH_STATUS
, B.BUDGETARY_CONTROL_STATUS BUDGETARY_CONTROL_STATUS
, B.NAME BATCH_NAME
, B.DESCRIPTION BATCH_DESCRIPTION
, B.DATE_CREATED BATCH_DATE_CREATED
, B.POSTED_DATE BATCH_POSTED_DATE
, B.USSGL_TRANSACTION_CODE BATCH_USSGL_TRANSACTION_CODE
, B.CONTROL_TOTAL BATCH_CONTROL_TOTAL
, B.RUNNING_TOTAL_DR BATCH_RUNNING_TOTAL_DR
, B.RUNNING_TOTAL_CR BATCH_RUNNING_TOTAL_CR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, B.RUNNING_TOTAL_ACCOUNTED_DR ) BATCH_RUN_TOTAL_ACCOUNTED_DR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, B.RUNNING_TOTAL_ACCOUNTED_CR ) BATCH_RUN_TOTAL_ACCOUNTED_CR
, B.STATUS_VERIFIED BATCH_STATUS_VERIFIED
, B.DEFAULT_EFFECTIVE_DATE BATCH_EFFECTIVE_DATE
, B.STATUS_RESET_FLAG BATCH_STATUS_RESET_FLAG
, B.UNIQUE_DATE BATCH_UNIQUE_DATE
, B.EARLIEST_POSTABLE_DATE BATCH_EARLIEST_POSTABLE_DATE
, B.PACKET_ID PACKET_ID
, B.UNRESERVATION_PACKET_ID UNRESERVATION_PACKET_ID
, B.POSTING_RUN_ID POSTING_RUN_ID
, B.REQUEST_ID REQUEST_ID
, B.ATTRIBUTE1 BATCH_ATTRIBUTE1
, B.ATTRIBUTE2 BATCH_ATTRIBUTE2
, B.ATTRIBUTE3 BATCH_ATTRIBUTE3
, B.ATTRIBUTE4 BATCH_ATTRIBUTE4
, B.ATTRIBUTE5 BATCH_ATTRIBUTE5
, B.ATTRIBUTE6 BATCH_ATTRIBUTE6
, B.ATTRIBUTE7 BATCH_ATTRIBUTE7
, B.ATTRIBUTE8 BATCH_ATTRIBUTE8
, B.ATTRIBUTE9 BATCH_ATTRIBUTE9
, B.ATTRIBUTE10 BATCH_ATTRIBUTE10
, B.CONTEXT BATCH_CONTEXT
, B.CONTEXT2 BATCH_CONTEXT2
, B.CREATION_DATE BATCH_CREATION_DATE
, B.CREATED_BY BATCH_CREATED_BY
, B.LAST_UPDATE_DATE BATCH_LAST_UPDATE_DATE
, B.LAST_UPDATED_BY BATCH_LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN BATCH_LAST_UPDATE_LOGIN
, H.ROWID HEADER_ROW_ID
, H.JE_HEADER_ID JE_HEADER_ID
, H.NAME HEADER_NAME
, H.JE_SOURCE JE_SOURCE
, H.JE_CATEGORY JE_CATEGORY
, H.DESCRIPTION HEADER_DESCRIPTION
, H.EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, H.DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, H.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, H.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, H.BUDGET_VERSION_ID BUDGET_VERSION_ID
, H.DEFAULT_EFFECTIVE_DATE HEADER_EFFECTIVE_DATE
, H.USSGL_TRANSACTION_CODE HEADER_USSGL_TRANSACTION_CODE
, H.CURRENCY_CODE CURRENCY_CODE
, H.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, H.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, H.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, H.ACCRUAL_REV_FLAG ACCRUAL_REV_FLAG
, H.ACCRUAL_REV_PERIOD_NAME ACCRUAL_REV_PERIOD_NAME
, H.ACCRUAL_REV_STATUS ACCRUAL_REV_STATUS
, H.CONTROL_TOTAL HEADER_CONTROL_TOTAL
, H.RUNNING_TOTAL_DR HEADER_RUNNING_TOTAL_DR
, H.RUNNING_TOTAL_CR HEADER_RUNNING_TOTAL_CR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, H.RUNNING_TOTAL_ACCOUNTED_DR ) HEADER_RUN_TOTAL_ACCOUNTED_DR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, H.RUNNING_TOTAL_ACCOUNTED_CR ) HEADER_RUN_TOTAL_ACCOUNTED_CR
, H.STATUS HEADER_STATUS
, H.DATE_CREATED HEADER_DATE_CREATED
, H.MULTI_BAL_SEG_FLAG MULTI_BAL_SEG_FLAG
, H.CONVERSION_FLAG CONVERSION_FLAG
, H.BALANCED_JE_FLAG BALANCED_JE_FLAG
, H.BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE
, H.FROM_RECURRING_HEADER_ID FROM_RECURRING_HEADER_ID
, H.UNIQUE_DATE HEADER_UNIQUE_DATE
, H.EARLIEST_POSTABLE_DATE HEADER_EARLIEST_POSTABLE_DATE
, H.POSTED_DATE HEADER_POSTED_DATE
, H.ACCRUAL_REV_EFFECTIVE_DATE ACCRUAL_REV_EFFECTIVE_DATE
, H.ACCRUAL_REV_JE_HEADER_ID ACCRUAL_REV_JE_HEADER_ID
, H.ACCRUAL_REV_CHANGE_SIGN_FLAG ACCRUAL_REV_CHANGE_SIGN_FLAG
, H.PARENT_JE_HEADER_ID PARENT_JE_HEADER_ID
, H.ATTRIBUTE1 HEADER_ATTRIBUTE1
, H.ATTRIBUTE2 HEADER_ATTRIBUTE2
, H.ATTRIBUTE3 HEADER_ATTRIBUTE3
, H.ATTRIBUTE4 HEADER_ATTRIBUTE4
, H.ATTRIBUTE5 HEADER_ATTRIBUTE5
, H.ATTRIBUTE6 HEADER_ATTRIBUTE6
, H.ATTRIBUTE7 HEADER_ATTRIBUTE7
, H.ATTRIBUTE8 HEADER_ATTRIBUTE8
, H.ATTRIBUTE9 HEADER_ATTRIBUTE9
, H.ATTRIBUTE10 HEADER_ATTRIBUTE10
, H.CONTEXT HEADER_CONTEXT
, H.CONTEXT2 HEADER_CONTEXT2
, H.CREATION_DATE HEADER_CREATION_DATE
, H.CREATED_BY HEADER_CREATED_BY
, H.LAST_UPDATE_DATE HEADER_LAST_UPDATE_DATE
, H.LAST_UPDATED_BY HEADER_LAST_UPDATED_BY
, H.LAST_UPDATE_LOGIN HEADER_LAST_UPDATE_LOGIN
, LINES.ROWID ROW_ID
, LINES.LEDGER_ID LINE_LEDGER_ID
, LINES.JE_LINE_NUM LINE_JE_LINE_NUM
, LINES.CODE_COMBINATION_ID LINE_CODE_COMBINATION_ID
, LINES.PERIOD_NAME LINE_PERIOD_NAME
, LINES.EFFECTIVE_DATE LINE_EFFECTIVE_DATE
, LINES.ENTERED_DR LINE_ENTERED_DR_NUM
, LINES.ENTERED_CR LINE_ENTERED_CR_NUM
, LINES.ENTERED_DR LINE_ENTERED_DR
, LINES.ENTERED_CR LINE_ENTERED_CR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, LINES.ACCOUNTED_DR ) LINE_ACCOUNTED_DR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, LINES.ACCOUNTED_CR ) LINE_ACCOUNTED_CR
, LINES.DESCRIPTION LINE_DESCRIPTION
, LINES.REFERENCE_1 LINE_REFERENCE_1
, LINES.REFERENCE_2 LINE_REFERENCE_2
, LINES.REFERENCE_3 LINE_REFERENCE_3
, LINES.REFERENCE_4 LINE_REFERENCE_4
, LINES.REFERENCE_5 LINE_REFERENCE_5
, LINES.REFERENCE_6 LINE_REFERENCE_6
, LINES.REFERENCE_7 LINE_REFERENCE_7
, LINES.REFERENCE_8 LINE_REFERENCE_8
, LINES.REFERENCE_9 LINE_REFERENCE_9
, LINES.REFERENCE_10 LINE_REFERENCE_10
, LINES.ATTRIBUTE1 LINE_ATTRIBUTE1
, LINES.ATTRIBUTE2 LINE_ATTRIBUTE2
, LINES.ATTRIBUTE3 LINE_ATTRIBUTE3
, LINES.ATTRIBUTE4 LINE_ATTRIBUTE4
, LINES.ATTRIBUTE5 LINE_ATTRIBUTE5
, LINES.ATTRIBUTE6 LINE_ATTRIBUTE6
, LINES.ATTRIBUTE7 LINE_ATTRIBUTE7
, LINES.ATTRIBUTE8 LINE_ATTRIBUTE8
, LINES.ATTRIBUTE9 LINE_ATTRIBUTE9
, LINES.ATTRIBUTE10 LINE_ATTRIBUTE10
, LINES.ATTRIBUTE11 LINE_ATTRIBUTE11
, LINES.ATTRIBUTE12 LINE_ATTRIBUTE12
, LINES.ATTRIBUTE13 LINE_ATTRIBUTE13
, LINES.ATTRIBUTE14 LINE_ATTRIBUTE14
, LINES.ATTRIBUTE15 LINE_ATTRIBUTE15
, LINES.ATTRIBUTE16 LINE_ATTRIBUTE16
, LINES.ATTRIBUTE17 LINE_ATTRIBUTE17
, LINES.ATTRIBUTE18 LINE_ATTRIBUTE18
, LINES.ATTRIBUTE19 LINE_ATTRIBUTE19
, LINES.ATTRIBUTE20 LINE_ATTRIBUTE20
, LINES.CONTEXT LINE_CONTEXT
, LINES.CONTEXT2 LINE_CONTEXT2
, LINES.CONTEXT3 LINE_CONTEXT3
, LINES.CONTEXT4 LINE_CONTEXT4
, LINES.INVOICE_DATE LINE_INVOICE_DATE
, LINES.TAX_CODE LINE_TAX_CODE
, LINES.INVOICE_IDENTIFIER LINE_INVOICE_IDENTIFIER
, LINES.INVOICE_AMOUNT LINE_INVOICE_AMOUNT
, LINES.NO1 LINE_NO1
, LINES.STAT_AMOUNT LINE_STAT_AMOUNT
, LINES.IGNORE_RATE_FLAG LINE_IGNORE_RATE_FLAG
, LINES.USSGL_TRANSACTION_CODE LINE_USSGL_TRANSACTION_CODE
, LINES.SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID
, LINES.SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE
, LINES.CREATION_DATE CREATION_DATE
, LINES.CREATED_BY CREATED_BY
, LINES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LINES.LAST_UPDATED_BY LAST_UPDATED_BY
, LINES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LR.TARGET_LEDGER_NAME LEDGER_NAME
, LR.TARGET_CURRENCY_CODE LEDGER_CURRENCY
FROM GL_PERIOD_STATUSES PS
, GL_JE_LINES LINES
, GL_JE_HEADERS H
, GL_JE_BATCHES B
, GL_LEDGER_RELATIONSHIPS LR
WHERE LR.SOURCE_LEDGER_ID = LR.TARGET_LEDGER_ID
AND LR.TARGET_CURRENCY_CODE = DECODE ( GLR03300_PKG.GET_LEDGER_CURRENCY
, 'ALL123456789012345'
, LR.TARGET_CURRENCY_CODE
, GLR03300_PKG.GET_LEDGER_CURRENCY )
AND LR.APPLICATION_ID = 101
AND B.AVERAGE_JOURNAL_FLAG = 'N'
AND B.JE_BATCH_ID = H.JE_BATCH_ID
AND B.ACTUAL_FLAG = DECODE ( GLR03300_PKG.GET_ACTUAL_FLAG
, 'E'
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, 'X'
, GLR03300_PKG.GET_ACTUAL_FLAG )
, GLR03300_PKG.GET_ACTUAL_FLAG )
AND H.JE_HEADER_ID = LINES.JE_HEADER_ID
AND H.CURRENCY_CODE = DECODE ( GLR03300_PKG.GET_ENTERED_CURRENCY_CODE
, 'ALL123456789012345'
, H.CURRENCY_CODE
, NULL
, H.CURRENCY_CODE
, GLR03300_PKG.GET_ENTERED_CURRENCY_CODE )
AND H.LEDGER_ID = LR.SOURCE_LEDGER_ID
AND LINES.PERIOD_NAME = PS.PERIOD_NAME
AND PS.LEDGER_ID = LINES.LEDGER_ID
AND PS.APPLICATION_ID = 101