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.

[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_LINE_LOCATIONS_ARCHIVE

Line 3295: po_line_locations_archive polla

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
3297: AND poll.po_header_id =polla.po_header_id
3298: AND poll.line_location_id = polla.line_location_id
3299: AND polla.latest_external_flag = 'Y'

Line 3310: po_line_locations_archive polla

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
3312: AND poll.po_header_id =polla.po_header_id
3313: AND poll.line_location_id = polla.line_location_id
3314: AND polla.latest_external_flag = 'Y'

Line 3506: po_line_locations_archive polla

3502: poll.quantity_billed,
3503: poll.price_override new_price,
3504: polla.price_override old_price
3505: FROM po_line_locations poll,
3506: po_line_locations_archive polla
3507: WHERE poll.po_header_id = p_po_header_id
3508: AND poll.po_release_id IS NULL
3509: AND ((poll.accrue_on_receipt_flag = 'Y' AND
3510: (poll.quantity_received > 0 OR

Line 3531: po_line_locations_archive polla

3527: poll.quantity_billed,
3528: poll.price_override new_price,
3529: polla.price_override old_price
3530: FROM po_line_locations poll,
3531: po_line_locations_archive polla
3532: WHERE poll.po_release_id = p_po_release_id
3533: AND ((poll.accrue_on_receipt_flag = 'Y' AND
3534: (poll.quantity_received > 0 OR
3535: poll.quantity_billed > 0)) OR

Line 3593: po_line_locations_archive_all polla, --

3589: po_lines_all pol, --
3590: -- Bug 3393219, Consumption transaction owning org
3591: -- financials_system_parameters fsp,
3592: po_line_locations_all poll, --
3593: po_line_locations_archive_all polla, --
3594: po_distributions_all pod, --
3595: -- Bug 3314204, 3303148
3596: po_distributions_archive_all poda --
3597: WHERE pol.po_header_id = p_po_header_id

Line 3661: po_line_locations_archive_all polla, --

3657: po_lines pol,
3658: -- Bug 3393219, Consumption transaction owning org
3659: -- financials_system_parameters fsp,
3660: po_line_locations_all poll, --
3661: po_line_locations_archive_all polla, --
3662: po_distributions_all pod, --
3663: -- Bug 3314204, 3303148
3664: po_distributions_archive poda
3665: WHERE por.po_release_id = p_po_release_id