APPS.PO_FUNDS_CHECKER dependencies on PO_LINE_LOCATIONS

Line 1302: 'po_line_locations poll, ' ||

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, ' ||
1306: 'po_requisition_lines porl, ' ||

Line 1398: 'po_line_locations poll ' ||

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) ' ||
1402: 'and base_cur.currency_code = glsob.currency_code ' ||

Line 1596: 'po_line_locations poll, ' ||

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, ' ||
1600: 'po_requisition_headers prh, ' ||

Line 1694: 'po_line_locations poll ' ||

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) ' ||
1698: 'and base_cur.currency_code = glsob.currency_code ' ||

Line 1892: 'po_line_locations prll, ' ||

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, ' ||
1896: 'po_distributions pod, ' ||

Line 1994: 'po_line_locations prll, ' ||

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, ' ||
1998: 'po_distributions pod, ' ||

Line 1999: 'po_line_locations poll, ' ||

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

Line 2272: -- Rollup encumbered_flag on the Distributions to po_line_locations and

2268: END po_fc_run;
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:

Line 2598: update po_line_locations poll

2594:
2595:
2596: -- Rollup to Line Locations
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

Line 2803: update po_line_locations poll

2799:
2800:
2801: -- Rollup to Line Locations
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

Line 2954: update po_line_locations poll

2950:
2951:
2952: -- Rollup to Line Locations
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

Line 2965: update po_line_locations poll

2961:
2962:
2963: -- Rollup to Requisition Lines on Backing Document
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

Line 3250: po_line_locations poll,

3246: gll.meaning
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