[Home] [Help]
285: /* GL_JE_HEADERS */
286: /* GL_JE_LINES */
287: /* GL_SETS_OF_BOOKS */
288: /* GL_CODE_COMBINATIONS */
289: /* GL_ACCOUNT_HIERARCHIES */
290: /* */
291: /* AOL Tables which are being used include : */
292: /* */
293: /* FND_USER */
3213: min(bp.application_id)
3214: from psa_option_details_gt od,
3215: gl_period_statuses ps,
3216: gl_summary_templates st,
3217: gl_account_hierarchies ah,
3218: gl_bc_packets bp,
3219: gl_summary_bc_options sb,
3220: gl_budgets b,
3221: gl_budget_versions bv,
4239: select
4240:
4241: 'Summary Row exists and fails Funds Check; Absolute'
4242: from gl_bc_packets pk,
4243: gl_account_hierarchies ah
4244: where ah.ledger_id = bp.ledger_id
4245: and ah.summary_code_combination_id = pk.code_combination_id
4246: and ah.detail_code_combination_id = bp.code_combination_id
4247: and pk.packet_id = bp.packet_id
4273: (
4274: select
4275:
4276: 'Summary Row exists and fails Funds Check; Advisory'
4277: from gl_account_hierarchies ah,
4278: gl_bc_packets pk
4279: where ah.ledger_id = bp.ledger_id
4280: and ah.summary_code_combination_id = pk.code_combination_id
4281: and ah.detail_code_combination_id = bp.code_combination_id
5068: nvl(sum(nvl(pk.accounted_cr, 0)), bp.accounted_cr),
5069: nvl(max(pk.status_code), 'R'),
5070: decode(max(pk.status_code), null, bp.result_code,
5071: decode(bp.status_code, 'A', bp.result_code, 'P23'))
5072: from gl_account_hierarchies ah,
5073: gl_bc_packets pk
5074: where ah.ledger_id = g_ledger_id
5075: and ah.template_id = bp.template_id
5076: and ah.summary_code_combination_id = bp.code_combination_id
8441: END IF;
8442:
8443: END LOOP; --End of segments loop
8444:
8445: l_je_seg_stmt := l_je_seg_stmt||' FROM gl_code_combinations c, gl_account_hierarchies h, '||
8446: ' gl_bc_packets p where h.detail_code_combination_id = '||
8447: l_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8448: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8449: ' and c.code_combination_id = p.code_combination_id';
8578: END IF;
8579:
8580: END LOOP; --End of segments loop
8581:
8582: l_je_bud_seg_stmt := l_je_bud_seg_stmt||' FROM gl_code_combinations c, gl_account_hierarchies h, '||
8583: ' gl_bc_packets p where h.detail_code_combination_id = '||
8584: l_je_bud_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8585: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8586: ' and c.code_combination_id = p.code_combination_id';
8778: min(BP.session_id),
8779: min(BP.serial_id),
8780: min(BP.application_id)
8781: FROM
8782: GL_ACCOUNT_HIERARCHIES AH,
8783: GL_BC_PACKETS BP,
8784: GL_BC_PACKET_ARRIVAL_ORDER AO,
8785: GL_SUMMARY_TEMPLATES ST,
8786: GL_SUMMARY_BC_OPTIONS SB,
8927: min(BP.session_id),
8928: min(BP.serial_id),
8929: min(BP.application_id)
8930: FROM
8931: GL_ACCOUNT_HIERARCHIES AH,
8932: GL_BC_PACKETS BP,
8933: GL_BC_PACKET_ARRIVAL_ORDER AO,
8934: GL_SUMMARY_TEMPLATES ST,
8935: GL_SUMMARY_BC_OPTIONS SB,
9043: 'I'
9044: )
9045: )
9046: FROM gl_bc_packets bp,
9047: gl_account_hierarchies ah,
9048: gl_bc_packet_arrival_order ao,
9049: gl_summary_templates st,
9050: gl_summary_bc_options sb,
9051: gl_budgets b,
9124: WHERE ao.ledger_id = p_ledger_id
9125: AND ao.affect_funds_flag = 'Y')
9126: AND NOT EXISTS (
9127: SELECT 'Y'
9128: FROM gl_account_hierarchies ah
9129: WHERE ah.ledger_id = p_ledger_id
9130: AND ah.template_id = p_curr_temp_id
9131: AND ah.summary_code_combination_id = bp.code_combination_id);
9132: