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_DISTRIBUTIONS

Line 1301: 'po_distributions pod, ' ||

1297: 'from gl_periods glp, ' ||
1298: 'gl_sets_of_books glsob, ' ||
1299: 'financials_system_parameters fsp, ' ||
1300: 'fnd_currencies doc_cur, ' ||
1301: 'po_distributions pod, ' ||
1302: 'po_line_locations poll, ' ||
1303: 'po_lines pol, ' ||
1304: 'po_headers poh, ' ||
1305: 'po_requisition_headers prh, ' ||

Line 1397: 'po_distributions pod, ' ||

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 ' ||
1399: 'where glsob.set_of_books_id = fsp.set_of_books_id ' ||
1400: 'and glp.period_set_name = glsob.period_set_name ' ||
1401: 'and glp.period_name = nvl(:override_period, pod.gl_encumbered_period_name) ' ||

Line 1595: 'po_distributions pod, ' ||

1591: 'from gl_periods glp, ' ||
1592: 'gl_sets_of_books glsob, ' ||
1593: 'financials_system_parameters fsp, ' ||
1594: 'fnd_currencies doc_cur, ' ||
1595: 'po_distributions pod, ' ||
1596: 'po_line_locations poll, ' ||
1597: 'po_lines pol, ' ||
1598: 'po_releases por, ' ||
1599: 'po_headers poh, ' ||

Line 1693: 'po_distributions pod, ' ||

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 ' ||
1695: 'where glsob.set_of_books_id = fsp.set_of_books_id ' ||
1696: 'and glp.period_set_name = glsob.period_set_name ' ||
1697: 'and glp.period_name = nvl(:override_period, pod.gl_encumbered_period_name) ' ||

Line 1891: 'po_distributions prd, ' ||

1887: 'from gl_periods glp, ' ||
1888: 'gl_sets_of_books glsob, ' ||
1889: 'financials_system_parameters fsp, ' ||
1890: 'fnd_currencies doc_cur, ' ||
1891: 'po_distributions prd, ' ||
1892: 'po_line_locations prll, ' ||
1893: 'po_lines pol, ' ||
1894: 'po_headers poh, ' ||
1895: 'po_releases por, ' ||

Line 1896: 'po_distributions pod, ' ||

1892: 'po_line_locations prll, ' ||
1893: 'po_lines pol, ' ||
1894: 'po_headers poh, ' ||
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 ' ||

Line 1993: 'po_distributions prd, ' ||

1989: 'from gl_periods glp, ' ||
1990: 'gl_sets_of_books glsob, ' ||
1991: 'financials_system_parameters fsp, ' ||
1992: 'fnd_currencies doc_cur, ' ||
1993: 'po_distributions prd, ' ||
1994: 'po_line_locations prll, ' ||
1995: 'po_lines pol, ' ||
1996: 'po_headers poh, ' ||
1997: 'po_releases por, ' ||

Line 1998: 'po_distributions pod, ' ||

1994: 'po_line_locations prll, ' ||
1995: 'po_lines pol, ' ||
1996: 'po_headers poh, ' ||
1997: 'po_releases por, ' ||
1998: 'po_distributions pod, ' ||
1999: 'po_line_locations poll, ' ||
2000: 'po_requisition_headers prh, ' ||
2001: 'po_requisition_lines porl, ' ||
2002: 'po_req_distributions pord ' ||

Line 2467: update po_distributions

2463: if g_fclevel = 'HEADER' then
2464:
2465: -- Preset encumbered_flag on Main Doc
2466:
2467: update po_distributions
2468: set encumbered_flag = decode(g_pomode, 'RESERVE', 'Y', 'REVERSE', 'N',
2469: 'LIQUIDATE', 'N', 'REJECT',
2470: encumbered_flag, 'N')
2471: where po_header_id = g_docid;

Line 2483: from po_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
2483: from po_distributions
2484: where po_header_id = g_docid);
2485:
2486: else
2487:

