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 39: line_num po_lines_all.line_num%TYPE,

35:
36: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N'); -- BUG 9858430
37:
38: TYPE shipment_record IS RECORD (
39: line_num po_lines_all.line_num%TYPE,
40: po_line_id po_lines_all.po_line_id%TYPE,
41: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
42: item_revision po_lines_all.item_revision%TYPE,
43: vendor_product_num po_lines.vendor_product_num%TYPE, /* Bug 3105566 */

Line 40: po_line_id po_lines_all.po_line_id%TYPE,

36: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N'); -- BUG 9858430
37:
38: TYPE shipment_record IS RECORD (
39: line_num po_lines_all.line_num%TYPE,
40: po_line_id po_lines_all.po_line_id%TYPE,
41: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
42: item_revision po_lines_all.item_revision%TYPE,
43: vendor_product_num po_lines.vendor_product_num%TYPE, /* Bug 3105566 */
44: item_desc po_lines.item_description%TYPE,

Line 42: item_revision po_lines_all.item_revision%TYPE,

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

Line 51: note_to_vendor po_lines_all.note_to_vendor%TYPE,

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

Line 52: un_number_id po_lines_all.un_number_id%TYPE,

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

Line 53: hazard_class_id po_lines_all.hazard_class_id%TYPE,

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

Line 57: item_id po_lines_all.item_id%TYPE,

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

Line 59: contract_num po_lines_all.contract_num%TYPE,

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

Line 66: from_header_id po_lines_all.from_header_id%type,

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

Line 67: from_line_id po_lines_all.from_line_id%TYPE,

63: start_date po_line_locations_all.start_date%TYPE, /* */
64: end_date po_line_locations_all.end_date%TYPE, /* */
65: --
66: from_header_id po_lines_all.from_header_id%type,
67: from_line_id po_lines_all.from_line_id%TYPE,
68: --
69: drop_ship_flag po_line_locations_all.drop_ship_flag%TYPE --Bug 9356725
70: );
71:

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

268: pol.from_header_id,
269: pol.from_line_id,
270: --
271: pll.drop_ship_flag --Bug 9356725
272: FROM po_lines_all pol, -- --po_lines pol,
273: po_line_locations pll,
274: mtl_system_items_kfv msi,
275: mtl_units_of_measure_vl umvl,
276: financials_system_params_all fsp -- --financials_system_parameters fsp

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

316: null,
317: NULL,
318: --
319: pll.drop_ship_flag --Bug 9356725
320: FROM po_lines_all pol, -- --po_lines pol,
321: po_line_locations pll,
322: mtl_system_items_kfv msi,
323: mtl_units_of_measure_vl umvl,
324: financials_system_params_all fsp -- --financials_system_parameters fsp

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

409: null,
410: NULL,
411: --
412: pll.drop_ship_flag --Bug 9356725
413: FROM po_lines_all pol, -- --po_lines pol,
414: po_line_locations pll,
415: mtl_system_items_kfv msi,
416: mtl_units_of_measure_vl umvl,
417: financials_system_params_all fsp -- --financials_system_parameters fsp

Line 553: po_lines_all pol, -- --po_lines pol,

549: IF (l_document_type = 'PO') THEN
550: -- Seeing if the ship to locations are distinct or not
551: select count(distinct pll.ship_to_location_id) into l_ship_to_count
552: from
553: po_lines_all pol, -- --po_lines pol,
554: po_line_locations pll
555: where PLL.PO_HEADER_ID = l_document_id
556: and PLL.po_line_id = POL.po_line_id;
557: ELSIF (l_document_type = 'RELEASE') THEN

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

556: and PLL.po_line_id = POL.po_line_id;
557: ELSIF (l_document_type = 'RELEASE') THEN
558: -- Seeing if the ship to locations are distinct or not
559: select count(distinct pll.ship_to_location_id) into l_ship_to_count
560: FROM po_lines_all pol, -- --po_lines pol,
561: po_line_locations pll
562: where PLL.PO_RELEASE_ID = l_document_id
563: and PLL.po_line_id = POL.po_line_id;
564: ELSIF (l_document_type = 'PA') THEN

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

569: ** any PRICE BREAKS
570: */
571: select nvl(count(distinct pll.ship_to_location_id),0)
572: into l_ship_to_count
573: FROM po_lines_all pol, -- --po_lines pol,
574: po_line_locations pll
575: where PLL.PO_HEADER_ID = l_document_id
576: and PLL.po_line_id = POL.po_line_id
577: and PLL.shipment_type = 'PRICE BREAK';

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

2714:
2715:
2716: cursor release_location_id_cursor (v_po_release_id varchar2) IS
2717: select distinct PLL.ship_to_location_id
2718: FROM po_lines_all pol, -- --po_lines pol,
2719: po_line_locations pll
2720: where PLL.PO_RELEASE_ID = to_number(v_po_release_id)
2721: and PLL.po_line_id = POL.po_line_id;
2722:

Line 2736: FROM po_lines_all pol, --

2732: */
2733:
2734: cursor pa_location_count_cursor (v_po_header_id varchar2) IS
2735: select nvl(count(distinct pll.ship_to_location_id), 0)
2736: FROM po_lines_all pol, --
2737: po_line_locations pll
2738: where PLL.PO_HEADER_ID = to_number(v_po_header_id)
2739: and PLL.po_line_id = POL.po_line_id
2740: and PLL.shipment_type = 'PRICE BREAK';

Line 2749: FROM po_lines_all pol, --

2745: where PO_HEADER_ID = to_number(v_po_header_id);
2746:
2747: cursor pa_location_id_cursor (v_po_header_id varchar2) IS
2748: select distinct pll.ship_to_location_id
2749: FROM po_lines_all pol, --
2750: po_line_locations pll
2751: where PLL.PO_HEADER_ID = to_number(v_po_header_id)
2752: and PLL.po_line_id = POL.po_line_id
2753: and PLL.shipment_type = 'PRICE BREAK';

Line 2757: FROM po_lines_all pol, --

2753: and PLL.shipment_type = 'PRICE BREAK';
2754:
2755: cursor po_location_id_cursor (v_po_header_id varchar2) IS
2756: select distinct PLL.ship_to_location_id
2757: FROM po_lines_all pol, --
2758: po_line_locations pll
2759: where PLL.PO_HEADER_ID = to_number(v_po_header_id)
2760: and PLL.po_line_id = POL.po_line_id;
2761: