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_CLM_INTG_GRP dependencies on PO_DISTRIBUTIONS_ALL

Line 61: select d.po_header_id into l_po_header_id from po_distributions_all d where d.po_distribution_id = p_po_distribution_id;

57: select l.po_header_id into l_po_header_id from po_lines_all l where l.po_line_id = p_po_line_id;
58: elsif p_po_line_location_id is not null then
59: select s.po_header_id into l_po_header_id from po_line_locations_all s where s.Line_Location_id = p_po_line_location_id;
60: else
61: select d.po_header_id into l_po_header_id from po_distributions_all d where d.po_distribution_id = p_po_distribution_id;
62: end if;
63:
64:
65: SELECT 'Y'

Line 288: l_min_distribution_type po_distributions_all.distribution_type%TYPE;

284: x_return_status OUT NOCOPY VARCHAR2)
285: IS
286: d_module VARCHAR2(70) := 'po.plsql.PO_CLM_INTG_GRP.Get_Funding_Info';
287: d_progress NUMBER;
288: l_min_distribution_type po_distributions_all.distribution_type%TYPE;
289: l_min_matching_basis po_line_locations_all.matching_basis%TYPE;
290: l_min_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
291: l_min_code_combination_id po_distributions_all.code_combination_id%TYPE;
292: l_min_budget_account_id po_distributions_all.budget_account_id%TYPE;

Line 290: l_min_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;

286: d_module VARCHAR2(70) := 'po.plsql.PO_CLM_INTG_GRP.Get_Funding_Info';
287: d_progress NUMBER;
288: l_min_distribution_type po_distributions_all.distribution_type%TYPE;
289: l_min_matching_basis po_line_locations_all.matching_basis%TYPE;
290: l_min_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
291: l_min_code_combination_id po_distributions_all.code_combination_id%TYPE;
292: l_min_budget_account_id po_distributions_all.budget_account_id%TYPE;
293: l_min_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
294: l_min_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;

Line 291: l_min_code_combination_id po_distributions_all.code_combination_id%TYPE;

287: d_progress NUMBER;
288: l_min_distribution_type po_distributions_all.distribution_type%TYPE;
289: l_min_matching_basis po_line_locations_all.matching_basis%TYPE;
290: l_min_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
291: l_min_code_combination_id po_distributions_all.code_combination_id%TYPE;
292: l_min_budget_account_id po_distributions_all.budget_account_id%TYPE;
293: l_min_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
294: l_min_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
295: l_max_distribution_type po_distributions_all.distribution_type%TYPE;

Line 292: l_min_budget_account_id po_distributions_all.budget_account_id%TYPE;

288: l_min_distribution_type po_distributions_all.distribution_type%TYPE;
289: l_min_matching_basis po_line_locations_all.matching_basis%TYPE;
290: l_min_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
291: l_min_code_combination_id po_distributions_all.code_combination_id%TYPE;
292: l_min_budget_account_id po_distributions_all.budget_account_id%TYPE;
293: l_min_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
294: l_min_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
295: l_max_distribution_type po_distributions_all.distribution_type%TYPE;
296: l_max_matching_basis po_line_locations_all.matching_basis%TYPE;

Line 293: l_min_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;

289: l_min_matching_basis po_line_locations_all.matching_basis%TYPE;
290: l_min_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
291: l_min_code_combination_id po_distributions_all.code_combination_id%TYPE;
292: l_min_budget_account_id po_distributions_all.budget_account_id%TYPE;
293: l_min_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
294: l_min_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
295: l_max_distribution_type po_distributions_all.distribution_type%TYPE;
296: l_max_matching_basis po_line_locations_all.matching_basis%TYPE;
297: l_max_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;

Line 295: l_max_distribution_type po_distributions_all.distribution_type%TYPE;

291: l_min_code_combination_id po_distributions_all.code_combination_id%TYPE;
292: l_min_budget_account_id po_distributions_all.budget_account_id%TYPE;
293: l_min_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
294: l_min_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
295: l_max_distribution_type po_distributions_all.distribution_type%TYPE;
296: l_max_matching_basis po_line_locations_all.matching_basis%TYPE;
297: l_max_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
298: l_max_code_combination_id po_distributions_all.code_combination_id%TYPE;
299: l_max_budget_account_id po_distributions_all.budget_account_id%TYPE;

Line 297: l_max_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;

293: l_min_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
294: l_min_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
295: l_max_distribution_type po_distributions_all.distribution_type%TYPE;
296: l_max_matching_basis po_line_locations_all.matching_basis%TYPE;
297: l_max_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
298: l_max_code_combination_id po_distributions_all.code_combination_id%TYPE;
299: l_max_budget_account_id po_distributions_all.budget_account_id%TYPE;
300: l_max_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
301: l_max_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;

Line 298: l_max_code_combination_id po_distributions_all.code_combination_id%TYPE;

