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_DOCUMENT_TOTALS_PVT dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 404: , po_distributions_archive_all pod

400: , round(((pod.quantity_ordered-nvl(pod.quantity_cancelled,0))
401: *poll.price_override),l_precision) )) -- Bug# 5378134
402: INTO l_return_val
403: FROM po_line_locations_archive_all poll
404: , po_distributions_archive_all pod
405: WHERE pod.po_distribution_id = p_doc_level_id
406: AND poll.line_location_id = pod.line_location_id
407: AND ( (p_doc_revision_num IS NULL
408: AND pod.latest_external_flag = 'Y'

Line 413: FROM po_distributions_archive_all pod2

409: AND poll.latest_external_flag = 'Y')
410: OR (p_doc_revision_num IS NOT NULL
411: AND POD.revision_num =
412: (SELECT max(POD2.revision_num)
413: FROM po_distributions_archive_all pod2
414: WHERE pod2.po_distribution_id = pod.po_distribution_id
415: AND pod2.revision_num <= p_doc_revision_num)
416: AND POLL.revision_num =
417: (SELECT max(POLL2.revision_num)

Line 882: , po_distributions_archive_all pod

878: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
879: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
880: INTO l_return_val
881: FROM po_line_locations_archive_all poll
882: , po_distributions_archive_all pod
883: WHERE poll.po_line_id = p_line_id
884: AND pod.line_location_id = poll.line_location_id
885: AND pod.distribution_type = 'STANDARD'
886: AND ( (p_doc_revision_num IS NULL

Line 897: FROM po_distributions_archive_all pod2

893: WHERE poll2.line_location_id = poll.line_location_id
894: AND poll2.revision_num <= p_doc_revision_num)
895: AND pod.revision_num =
896: (SELECT max(POD2.revision_num)
897: FROM po_distributions_archive_all pod2
898: WHERE pod2.po_distribution_id = pod.po_distribution_id
899: AND pod2.revision_num <= p_doc_revision_num)
900: )
901: )

Line 1049: , po_distributions_archive_all pod

1045: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
1046: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
1047: INTO l_return_val
1048: FROM po_line_locations_archive_all poll
1049: , po_distributions_archive_all pod
1050: WHERE poll.po_header_id = p_header_id
1051: AND pod.line_location_id = poll.line_location_id
1052: AND pod.distribution_type = 'STANDARD'
1053: AND ( (p_doc_revision_num IS NULL

Line 1064: FROM po_distributions_archive_all pod2

1060: WHERE poll2.line_location_id = poll.line_location_id
1061: AND poll2.revision_num <= p_doc_revision_num)
1062: AND pod.revision_num =
1063: (SELECT max(POD2.revision_num)
1064: FROM po_distributions_archive_all pod2
1065: WHERE pod2.po_distribution_id = pod.po_distribution_id
1066: AND pod2.revision_num <= p_doc_revision_num)
1067: )
1068: )

Line 3682: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

3678: SUM( nvl(POD.retainage_withheld_amount,0) ),
3679: SUM( nvl(POD.retainage_released_amount,0) )
3680: FROM
3681: PO_LINE_LOCATIONS_ARCHIVE_ALL POLL,
3682: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
3683: WHERE POD.po_distribution_id = l_distribution_id_tbl(i)
3684: AND POD.revision_num = l_distribution_rev_num_tbl(i)
3685: AND POD.line_location_id = POLL.line_location_id
3686: AND ( (p_doc_revision_num IS NULL AND POLL.latest_external_flag = 'Y')