Line 2495: from po_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
2495: from po_distributions
2496: where po_header_id = g_docid);
2497:
2498: end if;
2499:

Line 2506: update po_distributions

2502: elsif g_fclevel = 'LINE' then
2503:
2504: -- Preset encumbered_flag on Main Doc
2505:
2506: update po_distributions
2507: set encumbered_flag = decode(g_pomode, 'RESERVE', 'Y', 'REVERSE', 'N',
2508: 'LIQUIDATE', 'N', 'REJECT',
2509: encumbered_flag, 'N')
2510: where po_line_id = g_lineid;

Line 2522: from po_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
2522: from po_distributions
2523: where po_line_id = g_lineid);
2524:
2525: else
2526:

Line 2534: from po_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
2534: from po_distributions
2535: where po_line_id = g_lineid);
2536:
2537: end if;
2538:

Line 2545: update po_distributions

2541: elsif g_fclevel = 'SHIPMENT' then
2542:
2543: -- Preset encumbered_flag on Main Doc
2544:
2545: update po_distributions
2546: set encumbered_flag = decode(g_pomode, 'RESERVE', 'Y', 'REVERSE', 'N',
2547: 'LIQUIDATE', 'N', 'REJECT',
2548: encumbered_flag, 'N')
2549: where line_location_id = g_shipid;

Line 2561: from po_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
2561: from po_distributions
2562: where line_location_id = g_shipid);
2563:
2564: else
2565:

Line 2573: from po_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
2573: from po_distributions
2574: where line_location_id = g_shipid);
2575:
2576: end if;
2577:

Line 2601: from po_distributions pod

2597:
2598: update po_line_locations poll
2599: set encumbered_flag =
2600: (select decode(count(pod.po_distribution_id), 0, 'Y', 'N')
2601: from po_distributions pod
2602: where pod.line_location_id = poll.line_location_id
2603: and pod.encumbered_flag = 'N')
2604: where poll.po_header_id = g_docid;
2605:

Line 2621: po_distributions pod

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);
2625:

Line 2638: po_distributions pod

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);
2642:

Line 2672: update po_distributions

2668: if g_fclevel = 'HEADER' then
2669:
2670: -- Preset encumbered_flag on Main Doc
2671:
2672: update po_distributions
2673: set encumbered_flag = decode(g_pomode, 'RESERVE', 'Y', 'REVERSE', 'N',
2674: 'LIQUIDATE', 'N', 'REJECT',
2675: encumbered_flag, 'N')
2676: where po_release_id = g_docid;

Line 2688: from po_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
2688: from po_distributions
2689: where po_release_id = g_docid);
2690:
2691: else
2692:

Line 2700: from po_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
2700: from po_distributions
2701: where po_release_id = g_docid);
2702:
2703: end if;
2704:

Line 2711: update po_distributions

2707: elsif g_fclevel = 'LINE' then
2708:
2709: -- Preset encumbered_flag on Main Doc
2710:
2711: update po_distributions
2712: set encumbered_flag = decode(g_pomode, 'RESERVE', 'Y', 'REVERSE', 'N',
2713: 'LIQUIDATE', 'N', 'REJECT',
2714: encumbered_flag, 'N')
2715: where po_line_id = g_lineid;

Line 2727: from po_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
2727: from po_distributions
2728: where po_line_id = g_lineid);
2729:
2730: else
2731:

Line 2739: from po_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
2739: from po_distributions
2740: where po_line_id = g_lineid);
2741:
2742: end if;
2743:

Line 2750: update po_distributions

2746: elsif g_fclevel = 'SHIPMENT' then
2747:
2748: -- Preset encumbered_flag on Main Doc
2749:
2750: update po_distributions
2751: set encumbered_flag = decode(g_pomode, 'RESERVE', 'Y', 'REVERSE', 'N',
2752: 'LIQUIDATE', 'N', 'REJECT',
2753: encumbered_flag, 'N')
2754: where line_location_id = g_shipid;

Line 2766: from po_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
2766: from po_distributions
2767: where line_location_id = g_shipid);
2768:
2769: else
2770:

Line 2778: from po_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
2778: from po_distributions
2779: where line_location_id = g_shipid);
2780:
2781: end if;
2782:

Line 2806: from po_distributions pod

2802:
2803: update po_line_locations poll
2804: set encumbered_flag =
2805: (select decode(count(pod.po_distribution_id), 0, 'Y', 'N')
2806: from po_distributions pod
2807: where pod.line_location_id = poll.line_location_id
2808: and pod.encumbered_flag = 'N')
2809: where poll.po_release_id = g_docid;
2810:

Line 2826: po_distributions pod

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);
2830:

Line 2843: po_distributions pod

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);
2847:

Line 2877: update po_distributions

2873: if g_fclevel = 'HEADER' then
2874:
2875: -- Preset encumbered_flag on Main Doc
2876:
2877: update po_distributions
2878: set encumbered_flag = decode(g_pomode, 'RESERVE', 'Y', 'REVERSE', 'N',
2879: 'LIQUIDATE', 'N', 'REJECT',
2880: encumbered_flag, 'N')
2881: where po_release_id = g_docid;

Line 2886: update po_distributions

2882:
2883:
2884: -- Preset encumbered_flag on Backing Doc
2885:
2886: update po_distributions
2887: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2888: 'REVERSE', 'Y', encumbered_flag)
2889: where po_distribution_id in
2890: (select po_distribution_id

Line 2891: from po_distributions

2887: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2888: 'REVERSE', 'Y', encumbered_flag)
2889: where po_distribution_id in
2890: (select po_distribution_id
2891: from po_distributions
2892: where po_release_id = g_docid);
2893:
2894: elsif g_fclevel = 'LINE' then
2895:

Line 2898: update po_distributions

2894: elsif g_fclevel = 'LINE' then
2895:
2896: -- Preset encumbered_flag on Main Doc
2897:
2898: update po_distributions
2899: set encumbered_flag = decode(g_pomode, 'RESERVE', 'Y', 'REVERSE', 'N',
2900: 'LIQUIDATE', 'N', 'REJECT',
2901: encumbered_flag, 'N')
2902: where po_line_id = g_lineid;

Line 2907: update po_distributions

2903:
2904:
2905: -- Preset encumbered_flag on Backing Doc
2906:
2907: update po_distributions
2908: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2909: 'REVERSE', 'Y', encumbered_flag)
2910: where po_distribution_id in
2911: (select po_distribution_id

Line 2912: from po_distributions

2908: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2909: 'REVERSE', 'Y', encumbered_flag)
2910: where po_distribution_id in
2911: (select po_distribution_id
2912: from po_distributions
2913: where po_line_id = g_lineid);
2914:
2915: elsif g_fclevel = 'SHIPMENT' then
2916:

Line 2919: update po_distributions

2915: elsif g_fclevel = 'SHIPMENT' then
2916:
2917: -- Preset encumbered_flag on Main Doc
2918:
2919: update po_distributions
2920: set encumbered_flag = decode(g_pomode, 'RESERVE', 'Y', 'REVERSE', 'N',
2921: 'LIQUIDATE', 'N', 'REJECT',
2922: encumbered_flag, 'N')
2923: where line_location_id = g_shipid;

Line 2928: update po_distributions

