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_RETROACTIVE_PRICING_PVT dependencies on DUAL

Line 3292: FROM dual

3288: -- SQL What: Find out any retroactive pricing change for this PO
3289: -- by comparing the price in the latest revision
3290: SELECT 'Y'
3291: INTO l_retro_change
3292: FROM dual
3293: WHERE EXISTS (SELECT 'retroactive pricing changes'
3294: FROM po_line_locations poll,
3295: po_line_locations_archive polla
3296: WHERE poll.po_header_id = p_document_id

Line 3307: FROM dual

3303: -- by comparing the price in the latest revision
3304:
3305: SELECT 'Y'
3306: INTO l_retro_change
3307: FROM dual
3308: WHERE EXISTS (SELECT 'retroactive pricing changes'
3309: FROM po_line_locations poll,
3310: po_line_locations_archive polla
3311: WHERE poll.po_release_id = p_document_id

Line 4459: FROM DUAL

4455: -- and is received/invoiced, 0 otherwise.
4456: -- SQL Why: To prevent retro price changes if there are such shipments.
4457: SELECT 'N'
4458: INTO l_retro_proj_allowed
4459: FROM DUAL
4460: WHERE EXISTS (SELECT 'has project information'
4461: FROM PO_LINE_LOCATIONS_ALL pll,
4462: PO_DISTRIBUTIONS_ALL pod
4463: WHERE pll.po_line_id = p_po_line_id

Line 4480: FROM DUAL

4476: -- and is received/invoiced, 0 otherwise.
4477: -- SQL Why: To prevent retro price changes if there are such shipments.
4478: SELECT 'N'
4479: INTO l_retro_proj_allowed
4480: FROM DUAL
4481: WHERE EXISTS (SELECT 'has project information'
4482: FROM PO_LINE_LOCATIONS_ALL pll,
4483: PO_DISTRIBUTIONS_ALL pod
4484: WHERE pll.line_location_id = p_po_line_loc_id