294: l_min_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
295: l_max_distribution_type po_distributions_all.distribution_type%TYPE;
296: l_max_matching_basis po_line_locations_all.matching_basis%TYPE;
297: l_max_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
298: l_max_code_combination_id po_distributions_all.code_combination_id%TYPE;
299: l_max_budget_account_id po_distributions_all.budget_account_id%TYPE;
300: l_max_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
301: l_max_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
302:

Line 299: l_max_budget_account_id po_distributions_all.budget_account_id%TYPE;

295: l_max_distribution_type po_distributions_all.distribution_type%TYPE;
296: l_max_matching_basis po_line_locations_all.matching_basis%TYPE;
297: l_max_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
298: l_max_code_combination_id po_distributions_all.code_combination_id%TYPE;
299: l_max_budget_account_id po_distributions_all.budget_account_id%TYPE;
300: l_max_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
301: l_max_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
302:
303: BEGIN

Line 300: l_max_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;

296: l_max_matching_basis po_line_locations_all.matching_basis%TYPE;
297: l_max_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
298: l_max_code_combination_id po_distributions_all.code_combination_id%TYPE;
299: l_max_budget_account_id po_distributions_all.budget_account_id%TYPE;
300: l_max_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
301: l_max_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
302:
303: BEGIN
304:

Line 341: FROM po_distributions_all pod,

337: x_budget_account_id,x_partial_funded_flag,x_unit_meas_lookup_code,x_funded_value,
338: x_quantity_funded,x_amount_funded,x_quantity_received,x_amount_received,
339: x_quantity_delivered,x_amount_delivered,x_quantity_billed,x_amount_billed,
340: x_quantity_cancelled, x_amount_cancelled
341: FROM po_distributions_all pod,
342: po_line_locations_all pll,
343: po_lines_all pl
344: WHERE pll.line_location_id = pod.line_location_id
345: AND pod.po_distribution_id = p_po_distribution_id

Line 379: FROM po_distributions_all pod

375: l_min_code_combination_id,l_max_code_combination_id,
376: l_min_budget_account_id,l_max_budget_account_id,
377: l_min_partial_funded_flag,l_max_partial_funded_flag,
378: x_quantity_cancelled,x_amount_cancelled
379: FROM po_distributions_all pod
380: WHERE pod.line_location_id = p_line_location_id;
381:
382:
383: d_progress := 30;

Line 447: FROM po_distributions_all pod

443: l_min_accrue_on_receipt_flag,l_max_accrue_on_receipt_flag,
444: l_min_code_combination_id,l_max_code_combination_id,
445: l_min_budget_account_id,l_max_budget_account_id,
446: l_min_partial_funded_flag,l_max_partial_funded_flag
447: FROM po_distributions_all pod
448: WHERE pod.po_line_id = p_po_line_id;
449:
450: d_progress := 60;
451:

Line 517: FROM po_distributions_all pod

513: l_min_accrue_on_receipt_flag,l_max_accrue_on_receipt_flag,
514: l_min_code_combination_id,l_max_code_combination_id,
515: l_min_budget_account_id,l_max_budget_account_id,
516: l_min_partial_funded_flag,l_max_partial_funded_flag
517: FROM po_distributions_all pod
518: WHERE pod.po_header_id = p_po_header_id;
519:
520: d_progress := 90;
521:

Line 652: FROM po_distributions_all d

648: ELSE
649: IF p_distribution_id IS NOT NULL THEN
650: SELECT NVL(d.funded_value,0)
651: INTO l_funded
652: FROM po_distributions_all d
653: WHERE d.po_distribution_id = p_distribution_id;
654:
655: IF NOT (l_funded > 0) THEN
656: BEGIN

Line 660: po_distributions_all d

656: BEGIN
657: SELECT 1
658: INTO l_nsp_nc_line
659: FROM po_lines_all l,
660: po_distributions_all d
661: WHERE l.po_line_id = d.po_line_id AND
662: l.cost_constraint IN ('NSP', 'NC') AND
663: d.po_distribution_id = p_distribution_id;
664: EXCEPTION

Line 674: FROM po_distributions_all d

670: ELSE
671: IF p_line_location_id IS NOT NULL THEN
672: SELECT SUM(NVL(d.funded_value,0))
673: INTO l_funded
674: FROM po_distributions_all d
675: WHERE d.line_location_id = p_line_location_id;
676:
677: IF NOT (l_funded > 0) THEN
678: BEGIN

Line 696: FROM po_distributions_all d

692: ELSE
693: IF p_line_id IS NOT NULL THEN
694: SELECT SUM(NVL(d.funded_value,0))
695: INTO l_funded
696: FROM po_distributions_all d
697: WHERE d.po_line_id = p_line_id;
698:
699: IF NOT (l_funded > 0) THEN
700: BEGIN

Line 715: FROM po_distributions_all d

711:
712: ELSE
713: SELECT SUM(NVL(d.funded_value,0))
714: INTO l_funded
715: FROM po_distributions_all d
716: WHERE d.po_header_id = p_header_id;
717:
718: END IF; -- Line Location Id is Null
719: END IF;