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_ALL

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 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 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 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 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: