eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_EMAIL_GENERATE dependencies on PO_LINES

Line 37: line_num po_lines_all.line_num%TYPE,

33:
34: c_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_EMAIL_GENERATE.'; -- Bug 2792156
35:
36: TYPE shipment_record IS RECORD (
37: line_num po_lines_all.line_num%TYPE,
38: po_line_id po_lines_all.po_line_id%TYPE,
39: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
40: item_revision po_lines_all.item_revision%TYPE,
41: vendor_product_num po_lines.vendor_product_num%TYPE, /* Bug 3105566 */

Line 38: po_line_id po_lines_all.po_line_id%TYPE,

34: c_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_EMAIL_GENERATE.'; -- Bug 2792156
35:
36: TYPE shipment_record IS RECORD (
37: line_num po_lines_all.line_num%TYPE,
38: po_line_id po_lines_all.po_line_id%TYPE,
39: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
40: item_revision po_lines_all.item_revision%TYPE,
41: vendor_product_num po_lines.vendor_product_num%TYPE, /* Bug 3105566 */
42: item_desc po_lines.item_description%TYPE,

Line 40: item_revision po_lines_all.item_revision%TYPE,

36: TYPE shipment_record IS RECORD (
37: line_num po_lines_all.line_num%TYPE,
38: po_line_id po_lines_all.po_line_id%TYPE,
39: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
40: item_revision po_lines_all.item_revision%TYPE,
41: vendor_product_num po_lines.vendor_product_num%TYPE, /* Bug 3105566 */
42: item_desc po_lines.item_description%TYPE,
43: uom mtl_units_of_measure_tl.unit_of_measure_tl%TYPE, /* Bug 2701946 */
44: quantity po_line_locations.quantity%TYPE,

Line 41: vendor_product_num po_lines.vendor_product_num%TYPE, /* Bug 3105566 */

37: line_num po_lines_all.line_num%TYPE,
38: po_line_id po_lines_all.po_line_id%TYPE,
39: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
40: item_revision po_lines_all.item_revision%TYPE,
41: vendor_product_num po_lines.vendor_product_num%TYPE, /* Bug 3105566 */
42: item_desc po_lines.item_description%TYPE,
43: uom mtl_units_of_measure_tl.unit_of_measure_tl%TYPE, /* Bug 2701946 */
44: quantity po_line_locations.quantity%TYPE,
45: unit_price po_lines.unit_price%TYPE,

Line 42: item_desc po_lines.item_description%TYPE,

38: po_line_id po_lines_all.po_line_id%TYPE,
39: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
40: item_revision po_lines_all.item_revision%TYPE,
41: vendor_product_num po_lines.vendor_product_num%TYPE, /* Bug 3105566 */
42: item_desc po_lines.item_description%TYPE,
43: uom mtl_units_of_measure_tl.unit_of_measure_tl%TYPE, /* Bug 2701946 */
44: quantity po_line_locations.quantity%TYPE,
45: unit_price po_lines.unit_price%TYPE,
46: need_by_date po_line_locations.need_by_date%TYPE,

Line 45: unit_price po_lines.unit_price%TYPE,

41: vendor_product_num po_lines.vendor_product_num%TYPE, /* Bug 3105566 */
42: item_desc po_lines.item_description%TYPE,
43: uom mtl_units_of_measure_tl.unit_of_measure_tl%TYPE, /* Bug 2701946 */
44: quantity po_line_locations.quantity%TYPE,
45: unit_price po_lines.unit_price%TYPE,
46: need_by_date po_line_locations.need_by_date%TYPE,
47: promised_date po_line_locations.promised_date%TYPE,
48: taxable_flag po_line_locations.taxable_flag%TYPE,
49: note_to_vendor po_lines_all.note_to_vendor%TYPE,

Line 49: note_to_vendor po_lines_all.note_to_vendor%TYPE,

45: unit_price po_lines.unit_price%TYPE,
46: need_by_date po_line_locations.need_by_date%TYPE,
47: promised_date po_line_locations.promised_date%TYPE,
48: taxable_flag po_line_locations.taxable_flag%TYPE,
49: note_to_vendor po_lines_all.note_to_vendor%TYPE,
50: un_number_id po_lines_all.un_number_id%TYPE,
51: hazard_class_id po_lines_all.hazard_class_id%TYPE,
52: cancel_flag po_line_locations_all.cancel_flag%TYPE,
53: cancel_date po_line_locations_all.cancel_date%TYPE,

Line 50: un_number_id po_lines_all.un_number_id%TYPE,

46: need_by_date po_line_locations.need_by_date%TYPE,
47: promised_date po_line_locations.promised_date%TYPE,
48: taxable_flag po_line_locations.taxable_flag%TYPE,
49: note_to_vendor po_lines_all.note_to_vendor%TYPE,
50: un_number_id po_lines_all.un_number_id%TYPE,
51: hazard_class_id po_lines_all.hazard_class_id%TYPE,
52: cancel_flag po_line_locations_all.cancel_flag%TYPE,
53: cancel_date po_line_locations_all.cancel_date%TYPE,
54: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,

Line 51: hazard_class_id po_lines_all.hazard_class_id%TYPE,

47: promised_date po_line_locations.promised_date%TYPE,
48: taxable_flag po_line_locations.taxable_flag%TYPE,
49: note_to_vendor po_lines_all.note_to_vendor%TYPE,
50: un_number_id po_lines_all.un_number_id%TYPE,
51: hazard_class_id po_lines_all.hazard_class_id%TYPE,
52: cancel_flag po_line_locations_all.cancel_flag%TYPE,
53: cancel_date po_line_locations_all.cancel_date%TYPE,
54: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
55: item_id po_lines_all.item_id%TYPE,

Line 55: item_id po_lines_all.item_id%TYPE,

51: hazard_class_id po_lines_all.hazard_class_id%TYPE,
52: cancel_flag po_line_locations_all.cancel_flag%TYPE,
53: cancel_date po_line_locations_all.cancel_date%TYPE,
54: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
55: item_id po_lines_all.item_id%TYPE,
56: org_id po_line_locations_all.org_id%TYPE,
57: contract_num po_lines_all.contract_num%TYPE,
58: line_location_id po_line_locations_all.line_location_id%TYPE,
59: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,

Line 57: contract_num po_lines_all.contract_num%TYPE,

53: cancel_date po_line_locations_all.cancel_date%TYPE,
54: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
55: item_id po_lines_all.item_id%TYPE,
56: org_id po_line_locations_all.org_id%TYPE,
57: contract_num po_lines_all.contract_num%TYPE,
58: line_location_id po_line_locations_all.line_location_id%TYPE,
59: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
60: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
61: start_date po_line_locations_all.start_date%TYPE, /* */

Line 64: from_header_id po_lines_all.from_header_id%type,

60: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
61: start_date po_line_locations_all.start_date%TYPE, /* */
62: end_date po_line_locations_all.end_date%TYPE, /* */
63: --
64: from_header_id po_lines_all.from_header_id%type,
65: from_line_id po_lines_all.from_line_id%type
66: --
67: );
68:

Line 65: from_line_id po_lines_all.from_line_id%type

61: start_date po_line_locations_all.start_date%TYPE, /* */
62: end_date po_line_locations_all.end_date%TYPE, /* */
63: --
64: from_header_id po_lines_all.from_header_id%type,
65: from_line_id po_lines_all.from_line_id%type
66: --
67: );
68:
69:

Line 102: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;

98: l_blanket_total_amount NUMBER := 0;
99: x_subtype po_headers.type_lookup_code%TYPE;
100: l_datatype_count NUMBER := 0;
101:
102: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;
103: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;
104: l_po_header_id po_headers.po_header_id%TYPE;
105: l_src_ga_flag po_lines_print.SRC_GA_FLAG%TYPE; -- GA FPI
106:

Line 103: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;

99: x_subtype po_headers.type_lookup_code%TYPE;
100: l_datatype_count NUMBER := 0;
101:
102: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;
103: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;
104: l_po_header_id po_headers.po_header_id%TYPE;
105: l_src_ga_flag po_lines_print.SRC_GA_FLAG%TYPE; -- GA FPI
106:
107: l_org_id NUMBER;

Line 105: l_src_ga_flag po_lines_print.SRC_GA_FLAG%TYPE; -- GA FPI

101:
102: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;
103: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;
104: l_po_header_id po_headers.po_header_id%TYPE;
105: l_src_ga_flag po_lines_print.SRC_GA_FLAG%TYPE; -- GA FPI
106:
107: l_org_id NUMBER;
108: x_orgid NUMBER;
109: l_un_number PO_UN_NUMBERS.UN_NUMBER%TYPE;

Line 267: FROM po_lines_all pol, -- --po_lines pol,

263: --
264: pol.from_header_id,
265: pol.from_line_id
266: --
267: FROM po_lines_all pol, -- --po_lines pol,
268: po_line_locations pll,
269: mtl_system_items_kfv msi,
270: mtl_units_of_measure_vl umvl,
271: financials_system_params_all fsp -- --financials_system_parameters fsp

Line 314: FROM po_lines_all pol, -- --po_lines pol,

310: --
311: null,
312: null
313: --
314: FROM po_lines_all pol, -- --po_lines pol,
315: po_line_locations pll,
316: mtl_system_items_kfv msi,
317: mtl_units_of_measure_vl umvl,
318: financials_system_params_all fsp -- --financials_system_parameters fsp

Line 360: FROM po_lines pol,

356: --
357: null,
358: null
359: --
360: FROM po_lines pol,
361: po_headers_all poh, -- --po_headers poh,
362: mtl_system_items_kfv msi,
363: mtl_units_of_measure_vl umvl,
364: financials_system_params_all fsp -- --financials_system_parameters fsp

Line 405: FROM po_lines_all pol, -- --po_lines pol,

401: --
402: null,
403: null
404: --
405: FROM po_lines_all pol, -- --po_lines pol,
406: po_line_locations pll,
407: mtl_system_items_kfv msi,
408: mtl_units_of_measure_vl umvl,
409: financials_system_params_all fsp -- --financials_system_parameters fsp

Line 494: po_lines_all pol, -- --po_lines pol,

490: IF (l_document_type = 'PO') THEN
491: -- Seeing if the ship to locations are distinct or not
492: select count(distinct pll.ship_to_location_id) into l_ship_to_count
493: from
494: po_lines_all pol, -- --po_lines pol,
495: po_line_locations pll
496: where PLL.PO_HEADER_ID = l_document_id
497: and PLL.po_line_id = POL.po_line_id;
498: ELSIF (l_document_type = 'RELEASE') THEN

Line 501: FROM po_lines_all pol, -- --po_lines pol,

497: and PLL.po_line_id = POL.po_line_id;
498: ELSIF (l_document_type = 'RELEASE') THEN
499: -- Seeing if the ship to locations are distinct or not
500: select count(distinct pll.ship_to_location_id) into l_ship_to_count
501: FROM po_lines_all pol, -- --po_lines pol,
502: po_line_locations pll
503: where PLL.PO_RELEASE_ID = l_document_id
504: and PLL.po_line_id = POL.po_line_id;
505: ELSIF (l_document_type = 'PA') THEN

Line 514: FROM po_lines_all pol, -- --po_lines pol,

510: ** any PRICE BREAKS
511: */
512: select nvl(count(distinct pll.ship_to_location_id),0)
513: into l_ship_to_count
514: FROM po_lines_all pol, -- --po_lines pol,
515: po_line_locations pll
516: where PLL.PO_HEADER_ID = l_document_id
517: and PLL.po_line_id = POL.po_line_id
518: and PLL.shipment_type = 'PRICE BREAK';

Line 1030: open attachments_cursor('PO_LINES', l_line_loc.po_line_id);

1026: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE_TO_VENDOR') || ' ' || l_line_loc.note_to_vendor || NL;
1027: end if;
1028:
1029:
1030: open attachments_cursor('PO_LINES', l_line_loc.po_line_id);
1031: loop
1032:
1033: fetch attachments_cursor into l_datatype_id, l_media_id;
1034: exit when attachments_cursor%NOTFOUND;

Line 1113: open attachments_from_ga_cursor('PO_LINES', l_line_loc.from_line_id);

1109: close attachments_from_ga_cursor;
1110:
1111: --
1112: --Use attachments_from_ga_cursor instead of attachments_cursor
1113: open attachments_from_ga_cursor('PO_LINES', l_line_loc.from_line_id);
1114: loop
1115:
1116: fetch attachments_from_ga_cursor into l_datatype_id, l_media_id;
1117: exit when attachments_from_ga_cursor%NOTFOUND;

Line 1158: from po_lines_print

1154: begin
1155: if (l_document_type in ('PO', 'PA')) then
1156:
1157: select vendor_quote_num into l_vendor_quote_num
1158: from po_lines_print
1159: where po_line_id = l_line_loc.po_line_id
1160: and po_header_id = l_document_id;
1161:
1162: elsif (l_document_type = 'RELEASE') then

Line 1164: from po_lines_print

1160: and po_header_id = l_document_id;
1161:
1162: elsif (l_document_type = 'RELEASE') then
1163: select vendor_quote_num into l_vendor_quote_num
1164: from po_lines_print
1165: where po_line_id = l_line_loc.po_line_id
1166: and po_release_id = l_document_id;
1167:
1168: else

Line 1187: from po_lines_print

1183: if (l_document_type in ('PO', 'PA')) then
1184:
1185: select po_quote_num, src_ga_flag
1186: into l_po_quote_num, l_src_ga_flag
1187: from po_lines_print
1188: where po_line_id = l_line_loc.po_line_id
1189: and po_header_id = l_document_id;
1190:
1191: elsif (l_document_type = 'RELEASE') then

Line 1194: from po_lines_print

1190:
1191: elsif (l_document_type = 'RELEASE') then
1192:
1193: select po_quote_num into l_po_quote_num
1194: from po_lines_print
1195: where po_line_id = l_line_loc.po_line_id
1196: and po_release_id = l_document_id;
1197: else
1198:

Line 1476: -- Shipments of the other PO lines

1472:
1473: l_document := l_document || '' || NL;
1474:
1475:
1476: -- Shipments of the other PO lines
1477: ELSIF (l_po_line_only = 'N') THEN
1478:
1479: -- Deliver to person
1480: l_requestor_count := 0;

Line 2036: open attachments_cursor('PO_LINES', l_line_loc.po_line_id);

2032: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2033: end if;
2034:
2035: -- modifications from Diwas
2036: open attachments_cursor('PO_LINES', l_line_loc.po_line_id);
2037: loop
2038:
2039: fetch attachments_cursor into l_datatype_id, l_media_id;
2040: exit when attachments_cursor%NOTFOUND;

Line 2113: open attachments_from_ga_cursor('PO_LINES', l_line_loc.from_line_id);

2109: close attachments_from_ga_cursor;
2110:
2111: --
2112: --Use attachments_from_ga_cursor instead of attachments_cursor
2113: open attachments_from_ga_cursor('PO_LINES', l_line_loc.from_line_id);
2114: loop
2115:
2116: fetch attachments_from_ga_cursor into l_datatype_id, l_media_id;
2117: exit when attachments_from_ga_cursor%NOTFOUND;

Line 2156: from po_lines_print

2152: end if;
2153:
2154:
2155: select vendor_quote_num into l_vendor_quote_num
2156: from po_lines_print
2157: where po_line_id = l_line_loc.po_line_id;
2158:
2159: if (l_vendor_quote_num is not null) then
2160: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_QUOTE') || ' ' || l_vendor_quote_num || NL;

Line 2165: from po_lines_print

2161: end if;
2162:
2163:
2164: select po_quote_num into l_po_quote_num
2165: from po_lines_print
2166: where po_line_id = l_line_loc.po_line_id;
2167:
2168: if (l_po_quote_num is not null) then
2169: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_QUOTE') || ' ' || l_po_quote_num || NL;

Line 2497: FROM po_lines_all pol, -- --po_lines pol,

2493:
2494:
2495: cursor release_location_id_cursor (v_po_release_id varchar2) IS
2496: select distinct PLL.ship_to_location_id
2497: FROM po_lines_all pol, -- --po_lines pol,
2498: po_line_locations pll
2499: where PLL.PO_RELEASE_ID = to_number(v_po_release_id)
2500: and PLL.po_line_id = POL.po_line_id;
2501:

Line 2515: FROM po_lines_all pol, --

2511: */
2512:
2513: cursor pa_location_count_cursor (v_po_header_id varchar2) IS
2514: select nvl(count(distinct pll.ship_to_location_id), 0)
2515: FROM po_lines_all pol, --
2516: po_line_locations pll
2517: where PLL.PO_HEADER_ID = to_number(v_po_header_id)
2518: and PLL.po_line_id = POL.po_line_id
2519: and PLL.shipment_type = 'PRICE BREAK';

Line 2528: FROM po_lines_all pol, --

2524: where PO_HEADER_ID = to_number(v_po_header_id);
2525:
2526: cursor pa_location_id_cursor (v_po_header_id varchar2) IS
2527: select distinct pll.ship_to_location_id
2528: FROM po_lines_all pol, --
2529: po_line_locations pll
2530: where PLL.PO_HEADER_ID = to_number(v_po_header_id)
2531: and PLL.po_line_id = POL.po_line_id
2532: and PLL.shipment_type = 'PRICE BREAK';

Line 2536: FROM po_lines_all pol, --

2532: and PLL.shipment_type = 'PRICE BREAK';
2533:
2534: cursor po_location_id_cursor (v_po_header_id varchar2) IS
2535: select distinct PLL.ship_to_location_id
2536: FROM po_lines_all pol, --
2537: po_line_locations pll
2538: where PLL.PO_HEADER_ID = to_number(v_po_header_id)
2539: and PLL.po_line_id = POL.po_line_id;
2540: