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_LINE_LOCATIONS_ARCHIVE_ALL

Line 346: FROM po_line_locations_archive_all poll

342: *poll.price_override/l_mau) * l_mau
343: , round(((poll.quantity-nvl(poll.quantity_cancelled,0))
344: *poll.price_override),l_precision) )) -- Bug# 5378134
345: INTO l_return_val
346: FROM po_line_locations_archive_all poll
347: WHERE poll.line_location_id = p_doc_level_id
348: AND ( (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
349: OR (p_doc_revision_num IS NOT NULL
350: AND POLL.revision_num =

Line 352: FROM po_line_locations_archive_all poll2

348: AND ( (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
349: OR (p_doc_revision_num IS NOT NULL
350: AND POLL.revision_num =
351: (SELECT max(POLL2.revision_num)
352: FROM po_line_locations_archive_all poll2
353: WHERE poll2.line_location_id = poll.line_location_id
354: AND poll2.revision_num <= p_doc_revision_num)
355: )
356: )

Line 403: FROM po_line_locations_archive_all poll

399: *poll.price_override/l_mau) * l_mau
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

Line 418: FROM po_line_locations_archive_all poll2

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)
418: FROM po_line_locations_archive_all poll2
419: WHERE poll2.line_location_id = poll.line_location_id
420: AND poll2.revision_num <= p_doc_revision_num)
421: )
422: )

Line 570: FROM po_line_locations_archive_all poll

566: nvl2(l_mau
567: , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
568: , round((poll.quantity_received*poll.price_override),l_precision)) )) --Bug5391045
569: INTO l_return_val
570: FROM po_line_locations_archive_all poll
571: WHERE poll.po_line_id = p_line_id
572: AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE') --Bug5391045
573: AND ( (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
574: OR (p_doc_revision_num IS NOT NULL

Line 577: FROM po_line_locations_archive_all poll2

573: AND ( (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
574: OR (p_doc_revision_num IS NOT NULL
575: AND poll.revision_num =
576: (SELECT max(POLL2.revision_num)
577: FROM po_line_locations_archive_all poll2
578: WHERE poll2.line_location_id = poll.line_location_id
579: AND poll2.revision_num <= p_doc_revision_num)
580: )
581: )

Line 723: FROM po_line_locations_archive_all poll

719: nvl2(l_mau
720: , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
721: , round((poll.quantity_received*poll.price_override),l_precision)) )) --Bug5391045
722: INTO l_return_val
723: FROM po_line_locations_archive_all poll
724: WHERE poll.po_header_id = p_header_id
725: AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE') --Bug5391045
726: AND ( (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
727: OR (p_doc_revision_num IS NOT NULL

Line 730: FROM po_line_locations_archive_all poll2

726: AND ( (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
727: OR (p_doc_revision_num IS NOT NULL
728: AND poll.revision_num =
729: (SELECT max(POLL2.revision_num)
730: FROM po_line_locations_archive_all poll2
731: WHERE poll2.line_location_id = poll.line_location_id
732: AND poll2.revision_num <= p_doc_revision_num)
733: )
734: )

Line 881: FROM po_line_locations_archive_all poll

877: nvl2(l_mau
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'

Line 892: FROM po_line_locations_archive_all poll2

888: AND pod.latest_external_flag = 'Y')
889: OR (p_doc_revision_num IS NOT NULL
890: AND poll.revision_num =
891: (SELECT max(POLL2.revision_num)
892: FROM po_line_locations_archive_all poll2
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)

Line 1048: FROM po_line_locations_archive_all poll

1044: nvl2(l_mau
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'

Line 1059: FROM po_line_locations_archive_all poll2

1055: AND pod.latest_external_flag = 'Y')
1056: OR (p_doc_revision_num IS NOT NULL
1057: AND poll.revision_num =
1058: (SELECT max(POLL2.revision_num)
1059: FROM po_line_locations_archive_all poll2
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)

Line 1198: FROM po_line_locations_archive_all poll

1194:
1195: BEGIN
1196: SELECT SUM(nvl(amount_billed,0))
1197: INTO l_return_val
1198: FROM po_line_locations_archive_all poll
1199: WHERE poll.po_line_id = p_line_id
1200: AND poll.shipment_type='STANDARD'
1201: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1202: OR (p_doc_revision_num IS NOT NULL

Line 1205: FROM po_line_locations_archive_all poll2

1201: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1202: OR (p_doc_revision_num IS NOT NULL
1203: AND poll.revision_num =
1204: (SELECT max(POLL2.revision_num)
1205: FROM po_line_locations_archive_all poll2
1206: WHERE poll2.line_location_id = poll.line_location_id
1207: AND poll2.revision_num <= p_doc_revision_num)
1208: )
1209: )

Line 1340: FROM po_line_locations_archive_all poll

1336:
1337: BEGIN
1338: SELECT SUM(nvl(amount_billed,0))
1339: INTO l_return_val
1340: FROM po_line_locations_archive_all poll
1341: WHERE poll.po_header_id = p_header_id
1342: AND poll.shipment_type='STANDARD'
1343: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1344: OR (p_doc_revision_num IS NOT NULL

Line 1347: FROM po_line_locations_archive_all poll2

1343: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1344: OR (p_doc_revision_num IS NOT NULL
1345: AND poll.revision_num =
1346: (SELECT max(POLL2.revision_num)
1347: FROM po_line_locations_archive_all poll2
1348: WHERE poll2.line_location_id = poll.line_location_id
1349: AND poll2.revision_num <= p_doc_revision_num)
1350: )
1351: )

Line 1481: FROM po_line_locations_archive_all poll

1477:
1478: BEGIN
1479: SELECT SUM(nvl(amount_financed,0))
1480: INTO l_return_val
1481: FROM po_line_locations_archive_all poll
1482: WHERE poll.po_line_id = p_line_id
1483: AND poll.shipment_type='PREPAYMENT'
1484: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1485: OR (p_doc_revision_num IS NOT NULL

Line 1488: FROM po_line_locations_archive_all poll2

1484: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1485: OR (p_doc_revision_num IS NOT NULL
1486: AND poll.revision_num =
1487: (SELECT max(POLL2.revision_num)
1488: FROM po_line_locations_archive_all poll2
1489: WHERE poll2.line_location_id = poll.line_location_id
1490: AND poll2.revision_num <= p_doc_revision_num)
1491: )
1492: )

Line 1623: FROM po_line_locations_archive_all poll

1619:
1620: BEGIN
1621: SELECT SUM(nvl(amount_financed,0))
1622: INTO l_return_val
1623: FROM po_line_locations_archive_all poll
1624: WHERE poll.po_header_id = p_header_id
1625: AND poll.shipment_type='PREPAYMENT'
1626: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1627: OR (p_doc_revision_num IS NOT NULL

Line 1630: FROM po_line_locations_archive_all poll2

1626: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1627: OR (p_doc_revision_num IS NOT NULL
1628: AND poll.revision_num =
1629: (SELECT max(POLL2.revision_num)
1630: FROM po_line_locations_archive_all poll2
1631: WHERE poll2.line_location_id = poll.line_location_id
1632: AND poll2.revision_num <= p_doc_revision_num)
1633: )
1634: )

Line 1761: FROM po_line_locations_archive_all poll

1757:
1758: BEGIN
1759: SELECT SUM(nvl(amount_recouped,0))
1760: INTO l_return_val
1761: FROM po_line_locations_archive_all poll
1762: WHERE poll.po_line_id = p_line_id
1763: AND poll.shipment_type='PREPAYMENT'
1764: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1765: OR (p_doc_revision_num IS NOT NULL

Line 1768: FROM po_line_locations_archive_all poll2

1764: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1765: OR (p_doc_revision_num IS NOT NULL
1766: AND poll.revision_num =
1767: (SELECT max(POLL2.revision_num)
1768: FROM po_line_locations_archive_all poll2
1769: WHERE poll2.line_location_id = poll.line_location_id
1770: AND poll2.revision_num <= p_doc_revision_num)
1771: )
1772: )

Line 1900: FROM po_line_locations_archive_all poll

1896:
1897: BEGIN
1898: SELECT SUM(nvl(amount_recouped,0))
1899: INTO l_return_val
1900: FROM po_line_locations_archive_all poll
1901: WHERE poll.po_header_id = p_header_id
1902: AND poll.shipment_type='PREPAYMENT'
1903: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1904: OR (p_doc_revision_num IS NOT NULL

Line 1907: FROM po_line_locations_archive_all poll2

1903: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1904: OR (p_doc_revision_num IS NOT NULL
1905: AND poll.revision_num =
1906: (SELECT max(POLL2.revision_num)
1907: FROM po_line_locations_archive_all poll2
1908: WHERE poll2.line_location_id = poll.line_location_id
1909: AND poll2.revision_num <= p_doc_revision_num)
1910: )
1911: )

Line 2041: FROM po_line_locations_archive_all poll

2037: BEGIN
2038: SELECT SUM(nvl(retainage_withheld_amount,0)
2039: - nvl(retainage_released_amount,0))
2040: INTO l_return_val
2041: FROM po_line_locations_archive_all poll
2042: WHERE poll.po_line_id = p_line_id
2043: AND poll.shipment_type='STANDARD'
2044: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2045: OR (p_doc_revision_num IS NOT NULL

Line 2048: FROM po_line_locations_archive_all poll2

2044: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2045: OR (p_doc_revision_num IS NOT NULL
2046: AND poll.revision_num =
2047: (SELECT max(POLL2.revision_num)
2048: FROM po_line_locations_archive_all poll2
2049: WHERE poll2.line_location_id = poll.line_location_id
2050: AND poll2.revision_num <= p_doc_revision_num)
2051: )
2052: )

Line 2183: FROM po_line_locations_archive_all poll

2179: BEGIN
2180: SELECT SUM(nvl(retainage_withheld_amount,0)
2181: - nvl(retainage_released_amount,0))
2182: INTO l_return_val
2183: FROM po_line_locations_archive_all poll
2184: WHERE poll.po_header_id = p_header_id
2185: AND poll.shipment_type='STANDARD'
2186: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2187: OR (p_doc_revision_num IS NOT NULL

Line 2190: FROM po_line_locations_archive_all poll2

2186: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2187: OR (p_doc_revision_num IS NOT NULL
2188: AND poll.revision_num =
2189: (SELECT max(POLL2.revision_num)
2190: FROM po_line_locations_archive_all poll2
2191: WHERE poll2.line_location_id = poll.line_location_id
2192: AND poll2.revision_num <= p_doc_revision_num)
2193: )
2194: )

Line 3681: PO_LINE_LOCATIONS_ARCHIVE_ALL POLL,

3677: DECODE(p_doc_level, g_doc_level_DISTRIBUTION, 0, POLL.amount_shipped),
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

Line 3690: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLL2

3686: AND ( (p_doc_revision_num IS NULL AND POLL.latest_external_flag = 'Y')
3687: OR (p_doc_revision_num IS NOT NULL
3688: AND POLL.revision_num =
3689: (SELECT max(POLL2.revision_num)
3690: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLL2
3691: WHERE POLL2.line_location_id = POLL.line_location_id
3692: AND POLL2.revision_num <= p_doc_revision_num)
3693: )
3694: )