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_LINE_LOCATIONS

Line 44: quantity po_line_locations.quantity%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,
47: promised_date po_line_locations.promised_date%TYPE,
48: taxable_flag po_line_locations.taxable_flag%TYPE,

Line 46: need_by_date po_line_locations.need_by_date%TYPE,

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,
50: un_number_id po_lines_all.un_number_id%TYPE,

Line 47: promised_date po_line_locations.promised_date%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,
50: un_number_id po_lines_all.un_number_id%TYPE,
51: hazard_class_id po_lines_all.hazard_class_id%TYPE,

Line 48: taxable_flag po_line_locations.taxable_flag%TYPE,

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

Line 52: cancel_flag po_line_locations_all.cancel_flag%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,
56: org_id po_line_locations_all.org_id%TYPE,

Line 53: cancel_date po_line_locations_all.cancel_date%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,
56: org_id po_line_locations_all.org_id%TYPE,
57: contract_num po_lines_all.contract_num%TYPE,

Line 54: quantity_cancelled po_line_locations_all.quantity_cancelled%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,
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,

Line 56: org_id po_line_locations_all.org_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,
60: consigned_flag po_line_locations_all.consigned_flag%TYPE, --

Line 58: line_location_id po_line_locations_all.line_location_id%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, /* */
62: end_date po_line_locations_all.end_date%TYPE, /* */

Line 59: ship_to_location_id po_line_locations_all.ship_to_location_id%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, /* */
62: end_date po_line_locations_all.end_date%TYPE, /* */
63: --

Line 60: consigned_flag po_line_locations_all.consigned_flag%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, /* */
62: end_date po_line_locations_all.end_date%TYPE, /* */
63: --
64: from_header_id po_lines_all.from_header_id%type,

Line 61: start_date po_line_locations_all.start_date%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, /* */
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

Line 62: end_date po_line_locations_all.end_date%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, /* */
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: --

Line 121: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;

117: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
118: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
119: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
120: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
121: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
122: l_cancel_date po_line_locations_all.cancel_date%TYPE;
123: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
124:
125: l_requestor_name po_distributions_print.requestor_name%TYPE;

Line 122: l_cancel_date po_line_locations_all.cancel_date%TYPE;

118: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
119: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
120: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
121: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
122: l_cancel_date po_line_locations_all.cancel_date%TYPE;
123: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
124:
125: l_requestor_name po_distributions_print.requestor_name%TYPE;
126: l_requestor_id po_distributions_print.requestor_id%TYPE;

Line 123: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;

119: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
120: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
121: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
122: l_cancel_date po_line_locations_all.cancel_date%TYPE;
123: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
124:
125: l_requestor_name po_distributions_print.requestor_name%TYPE;
126: l_requestor_id po_distributions_print.requestor_id%TYPE;
127:

Line 268: po_line_locations pll,

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
272: where PLL.PO_HEADER_ID = v_document_id

Line 315: po_line_locations pll,

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
319: where POL.PO_HEADER_ID = v_document_id

Line 406: po_line_locations pll,

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
410: where PLL.PO_RELEASE_ID = v_document_id

Line 495: po_line_locations pll

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
499: -- Seeing if the ship to locations are distinct or not

Line 502: po_line_locations pll

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
506: -- Seeing if the ship to locations are distinct or not

Line 515: po_line_locations pll

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';
519: ELSE

Line 525: from po_line_locations

521: END IF;
522:
523: IF (l_document_type = 'PA') THEN
524: select count(*) into x_pb_count
525: from po_line_locations
526: where po_header_id = l_document_id;
527: END IF;
528:
529: IF (x_display_type = 'text/html') THEN

Line 2498: po_line_locations pll

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:
2502: /* Bug# 2684059: kagarwal

Line 2516: po_line_locations pll

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';
2520:

Line 2529: po_line_locations pll

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';
2533:

Line 2537: po_line_locations pll

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:
2541: cursor vendor_contacts_cursor(v_vendor_contact_id NUMBER) IS