eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_FUNDS_CHECKER dependencies on PO_REQ_DISTRIBUTIONS

Line 1118: 'po_req_distributions pord, ' ||

1114: 'from gl_periods glp, ' ||
1115: 'gl_sets_of_books glsob, ' ||
1116: 'financials_system_parameters fsp, ' ||
1117: 'fnd_currencies base_cur, ' ||
1118: 'po_req_distributions pord, ' ||
1119: 'po_requisition_lines porl, ' ||
1120: 'po_requisition_headers prh ' ||
1121: 'where glsob.set_of_books_id = fsp.set_of_books_id ' ||
1122: 'and glp.period_set_name = glsob.period_set_name ' ||

Line 1307: 'po_req_distributions pord ' ||

1303: 'po_lines pol, ' ||
1304: 'po_headers poh, ' ||
1305: 'po_requisition_headers prh, ' ||
1306: 'po_requisition_lines porl, ' ||
1307: 'po_req_distributions pord ' ||
1308: 'where glsob.set_of_books_id = fsp.set_of_books_id ' ||
1309: 'and glp.period_set_name = glsob.period_set_name ' ||
1310: 'and glp.period_name = nvl(:override_period, pod.gl_encumbered_period_name) ' ||
1311: 'and doc_cur.currency_code = poh.currency_code ' ||

Line 1394: 'po_req_distributions pord, ' ||

1390: 'from gl_periods glp, ' ||
1391: 'gl_sets_of_books glsob, ' ||
1392: 'financials_system_parameters fsp, ' ||
1393: 'fnd_currencies base_cur, ' ||
1394: 'po_req_distributions pord, ' ||
1395: 'po_requisition_lines porl, ' ||
1396: 'po_requisition_headers prh, ' ||
1397: 'po_distributions pod, ' ||
1398: 'po_line_locations poll ' ||

Line 1602: 'po_req_distributions pord ' ||

1598: 'po_releases por, ' ||
1599: 'po_headers poh, ' ||
1600: 'po_requisition_headers prh, ' ||
1601: 'po_requisition_lines porl, ' ||
1602: 'po_req_distributions pord ' ||
1603: 'where glsob.set_of_books_id = fsp.set_of_books_id ' ||
1604: 'and glp.period_set_name = glsob.period_set_name ' ||
1605: 'and glp.period_name = nvl(:override_period, pod.gl_encumbered_period_name) ' ||
1606: 'and doc_cur.currency_code = poh.currency_code ' ||

Line 1690: 'po_req_distributions pord, ' ||

1686: 'from gl_periods glp, ' ||
1687: 'gl_sets_of_books glsob, ' ||
1688: 'financials_system_parameters fsp, ' ||
1689: 'fnd_currencies base_cur, ' ||
1690: 'po_req_distributions pord, ' ||
1691: 'po_requisition_lines porl, ' ||
1692: 'po_requisition_headers prh, ' ||
1693: 'po_distributions pod, ' ||
1694: 'po_line_locations poll ' ||

Line 1899: 'po_req_distributions pord ' ||

1895: 'po_releases por, ' ||
1896: 'po_distributions pod, ' ||
1897: 'po_requisition_headers prh, ' ||
1898: 'po_requisition_lines porl, ' ||
1899: 'po_req_distributions pord ' ||
1900: 'where glsob.set_of_books_id = fsp.set_of_books_id ' ||
1901: 'and glp.period_set_name = glsob.period_set_name ' ||
1902: 'and glp.period_name = nvl(:override_period, prd.gl_encumbered_period_name) ' ||
1903: 'and doc_cur.currency_code = poh.currency_code ' ||

Line 2002: 'po_req_distributions pord ' ||

1998: 'po_distributions pod, ' ||
1999: 'po_line_locations poll, ' ||
2000: 'po_requisition_headers prh, ' ||
2001: 'po_requisition_lines porl, ' ||
2002: 'po_req_distributions pord ' ||
2003: 'where glsob.set_of_books_id = fsp.set_of_books_id ' ||
2004: 'and glp.period_set_name = glsob.period_set_name ' ||
2005: 'and glp.period_name = nvl(:override_period, pod.gl_encumbered_period_name) ' ||
2006: 'and doc_cur.currency_code = poh.currency_code ' ||

Line 2384: update po_req_distributions

2380: -- Action is 'REVERSE' or 'LIQUIDATE'
2381:
2382: if g_fclevel = 'HEADER' then
2383:
2384: update po_req_distributions
2385: set encumbered_flag = decode(g_fcmode, 'RESERVE', 'Y', 'N')
2386: where requisition_line_id in
2387: (select porl.requisition_line_id
2388: from po_requisition_lines porl

Line 2398: update po_req_distributions

2394: 'Rolled up Encumbrance Flag for ' || SQL%ROWCOUNT || ' Requisitions' || g_delim;
2395: END IF;
2396: elsif g_fclevel = 'LINE' then
2397:
2398: update po_req_distributions
2399: set encumbered_flag = decode(g_fcmode, 'RESERVE', 'Y', 'N')
2400: where requisition_line_id = g_lineid;
2401:
2402: -- FRKHAN bug 941171

Line 2431: from po_req_distributions pord

2427:
2428: update po_requisition_lines porl
2429: set encumbered_flag =
2430: (select decode(count(pord.distribution_id), 0, 'Y', 'N')
2431: from po_req_distributions pord
2432: where pord.requisition_line_id = porl.requisition_line_id
2433: and pord.encumbered_flag = 'N')
2434: where porl.requisition_header_id = g_docid;
2435: -- FRKHAN bug 941171

Line 2478: update po_req_distributions

2474: -- Preset encumbered_flag on Backing Doc
2475:
2476: if g_pomode in ('RESERVE', 'LIQUIDATE', 'REJECT') then
2477:
2478: update po_req_distributions
2479: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2480: 'REVERSE', 'Y', encumbered_flag)
2481: where distribution_id in
2482: (select req_distribution_id

Line 2490: update po_req_distributions

2486: else
2487:
2488: if g_recreate_demand = 'Y' then
2489:
2490: update po_req_distributions
2491: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2492: 'REVERSE', 'Y', encumbered_flag)
2493: where source_req_distribution_id in
2494: (select req_distribution_id

Line 2517: update po_req_distributions

2513: -- Preset encumbered_flag on Backing Doc
2514:
2515: if g_pomode in ('RESERVE', 'LIQUIDATE', 'REJECT') then
2516:
2517: update po_req_distributions
2518: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2519: 'REVERSE', 'Y', encumbered_flag)
2520: where distribution_id in
2521: (select req_distribution_id

Line 2529: update po_req_distributions

2525: else
2526:
2527: if g_recreate_demand = 'Y' then
2528:
2529: update po_req_distributions
2530: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2531: 'REVERSE', 'Y', encumbered_flag)
2532: where source_req_distribution_id in
2533: (select req_distribution_id

Line 2556: update po_req_distributions

2552: -- Preset encumbered_flag on Backing Doc
2553:
2554: if g_pomode in ('RESERVE', 'LIQUIDATE', 'REJECT') then
2555:
2556: update po_req_distributions
2557: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2558: 'REVERSE', 'Y', encumbered_flag)
2559: where distribution_id in
2560: (select req_distribution_id

Line 2568: update po_req_distributions

2564: else
2565:
2566: if g_recreate_demand = 'Y' then
2567:
2568: update po_req_distributions
2569: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2570: 'REVERSE', 'Y', encumbered_flag)
2571: where source_req_distribution_id in
2572: (select req_distribution_id

Line 2614: from po_req_distributions pord

2610:
2611: update po_requisition_lines porl
2612: set encumbered_flag =
2613: (select decode(count(pord.distribution_id), 0, 'Y', 'N')
2614: from po_req_distributions pord
2615: where pord.requisition_line_id = porl.requisition_line_id
2616: and pord.encumbered_flag = 'N')
2617: where porl.requisition_line_id in
2618: (select prd.requisition_line_id

Line 2620: po_req_distributions prd,

2616: and pord.encumbered_flag = 'N')
2617: where porl.requisition_line_id in
2618: (select prd.requisition_line_id
2619: from po_requisition_lines prl,
2620: po_req_distributions prd,
2621: po_distributions pod
2622: where prd.requisition_line_id = prl.requisition_line_id
2623: and prd.distribution_id = pod.req_distribution_id
2624: and pod.po_header_id = g_docid);

Line 2631: from po_req_distributions pord

2627:
2628: update po_requisition_lines porl
2629: set encumbered_flag =
2630: (select decode(count(pord.distribution_id), 0, 'Y', 'N')
2631: from po_req_distributions pord
2632: where pord.requisition_line_id = porl.requisition_line_id
2633: and pord.encumbered_flag = 'N')
2634: where porl.requisition_line_id in
2635: (select prd.requisition_line_id

Line 2637: po_req_distributions prd,

2633: and pord.encumbered_flag = 'N')
2634: where porl.requisition_line_id in
2635: (select prd.requisition_line_id
2636: from po_requisition_lines prl,
2637: po_req_distributions prd,
2638: po_distributions pod
2639: where prd.requisition_line_id = prl.requisition_line_id
2640: and prd.source_req_distribution_id = pod.req_distribution_id
2641: and pod.po_header_id = g_docid);

Line 2683: update po_req_distributions

2679: -- Preset encumbered_flag on Backing Doc
2680:
2681: if g_pomode in ('RESERVE', 'LIQUIDATE', 'REJECT') then
2682:
2683: update po_req_distributions
2684: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2685: 'REVERSE', 'Y', encumbered_flag)
2686: where distribution_id in
2687: (select req_distribution_id

Line 2695: update po_req_distributions

2691: else
2692:
2693: if g_recreate_demand = 'Y' then
2694:
2695: update po_req_distributions
2696: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2697: 'REVERSE', 'Y', encumbered_flag)
2698: where source_req_distribution_id in
2699: (select req_distribution_id

Line 2722: update po_req_distributions

2718: -- Preset encumbered_flag on Backing Doc
2719:
2720: if g_pomode in ('RESERVE', 'LIQUIDATE', 'REJECT') then
2721:
2722: update po_req_distributions
2723: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2724: 'REVERSE', 'Y', encumbered_flag)
2725: where distribution_id in
2726: (select req_distribution_id

Line 2734: update po_req_distributions

2730: else
2731:
2732: if g_recreate_demand = 'Y' then
2733:
2734: update po_req_distributions
2735: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2736: 'REVERSE', 'Y', encumbered_flag)
2737: where source_req_distribution_id in
2738: (select req_distribution_id

Line 2761: update po_req_distributions

2757: -- Preset encumbered_flag on Backing Doc
2758:
2759: if g_pomode in ('RESERVE', 'LIQUIDATE', 'REJECT') then
2760:
2761: update po_req_distributions
2762: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2763: 'REVERSE', 'Y', encumbered_flag)
2764: where distribution_id in
2765: (select req_distribution_id

Line 2773: update po_req_distributions

2769: else
2770:
2771: if g_recreate_demand = 'Y' then
2772:
2773: update po_req_distributions
2774: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2775: 'REVERSE', 'Y', encumbered_flag)
2776: where source_req_distribution_id in
2777: (select req_distribution_id

Line 2819: from po_req_distributions pord

2815:
2816: update po_requisition_lines porl
2817: set encumbered_flag =
2818: (select decode(count(pord.distribution_id), 0, 'Y', 'N')
2819: from po_req_distributions pord
2820: where pord.requisition_line_id = porl.requisition_line_id
2821: and pord.encumbered_flag = 'N')
2822: where porl.requisition_line_id in
2823: (select prd.requisition_line_id

Line 2825: po_req_distributions prd,

2821: and pord.encumbered_flag = 'N')
2822: where porl.requisition_line_id in
2823: (select prd.requisition_line_id
2824: from po_requisition_lines prl,
2825: po_req_distributions prd,
2826: po_distributions pod
2827: where prd.requisition_line_id = prl.requisition_line_id
2828: and prd.distribution_id = pod.req_distribution_id
2829: and pod.po_release_id = g_docid);

Line 2836: from po_req_distributions pord

2832:
2833: update po_requisition_lines porl
2834: set encumbered_flag =
2835: (select decode(count(pord.distribution_id), 0, 'Y', 'N')
2836: from po_req_distributions pord
2837: where pord.requisition_line_id = porl.requisition_line_id
2838: and pord.encumbered_flag = 'N')
2839: where porl.requisition_line_id in
2840: (select prd.requisition_line_id

Line 2842: po_req_distributions prd,

2838: and pord.encumbered_flag = 'N')
2839: where porl.requisition_line_id in
2840: (select prd.requisition_line_id
2841: from po_requisition_lines prl,
2842: po_req_distributions prd,
2843: po_distributions pod
2844: where prd.requisition_line_id = prl.requisition_line_id
2845: and prd.source_req_distribution_id = pod.req_distribution_id
2846: and pod.po_release_id = g_docid);

Line 3072: update po_req_distributions

3068: if c_pkt.status_code = 'A' then
3069:
3070: -- Update encumbered_flag if packet has passed
3071:
3072: update po_req_distributions
3073: set encumbered_flag =
3074: decode(sign(c_pkt.accounted_dr - c_pkt.accounted_cr), 1, 'Y', 0, encumbered_flag, 'N')
3075: where distribution_id = c_pkt.dist_id;
3076:

Line 3082: update po_req_distributions

3078: if c_pkt.automatic_encumbrance_flag = 'Y' then
3079:
3080: -- Update encumbered_amount if packet has passed
3081:
3082: update po_req_distributions
3083: set encumbered_amount =
3084: round((nvl(encumbered_amount, 0) + c_pkt.accounted_dr - c_pkt.accounted_cr), 3)
3085: where distribution_id = c_pkt.dist_id;
3086:

Line 3093: update po_req_distributions

3089: elsif c_pkt.status_code = 'R' then
3090:
3091: -- Update encumbered_flag if packet has failed
3092:
3093: update po_req_distributions
3094: set encumbered_flag =
3095: decode(sign(c_pkt.accounted_dr - c_pkt.accounted_cr), 1, 'N', 0, encumbered_flag, 'Y')
3096: where distribution_id = c_pkt.dist_id;
3097:

Line 3122: update po_req_distributions

3118:
3119: elsif ((c_pkt.doc_type = 'REQ') and
3120: (c_pkt.status_code in ('R', 'F', 'T'))) then
3121:
3122: update po_req_distributions
3123: set failed_funds_lookup_code = c_pkt.result_code
3124: where distribution_id = c_pkt.dist_id;
3125:
3126: end if;

Line 3206: po_req_distributions prd

3202: gll.meaning
3203: from gl_bc_packets gbp,
3204: gl_lookups gll,
3205: po_requisition_lines prl,
3206: po_req_distributions prd
3207: where gbp.packet_id = g_packetid
3208: and gbp.status_code in ('R', 'F', 'T')
3209: and gbp.result_code = gll.lookup_code
3210: and gll.lookup_type = 'FUNDS_CHECK_RESULT_CODE'