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 153: FROM po_lines pol,

149:
150: Old tax select:
151: SELECT nvl(sum(nonrecoverable_tax), 0)
152: INTO l_tax_amt
153: FROM po_lines pol,
154: po_distributions pod
155: WHERE pol.po_header_id = l_document_id
156: AND pod.po_line_id = pol.po_line_id;
157: */

Line 212: FROM po_lines pol,

208: ) / X_min_acct_unit
209: ) * X_min_acct_unit
210: )
211: INTO l_tax_amt
212: FROM po_lines pol,
213: po_distributions pod
214: WHERE pol.po_header_id = l_document_id
215: AND pod.po_line_id = pol.po_line_id;
216: ELSE

Line 228: FROM po_lines pol,

224: X_precision
225: )
226: )
227: INTO l_tax_amt
228: FROM po_lines pol,
229: po_distributions pod
230: WHERE pol.po_header_id = l_document_id
231: AND pod.po_line_id = pol.po_line_id;
232: END IF;

Line 300: PROCEDURE get_po_lines_details ( document_id in varchar2,

296:
297: END;
298:
299:
300: PROCEDURE get_po_lines_details ( document_id in varchar2,
301: display_type in varchar2,
302: document in out NOCOPY CLOB, --
303: document_type in out NOCOPY varchar2) IS
304:

Line 308: l_document_id po_lines.po_header_id%TYPE;

304:
305: l_item_type wf_items.item_type%TYPE;
306: l_item_key wf_items.item_key%TYPE;
307:
308: l_document_id po_lines.po_header_id%TYPE;
309: l_org_id po_lines.org_id%TYPE;
310: l_document_type VARCHAR2(25);
311:
312: l_document VARCHAR2(32000) := '';

Line 309: l_org_id po_lines.org_id%TYPE;

305: l_item_type wf_items.item_type%TYPE;
306: l_item_key wf_items.item_key%TYPE;
307:
308: l_document_id po_lines.po_header_id%TYPE;
309: l_org_id po_lines.org_id%TYPE;
310: l_document_type VARCHAR2(25);
311:
312: l_document VARCHAR2(32000) := '';
313:

Line 337: -- po lines cursor

333: curr_len NUMBER := 0; --
334: -- prior_len NUMBER := 0;
335: --
336:
337: -- po lines cursor
338:
339: -- Declare TABLEs for each column that is selected
340: -- from po_line_csr and po_line_loc_csr.
341: --

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

338:
339: -- Declare TABLEs for each column that is selected
340: -- from po_line_csr and po_line_loc_csr.
341: --
342: TYPE line_num_tbl_type IS TABLE OF PO_LINES.line_num%TYPE;
343: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;
344: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
345: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
346: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;

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

341: --
342: TYPE line_num_tbl_type IS TABLE OF PO_LINES.line_num%TYPE;
343: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;
344: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
345: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
346: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
347: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
348: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
349: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;

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

342: TYPE line_num_tbl_type IS TABLE OF PO_LINES.line_num%TYPE;
343: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;
344: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
345: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
346: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
347: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
348: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
349: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
350: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;

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

344: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
345: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
346: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
347: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
348: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
349: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
350: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;
351: TYPE location_tbl_type IS TABLE OF HR_LOCATIONS.location_code%TYPE;
352: TYPE organization_name_tbl_type IS TABLE OF ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;

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

345: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
346: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
347: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
348: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
349: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
350: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;
351: TYPE location_tbl_type IS TABLE OF HR_LOCATIONS.location_code%TYPE;
352: TYPE organization_name_tbl_type IS TABLE OF ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;
353: TYPE need_by_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.need_by_date%TYPE;

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

346: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
347: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
348: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
349: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
350: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;
351: TYPE location_tbl_type IS TABLE OF HR_LOCATIONS.location_code%TYPE;
352: TYPE organization_name_tbl_type IS TABLE OF ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;
353: TYPE need_by_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.need_by_date%TYPE;
354: TYPE promised_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.promised_date%TYPE;

Line 357: TYPE clm_option_num_tbl_type IS TABLE OF PO_LINES.CLM_OPTION_NUM%TYPE;

353: TYPE need_by_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.need_by_date%TYPE;
354: TYPE promised_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.promised_date%TYPE;
355: TYPE shipment_type_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_type%TYPE;
356: /* CLM Changes Start */
357: TYPE clm_option_num_tbl_type IS TABLE OF PO_LINES.CLM_OPTION_NUM%TYPE;
358: TYPE CLM_BASE_LINE_NUM_tbl_type IS TABLE OF po_lines.LINE_NUM_DISPLAY%TYPE;
359: TYPE CONTRACT_TYPE_tbl_type is table of po_lookup_codes.DESCRIPTION%TYPE;
360: TYPE LINE_NUM_DISPLAY_tbl_type is table of po_lines.line_num_display%type;
361: /* CLM changes End */

Line 358: TYPE CLM_BASE_LINE_NUM_tbl_type IS TABLE OF po_lines.LINE_NUM_DISPLAY%TYPE;

354: TYPE promised_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.promised_date%TYPE;
355: TYPE shipment_type_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_type%TYPE;
356: /* CLM Changes Start */
357: TYPE clm_option_num_tbl_type IS TABLE OF PO_LINES.CLM_OPTION_NUM%TYPE;
358: TYPE CLM_BASE_LINE_NUM_tbl_type IS TABLE OF po_lines.LINE_NUM_DISPLAY%TYPE;
359: TYPE CONTRACT_TYPE_tbl_type is table of po_lookup_codes.DESCRIPTION%TYPE;
360: TYPE LINE_NUM_DISPLAY_tbl_type is table of po_lines.line_num_display%type;
361: /* CLM changes End */
362:

Line 360: TYPE LINE_NUM_DISPLAY_tbl_type is table of po_lines.line_num_display%type;

356: /* CLM Changes Start */
357: TYPE clm_option_num_tbl_type IS TABLE OF PO_LINES.CLM_OPTION_NUM%TYPE;
358: TYPE CLM_BASE_LINE_NUM_tbl_type IS TABLE OF po_lines.LINE_NUM_DISPLAY%TYPE;
359: TYPE CONTRACT_TYPE_tbl_type is table of po_lookup_codes.DESCRIPTION%TYPE;
360: TYPE LINE_NUM_DISPLAY_tbl_type is table of po_lines.line_num_display%type;
361: /* CLM changes End */
362:
363: l_line_num_tbl line_num_tbl_type;
364: l_shipment_num_tbl shipment_num_tbl_type;

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

388: --
389:
390: /* Bug# 1419139: kagarwal
391: ** Desc: The where clause pol.org_id = msi.organization_id(+) in the
392: ** PO lines cursor, po_line_csr, is not correct as the pol.org_id
393: ** is the operating unit which is not the same as the inventory
394: ** organization_id.
395: **
396: ** We need to use the financials_system_parameter table for the

Line 422: FROM po_lines_all pol, --CLM Apprvl

418: po2.LINE_NUM_DISPLAY --Base line num
419: -- ,pol.contract_type
420: ,lkp1.description
421: ,pol.LINE_NUM_DISPLAY
422: FROM po_lines_all pol, --CLM Apprvl
423: po_lines_all po2, -- CLM Apprvl
424: po_lookup_codes lkp1,
425: mtl_system_items_kfv msi,
426: mtl_units_of_measure muom, -- bug 2401933.add

Line 423: po_lines_all po2, -- CLM Apprvl

419: -- ,pol.contract_type
420: ,lkp1.description
421: ,pol.LINE_NUM_DISPLAY
422: FROM po_lines_all pol, --CLM Apprvl
423: po_lines_all po2, -- CLM Apprvl
424: po_lookup_codes lkp1,
425: mtl_system_items_kfv msi,
426: mtl_units_of_measure muom, -- bug 2401933.add
427: financials_system_parameters fsp

Line 489: FROM po_lines_draft_all pol, --CLM Apprvl

485: po2.LINE_NUM_DISPLAY --Base line num
486: -- ,pol.contract_type
487: ,lkp1.description
488: ,pol.LINE_NUM_DISPLAY
489: FROM po_lines_draft_all pol, --CLM Apprvl
490: po_lines_draft_all po2, -- CLM Apprvl
491: po_lookup_codes lkp1,
492: mtl_system_items_kfv msi,
493: mtl_units_of_measure muom, -- bug 2401933.add

Line 490: po_lines_draft_all po2, -- CLM Apprvl

486: -- ,pol.contract_type
487: ,lkp1.description
488: ,pol.LINE_NUM_DISPLAY
489: FROM po_lines_draft_all pol, --CLM Apprvl
490: po_lines_draft_all po2, -- CLM Apprvl
491: po_lookup_codes lkp1,
492: mtl_system_items_kfv msi,
493: mtl_units_of_measure muom, -- bug 2401933.add
494: financials_system_parameters fsp

Line 533: FROM po_lines_all pol, -- CLM apprvl

529: pll.shipment_type,
530: --Bug 4950850 Added pll.amount
531: --Bug 5563024 AMOUNT NOT SHOWN FOR A RELEASE SHIPMENT IN APPROVAL NOTIFICATION.
532: nvl(pll.amount, nvl(pll.price_override, pol.unit_price) * pll.quantity)
533: FROM po_lines_all pol, -- CLM apprvl
534: po_line_locations_all pll, -- CLM apprvl
535: mtl_system_items_kfv msi,
536: hr_locations_all hrl,
537: hz_locations hz,

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

636:
637:
638: /* Bug# 2668222: kagarwal
639: ** Desc: Using profile PO_NOTIF_LINES_LIMIT to get the maximum
640: ** number of PO lines to be displayed in Approval notification.
641: ** The same profile is also used for Requisitions.
642: */
643: --
644: -- max_lines_dsp:= to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));

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

647: -- max_lines_dsp := 20;
648: -- end if;
649: --
650:
651: -- Fetch Release Shipments/PO Lines data into Tables.
652: --
653: IF ( l_document_type = 'RELEASE' ) THEN
654:
655: OPEN po_line_loc_csr(l_document_id);

Line 1214: END get_po_lines_details;

1210: END IF;
1211: -- document := l_document; --
1212: end if;
1213:
1214: END get_po_lines_details;
1215:
1216: PROCEDURE get_action_history ( document_id in varchar2,
1217: display_type in varchar2,
1218: document in out NOCOPY varchar2,

Line 1224: l_document_id po_lines.po_header_id%TYPE;

1220:
1221: l_item_type wf_items.item_type%TYPE;
1222: l_item_key wf_items.item_key%TYPE;
1223:
1224: l_document_id po_lines.po_header_id%TYPE;
1225: l_org_id po_lines.org_id%TYPE;
1226: l_doc_type_code VARCHAR2(80);
1227:
1228: l_document VARCHAR2(32000) := '';

Line 1225: l_org_id po_lines.org_id%TYPE;

1221: l_item_type wf_items.item_type%TYPE;
1222: l_item_key wf_items.item_key%TYPE;
1223:
1224: l_document_id po_lines.po_header_id%TYPE;
1225: l_org_id po_lines.org_id%TYPE;
1226: l_doc_type_code VARCHAR2(80);
1227:
1228: l_document VARCHAR2(32000) := '';
1229: