APPS.PO_FUNDS_CHECKER dependencies on PO_REQUISITION_LINES

Line 1119: 'po_requisition_lines porl, ' ||

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 ' ||
1123: 'and glp.period_name = nvl(:override_period, pord.gl_encumbered_period_name) ' ||

Line 1306: 'po_requisition_lines porl, ' ||

1302: 'po_line_locations poll, ' ||
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) ' ||

Line 1395: 'po_requisition_lines porl, ' ||

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 ' ||
1399: 'where glsob.set_of_books_id = fsp.set_of_books_id ' ||

Line 1601: 'po_requisition_lines porl, ' ||

1597: 'po_lines pol, ' ||
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) ' ||

Line 1691: 'po_requisition_lines porl, ' ||

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 ' ||
1695: 'where glsob.set_of_books_id = fsp.set_of_books_id ' ||

Line 1898: 'po_requisition_lines porl, ' ||

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 ' ||
1901: 'and glp.period_set_name = glsob.period_set_name ' ||
1902: 'and glp.period_name = nvl(:override_period, prd.gl_encumbered_period_name) ' ||

Line 2001: 'po_requisition_lines porl, ' ||

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 ' ||
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) ' ||

Line 2273: -- po_requisition_lines

2269:
2270: /* ----------------------------------------------------------------------- */
2271:
2272: -- Rollup encumbered_flag on the Distributions to po_line_locations and
2273: -- po_requisition_lines
2274:
2275: FUNCTION po_rollup_enc RETURN BOOLEAN IS
2276:
2277: BEGIN

Line 2388: from po_requisition_lines porl

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
2389: where porl.requisition_header_id = g_docid
2390: and porl.line_location_id is null);
2391: -- FRKHAN bug 941171
2392: IF LENGTH (g_dbug) < x_max_length THEN

Line 2428: update po_requisition_lines porl

2424:
2425:
2426: -- Rollup Encumbrance State to Requisition Lines
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

Line 2611: update po_requisition_lines porl

2607: -- Rollup to Requisition Lines on Backing Document
2608:
2609: if g_pomode in ('RESERVE', 'LIQUIDATE', 'REJECT') then
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

Line 2619: from po_requisition_lines prl,

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
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

Line 2628: update po_requisition_lines porl

2624: and pod.po_header_id = g_docid);
2625:
2626: else
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

Line 2636: from po_requisition_lines prl,

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
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

Line 2816: update po_requisition_lines porl

2812: -- Rollup to Requisition Lines on Backing Document
2813:
2814: if g_pomode in ('RESERVE', 'LIQUIDATE', 'REJECT') then
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

Line 2824: from po_requisition_lines prl,

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
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

Line 2833: update po_requisition_lines porl

2829: and pod.po_release_id = g_docid);
2830:
2831: else
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

Line 2841: from po_requisition_lines prl,

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
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

Line 3205: po_requisition_lines prl,

3201: to_char(prd.distribution_num) || ' ' ||
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