APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on PO_HEADERS_ALL

Line 150: l_print_count po_headers_all.print_count%TYPE;

146: l_AGENT_ID jmf_shikyu_spr_rpt_temp.AGENT_ID%TYPE ;
147: l_VENDOR_ID jmf_shikyu_spr_rpt_temp.VENDOR_ID%TYPE ;
148: l_ITEM_ID jmf_shikyu_spr_rpt_temp.ITEM_ID%TYPE ;
149:
150: l_print_count po_headers_all.print_count%TYPE;
151: l_printed_date po_headers_all.printed_date%TYPE;
152: l_type_lookup_code po_headers_all.type_lookup_code%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;

Line 151: l_printed_date po_headers_all.printed_date%TYPE;

147: l_VENDOR_ID jmf_shikyu_spr_rpt_temp.VENDOR_ID%TYPE ;
148: l_ITEM_ID jmf_shikyu_spr_rpt_temp.ITEM_ID%TYPE ;
149:
150: l_print_count po_headers_all.print_count%TYPE;
151: l_printed_date po_headers_all.printed_date%TYPE;
152: l_type_lookup_code po_headers_all.type_lookup_code%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:

Line 152: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

148: l_ITEM_ID jmf_shikyu_spr_rpt_temp.ITEM_ID%TYPE ;
149:
150: l_print_count po_headers_all.print_count%TYPE;
151: l_printed_date po_headers_all.printed_date%TYPE;
152: l_type_lookup_code po_headers_all.type_lookup_code%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;

Line 153: l_po_header_id po_headers_all.po_header_id%TYPE;

149:
150: l_print_count po_headers_all.print_count%TYPE;
151: l_printed_date po_headers_all.printed_date%TYPE;
152: l_type_lookup_code po_headers_all.type_lookup_code%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;

Line 171: FROM po_headers_all h

167: , lp_po_release_id NUMBER ) IS
168: SELECT h.segment1 || '-' || to_char(l.line_num) || '-' ||
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

Line 301: FROM po_headers_all h,

297: , h.type_lookup_code
298: , h.po_header_id
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,