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_WF_PO_NOTIFICATION dependencies on PO_LINES

Line 120: FROM po_lines pol,

116:
117: Old tax select:
118: SELECT nvl(sum(nonrecoverable_tax), 0)
119: INTO l_tax_amt
120: FROM po_lines pol,
121: po_distributions pod
122: WHERE pol.po_header_id = l_document_id
123: AND pod.po_line_id = pol.po_line_id;
124: */

Line 143: FROM po_lines pol,

139: ) / X_min_acct_unit
140: ) * X_min_acct_unit
141: )
142: INTO l_tax_amt
143: FROM po_lines pol,
144: po_distributions pod
145: WHERE pol.po_header_id = l_document_id
146: AND pod.po_line_id = pol.po_line_id;
147: ELSE

Line 158: FROM po_lines pol,

154: X_precision
155: )
156: )
157: INTO l_tax_amt
158: FROM po_lines pol,
159: po_distributions pod
160: WHERE pol.po_header_id = l_document_id
161: AND pod.po_line_id = pol.po_line_id;
162: END IF;

Line 219: PROCEDURE get_po_lines_details ( document_id in varchar2,

215:
216: END;
217:
218:
219: PROCEDURE get_po_lines_details ( document_id in varchar2,
220: display_type in varchar2,
221: document in out NOCOPY CLOB, --
222: document_type in out NOCOPY varchar2) IS
223:

Line 227: l_document_id po_lines.po_header_id%TYPE;

223:
224: l_item_type wf_items.item_type%TYPE;
225: l_item_key wf_items.item_key%TYPE;
226:
227: l_document_id po_lines.po_header_id%TYPE;
228: l_org_id po_lines.org_id%TYPE;
229: l_document_type VARCHAR2(25);
230:
231: l_document VARCHAR2(32000) := '';

Line 228: l_org_id po_lines.org_id%TYPE;

224: l_item_type wf_items.item_type%TYPE;
225: l_item_key wf_items.item_key%TYPE;
226:
227: l_document_id po_lines.po_header_id%TYPE;
228: l_org_id po_lines.org_id%TYPE;
229: l_document_type VARCHAR2(25);
230:
231: l_document VARCHAR2(32000) := '';
232:

Line 256: -- po lines cursor

252: -- curr_len NUMBER := 0;
253: -- prior_len NUMBER := 0;
254: --
255:
256: -- po lines cursor
257:
258: -- Declare TABLEs for each column that is selected
259: -- from po_line_csr and po_line_loc_csr.
260: --

Line 261: TYPE line_num_tbl_type IS TABLE OF PO_LINES.line_num%TYPE;

257:
258: -- Declare TABLEs for each column that is selected
259: -- from po_line_csr and po_line_loc_csr.
260: --
261: TYPE line_num_tbl_type IS TABLE OF PO_LINES.line_num%TYPE;
262: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;
263: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
264: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
265: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;

Line 264: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;

260: --
261: TYPE line_num_tbl_type IS TABLE OF PO_LINES.line_num%TYPE;
262: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;
263: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
264: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
265: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
266: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
267: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
268: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;

Line 265: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;

261: TYPE line_num_tbl_type IS TABLE OF PO_LINES.line_num%TYPE;
262: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;
263: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
264: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
265: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
266: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
267: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
268: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
269: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;

Line 267: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;

263: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
264: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
265: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
266: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
267: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
268: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
269: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;
270: TYPE location_tbl_type IS TABLE OF HR_LOCATIONS.location_code%TYPE;
271: TYPE organization_name_tbl_type IS TABLE OF ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;

Line 268: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;

264: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
265: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
266: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
267: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
268: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
269: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;
270: TYPE location_tbl_type IS TABLE OF HR_LOCATIONS.location_code%TYPE;
271: TYPE organization_name_tbl_type IS TABLE OF ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;
272: TYPE need_by_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.need_by_date%TYPE;

Line 269: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;

265: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
266: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
267: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
268: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
269: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;
270: TYPE location_tbl_type IS TABLE OF HR_LOCATIONS.location_code%TYPE;
271: TYPE organization_name_tbl_type IS TABLE OF ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;
272: TYPE need_by_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.need_by_date%TYPE;
273: TYPE promised_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.promised_date%TYPE;

Line 295: ** PO lines cursor, po_line_csr, is not correct as the pol.org_id

291: --
292:
293: /* Bug# 1419139: kagarwal
294: ** Desc: The where clause pol.org_id = msi.organization_id(+) in the
295: ** PO lines cursor, po_line_csr, is not correct as the pol.org_id
296: ** is the operating unit which is not the same as the inventory
297: ** organization_id.
298: **
299: ** We need to use the financials_system_parameter table for the

Line 320: FROM po_lines pol,

316: nvl(muom.unit_of_measure_tl, pol.unit_meas_lookup_code), -- bug 2401933.add
317: pol.quantity,
318: pol.unit_price,
319: nvl(pol.amount, pol.quantity * pol.unit_price)
320: FROM po_lines pol,
321: mtl_system_items_kfv msi,
322: mtl_units_of_measure muom, -- bug 2401933.add
323: financials_system_parameters fsp
324: WHERE pol.po_header_id = v_document_id

Line 385: FROM po_lines pol,

381: pll.shipment_type,
382: --Bug 4950850 Added pll.amount
383: --Bug 5563024 AMOUNT NOT SHOWN FOR A RELEASE SHIPMENT IN APPROVAL NOTIFICATION.
384: nvl(pll.amount, nvl(pll.price_override, pol.unit_price) * pll.quantity)
385: FROM po_lines pol,
386: po_line_locations pll,
387: mtl_system_items_kfv msi,
388: hr_locations_all hrl,
389: hz_locations hz,

Line 467: ** number of PO lines to be displayed in Approval notification.

463:
464:
465: /* Bug# 2668222: kagarwal
466: ** Desc: Using profile PO_NOTIF_LINES_LIMIT to get the maximum
467: ** number of PO lines to be displayed in Approval notification.
468: ** The same profile is also used for Requisitions.
469: */
470: --
471: -- max_lines_dsp:= to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));

Line 478: -- Fetch Release Shipments/PO Lines data into Tables.

474: -- max_lines_dsp := 20;
475: -- end if;
476: --
477:
478: -- Fetch Release Shipments/PO Lines data into Tables.
479: --
480: IF ( l_document_type = 'RELEASE' ) THEN
481:
482: OPEN po_line_loc_csr(l_document_id);

Line 951: END get_po_lines_details;

947: wf_notification.writetoclob(document, l_document); --
948: -- document := l_document; --
949: end if;
950:
951: END get_po_lines_details;
952:
953: PROCEDURE get_action_history ( document_id in varchar2,
954: display_type in varchar2,
955: document in out NOCOPY varchar2,

Line 961: l_document_id po_lines.po_header_id%TYPE;

957:
958: l_item_type wf_items.item_type%TYPE;
959: l_item_key wf_items.item_key%TYPE;
960:
961: l_document_id po_lines.po_header_id%TYPE;
962: l_org_id po_lines.org_id%TYPE;
963: l_doc_type_code VARCHAR2(80);
964:
965: l_document VARCHAR2(32000) := '';

Line 962: l_org_id po_lines.org_id%TYPE;

958: l_item_type wf_items.item_type%TYPE;
959: l_item_key wf_items.item_key%TYPE;
960:
961: l_document_id po_lines.po_header_id%TYPE;
962: l_org_id po_lines.org_id%TYPE;
963: l_doc_type_code VARCHAR2(80);
964:
965: l_document VARCHAR2(32000) := '';
966: