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_LINE_LOCATIONS_ALL

Line 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;

55: l_po_header_id := p_po_header_id;
56: elsif p_po_line_id is not null then
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:

Line 289: l_min_matching_basis po_line_locations_all.matching_basis%TYPE;

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;
293: l_min_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;

Line 294: l_min_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%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;
298: l_max_code_combination_id po_distributions_all.code_combination_id%TYPE;

Line 296: l_max_matching_basis po_line_locations_all.matching_basis%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;
300: l_max_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;

Line 301: l_max_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%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:
305: d_progress := 0;

Line 342: po_line_locations_all pll,

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
346: AND pl.po_line_id = pod.po_line_id;

Line 415: FROM po_line_locations_all pll

411: pll.matching_basis,
412: pll.quantity_received,
413: pll.amount_received
414: INTO x_unit_meas_lookup_code,x_matching_basis,x_quantity_received,x_amount_received
415: FROM po_line_locations_all pll
416: WHERE pll.line_location_id = p_line_location_id;
417:
418:
419: ELSIF p_po_line_id IS NOT NULL THEN

Line 461: FROM po_line_locations_all pll

457: Max(pll.matching_basis)
458: INTO x_quantity_received,x_amount_received,
459: l_min_unit_meas_lookup_code,l_max_unit_meas_lookup_code,
460: l_min_matching_basis,l_max_matching_basis
461: FROM po_line_locations_all pll
462: WHERE pll.po_line_id = p_po_line_id;
463:
464: d_progress := 70;
465:

Line 531: FROM po_line_locations_all pll

527: Max(pll.matching_basis)
528: INTO x_quantity_received,x_amount_received,
529: l_min_unit_meas_lookup_code,l_max_unit_meas_lookup_code,
530: l_min_matching_basis,l_max_matching_basis
531: FROM po_line_locations_all pll
532: WHERE pll.po_header_id = p_po_header_id;
533:
534: d_progress := 100;
535:

Line 682: po_line_locations_all ll

678: BEGIN
679: SELECT 1
680: INTO l_nsp_nc_line
681: FROM po_lines_all l,
682: po_line_locations_all ll
683: WHERE l.po_line_id = ll.po_line_id AND
684: l.cost_constraint IN ('NSP', 'NC') AND
685: ll.line_location_id = p_line_location_id;
686: EXCEPTION