[Home] [Help]
296: /* GL_JE_HEADERS */
297: /* GL_JE_LINES */
298: /* GL_SETS_OF_BOOKS */
299: /* GL_CODE_COMBINATIONS */
300: /* GL_ACCOUNT_HIERARCHIES */
301: /* */
302: /* AOL Tables which are being used include : */
303: /* */
304: /* FND_USER */
3226: min(bp.application_id)
3227: from psa_option_details_gt od,
3228: gl_period_statuses ps,
3229: gl_summary_templates st,
3230: gl_account_hierarchies ah,
3231: gl_bc_packets bp,
3232: gl_summary_bc_options sb,
3233: gl_budgets b,
3234: gl_budget_versions bv,
4314: select
4315:
4316: 'Summary Row exists and fails Funds Check; Absolute'
4317: from gl_bc_packets pk,
4318: gl_account_hierarchies ah
4319: where ah.ledger_id = bp.ledger_id
4320: and ah.summary_code_combination_id = pk.code_combination_id
4321: and ah.detail_code_combination_id = bp.code_combination_id
4322: and pk.packet_id = bp.packet_id
4348: (
4349: select
4350:
4351: 'Summary Row exists and fails Funds Check; Advisory'
4352: from gl_account_hierarchies ah,
4353: gl_bc_packets pk
4354: where ah.ledger_id = bp.ledger_id
4355: and ah.summary_code_combination_id = pk.code_combination_id
4356: and ah.detail_code_combination_id = bp.code_combination_id
5143: nvl(sum(nvl(pk.accounted_cr, 0)), bp.accounted_cr),
5144: nvl(max(pk.status_code), 'R'),
5145: decode(max(pk.status_code), null, bp.result_code,
5146: decode(bp.status_code, 'A', bp.result_code, 'P23'))
5147: from gl_account_hierarchies ah,
5148: gl_bc_packets pk
5149: where ah.ledger_id = g_ledger_id
5150: and ah.template_id = bp.template_id
5151: and ah.summary_code_combination_id = bp.code_combination_id
8627: END IF;
8628:
8629: END LOOP; --End of segments loop
8630:
8631: l_je_seg_stmt := l_je_seg_stmt||' FROM gl_code_combinations c, gl_account_hierarchies h, '||
8632: ' gl_bc_packets p where h.detail_code_combination_id = '||
8633: l_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8634: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8635: ' and c.code_combination_id = p.code_combination_id';
8764: END IF;
8765:
8766: END LOOP; --End of segments loop
8767:
8768: l_je_bud_seg_stmt := l_je_bud_seg_stmt||' FROM gl_code_combinations c, gl_account_hierarchies h, '||
8769: ' gl_bc_packets p where h.detail_code_combination_id = '||
8770: l_je_bud_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8771: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8772: ' and c.code_combination_id = p.code_combination_id';
8964: min(BP.session_id),
8965: min(BP.serial_id),
8966: min(BP.application_id)
8967: FROM
8968: GL_ACCOUNT_HIERARCHIES AH,
8969: GL_BC_PACKETS BP,
8970: GL_BC_PACKET_ARRIVAL_ORDER AO,
8971: GL_SUMMARY_TEMPLATES ST,
8972: GL_SUMMARY_BC_OPTIONS SB,
9113: min(BP.session_id),
9114: min(BP.serial_id),
9115: min(BP.application_id)
9116: FROM
9117: GL_ACCOUNT_HIERARCHIES AH,
9118: GL_BC_PACKETS BP,
9119: GL_BC_PACKET_ARRIVAL_ORDER AO,
9120: GL_SUMMARY_TEMPLATES ST,
9121: GL_SUMMARY_BC_OPTIONS SB,
9229: 'I'
9230: )
9231: )
9232: FROM gl_bc_packets bp,
9233: gl_account_hierarchies ah,
9234: gl_bc_packet_arrival_order ao,
9235: gl_summary_templates st,
9236: gl_summary_bc_options sb,
9237: gl_budgets b,
9310: WHERE ao.ledger_id = p_ledger_id
9311: AND ao.affect_funds_flag = 'Y')
9312: AND NOT EXISTS (
9313: SELECT 'Y'
9314: FROM gl_account_hierarchies ah
9315: WHERE ah.ledger_id = p_ledger_id
9316: AND ah.template_id = p_curr_temp_id
9317: AND ah.summary_code_combination_id = bp.code_combination_id);
9318: