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 399: , po_distributions_archive_all pod

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

Line 408: FROM po_distributions_archive_all pod2

404: AND poll.latest_external_flag = 'Y')
405: OR (p_doc_revision_num IS NOT NULL
406: AND POD.revision_num =
407: (SELECT max(POD2.revision_num)
408: FROM po_distributions_archive_all pod2
409: WHERE pod2.po_distribution_id = pod.po_distribution_id
410: AND pod2.revision_num <= p_doc_revision_num)
411: AND POLL.revision_num =
412: (SELECT max(POLL2.revision_num)

Line 873: , po_distributions_archive_all pod

869: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
870: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
871: INTO l_return_val
872: FROM po_line_locations_archive_all poll
873: , po_distributions_archive_all pod
874: WHERE poll.po_line_id = p_line_id
875: AND pod.line_location_id = poll.line_location_id
876: AND pod.distribution_type = 'STANDARD'
877: AND ( (p_doc_revision_num IS NULL

Line 888: FROM po_distributions_archive_all pod2

884: WHERE poll2.line_location_id = poll.line_location_id
885: AND poll2.revision_num <= p_doc_revision_num)
886: AND pod.revision_num =
887: (SELECT max(POD2.revision_num)
888: FROM po_distributions_archive_all pod2
889: WHERE pod2.po_distribution_id = pod.po_distribution_id
890: AND pod2.revision_num <= p_doc_revision_num)
891: )
892: )

Line 1040: , po_distributions_archive_all pod

1036: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
1037: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
1038: INTO l_return_val
1039: FROM po_line_locations_archive_all poll
1040: , po_distributions_archive_all pod
1041: WHERE poll.po_header_id = p_header_id
1042: AND pod.line_location_id = poll.line_location_id
1043: AND pod.distribution_type = 'STANDARD'
1044: AND ( (p_doc_revision_num IS NULL

Line 1055: FROM po_distributions_archive_all pod2

1051: WHERE poll2.line_location_id = poll.line_location_id
1052: AND poll2.revision_num <= p_doc_revision_num)
1053: AND pod.revision_num =
1054: (SELECT max(POD2.revision_num)
1055: FROM po_distributions_archive_all pod2
1056: WHERE pod2.po_distribution_id = pod.po_distribution_id
1057: AND pod2.revision_num <= p_doc_revision_num)
1058: )
1059: )

Line 3563: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

3559: SUM( nvl(POD.retainage_withheld_amount,0) ),
3560: SUM( nvl(POD.retainage_released_amount,0) )
3561: FROM
3562: PO_LINE_LOCATIONS_ARCHIVE_ALL POLL,
3563: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
3564: WHERE POD.po_distribution_id = l_distribution_id_tbl(i)
3565: AND POD.revision_num = l_distribution_rev_num_tbl(i)
3566: AND POD.line_location_id = POLL.line_location_id
3567: AND ( (p_doc_revision_num IS NULL AND POLL.latest_external_flag = 'Y')