APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 157: l_po_release_id po_line_locations_all.po_release_id%TYPE;

153: l_po_header_id po_headers_all.po_header_id%TYPE;
154: l_po_line_id po_lines_all.po_line_id%TYPE;
155:
156: l_cancel_flag po_lines_all.cancel_flag%TYPE;
157: l_po_release_id po_line_locations_all.po_release_id%TYPE;
158:
159: l_manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE;
160:
161: -- Bug 5684304: Removed the prefix 'Subcontracting Order '

Line 173: , po_line_locations_all loc

169: to_char(re.release_num) || ',' || to_char(h.revision_num) REPORT_TITLE_NUM
170: ,re.release_num
171: FROM po_headers_all h
172: , po_lines_all l
173: , po_line_locations_all loc
174: , po_releases_all re
175: WHERE re.po_release_id = loc.po_release_id
176: AND loc.po_line_id = lp_po_line_id
177: AND l.po_header_id = lp_po_header_id

Line 303: po_line_locations_all loc,

299: , l.po_line_id
300: , loc.po_release_id
301: FROM po_headers_all h,
302: po_lines_all l,
303: po_line_locations_all loc,
304: jmf_subcontract_orders sub,
305: mtl_system_items_vl mtl,
306: po_vendor_sites_all pvsa,
307: hr_locations_all hrloc,