APPS.PO_EMAIL_GENERATE dependencies on PO_DISTRIBUTIONS

Line 129: l_requestor_name po_distributions_print.requestor_name%TYPE;

125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
126: l_cancel_date po_line_locations_all.cancel_date%TYPE;
127: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
128:
129: l_requestor_name po_distributions_print.requestor_name%TYPE;
130: l_requestor_id po_distributions_print.requestor_id%TYPE;
131:
132: /* Bug 2870932 increased the size */
133: l_phone per_all_people_f.work_telephone%TYPE;

Line 130: l_requestor_id po_distributions_print.requestor_id%TYPE;

126: l_cancel_date po_line_locations_all.cancel_date%TYPE;
127: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
128:
129: l_requestor_name po_distributions_print.requestor_name%TYPE;
130: l_requestor_id po_distributions_print.requestor_id%TYPE;
131:
132: /* Bug 2870932 increased the size */
133: l_phone per_all_people_f.work_telephone%TYPE;
134: l_email_address per_all_people_f.email_address%TYPE;

Line 430: FROM po_distributions pdp

426: order by line_num, pll.shipment_num asc; --
427:
428: cursor requestor_cursor (v_line_location_id NUMBER) IS
429: select distinct deliver_to_person_id
430: FROM po_distributions pdp
431: WHERE pdp.line_location_id = v_line_location_id;
432:
433: l_document_status varchar2(100);
434:

Line 2706: FROM po_distributions

2702: x_subtype po_headers.type_lookup_code%TYPE;
2703:
2704: cursor po_requestor_cursor (v_po_header_id varchar2) IS
2705: select distinct deliver_to_person_id
2706: FROM po_distributions
2707: WHERE po_header_id = v_po_header_id
2708: AND distribution_type <> 'AGREEMENT'; --
2709:
2710: cursor release_requestor_cursor (v_po_release_id varchar2) IS

Line 2712: FROM po_distributions

2708: AND distribution_type <> 'AGREEMENT'; --
2709:
2710: cursor release_requestor_cursor (v_po_release_id varchar2) IS
2711: select distinct deliver_to_person_id
2712: FROM po_distributions
2713: WHERE po_release_id = v_po_release_id;
2714:
2715:
2716: cursor release_location_id_cursor (v_po_release_id varchar2) IS