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_PA_INTEGRATION_GRP dependencies on PO_SP_VAL_V

Line 258: FROM PO_SP_VAL_V psp

254:
255: IF l_distribution_id IS NULL THEN
256: SELECT MIN(psp.po_distribution_id)
257: INTO l_distribution_id
258: FROM PO_SP_VAL_V psp
259: WHERE psp.po_line_id = p_po_line_id
260: AND psp.project_id IS NOT NULL
261: AND psp.task_id IS NOT NULL
262: AND psp.VALIDATE_PROJECT_FLAG = 'Y';

Line 574: FROM PO_SP_VAL_V psp

570:
571: IF l_distribution_id IS NULL THEN
572: SELECT MIN(psp.po_distribution_id)
573: INTO l_distribution_id
574: FROM PO_SP_VAL_V psp
575: WHERE psp.po_line_id = p_po_line_id
576: AND psp.project_id IS NOT NULL
577: AND psp.task_id IS NOT NULL
578: AND psp.VALIDATE_PROJECT_FLAG = 'Y';

Line 656: FROM po_sp_val_v

652: INTO X_flag
653: from dual
654: where exists(
655: SELECT po_header_id,po_line_id
656: FROM po_sp_val_v
657: where person_id = p_person_id
658: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) >=
659: fnd_date.canonical_to_date(fnd_date.date_to_canonical(pol_start_date))
660: AND fnd_date.canonical_to_date(fnd_date.date_to_canonical(l_effective_date)) <=