2924:
2925:
2926: -- Preset encumbered_flag on Backing Doc
2927:
2928: update po_distributions
2929: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2930: 'REVERSE', 'Y', encumbered_flag)
2931: where po_distribution_id in
2932: (select po_distribution_id

Line 2933: from po_distributions

2929: set encumbered_flag = decode(g_pomode, 'RESERVE', 'N',
2930: 'REVERSE', 'Y', encumbered_flag)
2931: where po_distribution_id in
2932: (select po_distribution_id
2933: from po_distributions
2934: where line_location_id = g_shipid);
2935:
2936: end if;
2937:

Line 2957: from po_distributions pod

2953:
2954: update po_line_locations poll
2955: set encumbered_flag =
2956: (select decode(count(pod.po_distribution_id), 0, 'Y', 'N')
2957: from po_distributions pod
2958: where pod.line_location_id = poll.line_location_id
2959: and pod.encumbered_flag = 'N')
2960: where poll.po_release_id = g_docid;
2961:

Line 2968: from po_distributions pod

2964:
2965: update po_line_locations poll
2966: set encumbered_flag =
2967: (select decode(count(pod.po_distribution_id), 0, 'Y', 'N')
2968: from po_distributions pod
2969: where pod.line_location_id = poll.line_location_id
2970: and pod.encumbered_flag = 'N')
2971: where poll.line_location_id in
2972: (select pod.line_location_id

Line 2973: from po_distributions pod,

2969: where pod.line_location_id = poll.line_location_id
2970: and pod.encumbered_flag = 'N')
2971: where poll.line_location_id in
2972: (select pod.line_location_id
2973: from po_distributions pod,
2974: po_distributions prd
2975: where pod.po_distribution_id = prd.source_distribution_id
2976: and prd.po_release_id = g_docid);
2977:

Line 2974: po_distributions prd

2970: and pod.encumbered_flag = 'N')
2971: where poll.line_location_id in
2972: (select pod.line_location_id
2973: from po_distributions pod,
2974: po_distributions prd
2975: where pod.po_distribution_id = prd.source_distribution_id
2976: and prd.po_release_id = g_docid);
2977:
2978: return(TRUE);

Line 3038: update po_distributions

3034: if c_pkt.status_code = 'A' then
3035:
3036: -- Update encumbered_flag if packet has passed
3037:
3038: update po_distributions
3039: set encumbered_flag =
3040: decode(sign(c_pkt.accounted_dr - c_pkt.accounted_cr), 1, 'Y', 0, encumbered_flag, 'N')
3041: where po_distribution_id = c_pkt.dist_id;
3042:

Line 3048: update po_distributions

3044: if c_pkt.automatic_encumbrance_flag = 'Y' then
3045:
3046: -- Update encumbered_amount if packet has passed
3047:
3048: update po_distributions
3049: set encumbered_amount =
3050: round((nvl(encumbered_amount, 0) + c_pkt.accounted_dr - c_pkt.accounted_cr), 3)
3051: where po_distribution_id = c_pkt.dist_id;
3052:

Line 3059: update po_distributions

3055: elsif c_pkt.status_code = 'R' then
3056:
3057: -- Update encumbered_flag if packet has failed
3058:
3059: update po_distributions
3060: set encumbered_flag =
3061: decode(sign(c_pkt.accounted_dr - c_pkt.accounted_cr), 1, 'N', 0, encumbered_flag, 'Y')
3062: where po_distribution_id = c_pkt.dist_id;
3063:

Line 3115: update po_distributions

3111:
3112: if ((c_pkt.doc_type = 'PO') and
3113: (c_pkt.status_code in ('R', 'F', 'T'))) then
3114:
3115: update po_distributions
3116: set failed_funds_lookup_code = c_pkt.result_code
3117: where po_distribution_id = c_pkt.dist_id;
3118:
3119: elsif ((c_pkt.doc_type = 'REQ') and

Line 3251: po_distributions pod

3247: from gl_bc_packets gbp,
3248: gl_lookups gll,
3249: po_lines pol,
3250: po_line_locations poll,
3251: po_distributions pod
3252: where gbp.packet_id = g_packetid
3253: and gbp.status_code in ('R', 'F', 'T')
3254: and gbp.result_code = gll.lookup_code
3255: and gll.lookup_type = 'FUNDS_CHECK_RESULT_CODE'