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 PO_LINE_LOCATIONS_ARCHIVE

Line 3183: po_line_locations_archive polla

3179: INTO l_retro_change
3180: FROM dual
3181: WHERE EXISTS (SELECT 'retroactive pricing changes'
3182: FROM po_line_locations poll,
3183: po_line_locations_archive polla
3184: WHERE poll.po_header_id = p_document_id
3185: AND poll.po_header_id =polla.po_header_id
3186: AND poll.line_location_id = polla.line_location_id
3187: AND polla.latest_external_flag = 'Y'

Line 3198: po_line_locations_archive polla

3194: INTO l_retro_change
3195: FROM dual
3196: WHERE EXISTS (SELECT 'retroactive pricing changes'
3197: FROM po_line_locations poll,
3198: po_line_locations_archive polla
3199: WHERE poll.po_release_id = p_document_id
3200: AND poll.po_header_id =polla.po_header_id
3201: AND poll.line_location_id = polla.line_location_id
3202: AND polla.latest_external_flag = 'Y'

Line 3385: po_line_locations_archive polla

3381: poll.quantity_billed,
3382: poll.price_override new_price,
3383: polla.price_override old_price
3384: FROM po_line_locations poll,
3385: po_line_locations_archive polla
3386: WHERE poll.po_header_id = p_po_header_id
3387: AND poll.po_release_id IS NULL
3388: AND ((poll.accrue_on_receipt_flag = 'Y' AND
3389: (poll.quantity_received > 0 OR

Line 3410: po_line_locations_archive polla

3406: poll.quantity_billed,
3407: poll.price_override new_price,
3408: polla.price_override old_price
3409: FROM po_line_locations poll,
3410: po_line_locations_archive polla
3411: WHERE poll.po_release_id = p_po_release_id
3412: AND ((poll.accrue_on_receipt_flag = 'Y' AND
3413: (poll.quantity_received > 0 OR
3414: poll.quantity_billed > 0)) OR

Line 3472: po_line_locations_archive_all polla, --

3468: po_lines_all pol, --
3469: -- Bug 3393219, Consumption transaction owning org
3470: -- financials_system_parameters fsp,
3471: po_line_locations_all poll, --
3472: po_line_locations_archive_all polla, --
3473: po_distributions_all pod, --
3474: -- Bug 3314204, 3303148
3475: po_distributions_archive_all poda --
3476: WHERE pol.po_header_id = p_po_header_id

Line 3540: po_line_locations_archive_all polla, --

3536: po_lines pol,
3537: -- Bug 3393219, Consumption transaction owning org
3538: -- financials_system_parameters fsp,
3539: po_line_locations_all poll, --
3540: po_line_locations_archive_all polla, --
3541: po_distributions_all pod, --
3542: -- Bug 3314204, 3303148
3543: po_distributions_archive poda
3544: WHERE por.po_release_id = p_po_release_id