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 342: FROM po_line_locations_archive_all poll

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

Line 348: FROM po_line_locations_archive_all poll2

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

Line 398: FROM po_line_locations_archive_all poll

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

Line 413: FROM po_line_locations_archive_all poll2

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)
413: FROM po_line_locations_archive_all poll2
414: WHERE poll2.line_location_id = poll.line_location_id
415: AND poll2.revision_num <= p_doc_revision_num)
416: )
417: )

Line 561: FROM po_line_locations_archive_all poll

557: nvl2(l_mau
558: , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
559: , round((poll.quantity_received*poll.price_override),l_precision)) )) --Bug5391045
560: INTO l_return_val
561: FROM po_line_locations_archive_all poll
562: WHERE poll.po_line_id = p_line_id
563: AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE') --Bug5391045
564: AND ( (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
565: OR (p_doc_revision_num IS NOT NULL

Line 568: FROM po_line_locations_archive_all poll2

564: AND ( (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
565: OR (p_doc_revision_num IS NOT NULL
566: AND poll.revision_num =
567: (SELECT max(POLL2.revision_num)
568: FROM po_line_locations_archive_all poll2
569: WHERE poll2.line_location_id = poll.line_location_id
570: AND poll2.revision_num <= p_doc_revision_num)
571: )
572: )

Line 714: FROM po_line_locations_archive_all poll

710: nvl2(l_mau
711: , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
712: , round((poll.quantity_received*poll.price_override),l_precision)) )) --Bug5391045
713: INTO l_return_val
714: FROM po_line_locations_archive_all poll
715: WHERE poll.po_header_id = p_header_id
716: AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE') --Bug5391045
717: AND ( (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
718: OR (p_doc_revision_num IS NOT NULL

Line 721: FROM po_line_locations_archive_all poll2

717: AND ( (p_doc_revision_num IS NULL and poll.latest_external_flag = 'Y')
718: OR (p_doc_revision_num IS NOT NULL
719: AND poll.revision_num =
720: (SELECT max(POLL2.revision_num)
721: FROM po_line_locations_archive_all poll2
722: WHERE poll2.line_location_id = poll.line_location_id
723: AND poll2.revision_num <= p_doc_revision_num)
724: )
725: )

Line 872: FROM po_line_locations_archive_all poll

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

Line 883: FROM po_line_locations_archive_all poll2

879: AND pod.latest_external_flag = 'Y')
880: OR (p_doc_revision_num IS NOT NULL
881: AND poll.revision_num =
882: (SELECT max(POLL2.revision_num)
883: FROM po_line_locations_archive_all poll2
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)

Line 1039: FROM po_line_locations_archive_all poll

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

Line 1050: FROM po_line_locations_archive_all poll2

1046: AND pod.latest_external_flag = 'Y')
1047: OR (p_doc_revision_num IS NOT NULL
1048: AND poll.revision_num =
1049: (SELECT max(POLL2.revision_num)
1050: FROM po_line_locations_archive_all poll2
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)

Line 1189: FROM po_line_locations_archive_all poll

1185:
1186: BEGIN
1187: SELECT SUM(nvl(amount_billed,0))
1188: INTO l_return_val
1189: FROM po_line_locations_archive_all poll
1190: WHERE poll.po_line_id = p_line_id
1191: AND poll.shipment_type='STANDARD'
1192: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1193: OR (p_doc_revision_num IS NOT NULL

Line 1196: FROM po_line_locations_archive_all poll2

1192: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1193: OR (p_doc_revision_num IS NOT NULL
1194: AND poll.revision_num =
1195: (SELECT max(POLL2.revision_num)
1196: FROM po_line_locations_archive_all poll2
1197: WHERE poll2.line_location_id = poll.line_location_id
1198: AND poll2.revision_num <= p_doc_revision_num)
1199: )
1200: )

Line 1331: FROM po_line_locations_archive_all poll

1327:
1328: BEGIN
1329: SELECT SUM(nvl(amount_billed,0))
1330: INTO l_return_val
1331: FROM po_line_locations_archive_all poll
1332: WHERE poll.po_header_id = p_header_id
1333: AND poll.shipment_type='STANDARD'
1334: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1335: OR (p_doc_revision_num IS NOT NULL

Line 1338: FROM po_line_locations_archive_all poll2

1334: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1335: OR (p_doc_revision_num IS NOT NULL
1336: AND poll.revision_num =
1337: (SELECT max(POLL2.revision_num)
1338: FROM po_line_locations_archive_all poll2
1339: WHERE poll2.line_location_id = poll.line_location_id
1340: AND poll2.revision_num <= p_doc_revision_num)
1341: )
1342: )

Line 1472: FROM po_line_locations_archive_all poll

1468:
1469: BEGIN
1470: SELECT SUM(nvl(amount_financed,0))
1471: INTO l_return_val
1472: FROM po_line_locations_archive_all poll
1473: WHERE poll.po_line_id = p_line_id
1474: AND poll.shipment_type='PREPAYMENT'
1475: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1476: OR (p_doc_revision_num IS NOT NULL

Line 1479: FROM po_line_locations_archive_all poll2

1475: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1476: OR (p_doc_revision_num IS NOT NULL
1477: AND poll.revision_num =
1478: (SELECT max(POLL2.revision_num)
1479: FROM po_line_locations_archive_all poll2
1480: WHERE poll2.line_location_id = poll.line_location_id
1481: AND poll2.revision_num <= p_doc_revision_num)
1482: )
1483: )

Line 1614: FROM po_line_locations_archive_all poll

1610:
1611: BEGIN
1612: SELECT SUM(nvl(amount_financed,0))
1613: INTO l_return_val
1614: FROM po_line_locations_archive_all poll
1615: WHERE poll.po_header_id = p_header_id
1616: AND poll.shipment_type='PREPAYMENT'
1617: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1618: OR (p_doc_revision_num IS NOT NULL

Line 1621: FROM po_line_locations_archive_all poll2

1617: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1618: OR (p_doc_revision_num IS NOT NULL
1619: AND poll.revision_num =
1620: (SELECT max(POLL2.revision_num)
1621: FROM po_line_locations_archive_all poll2
1622: WHERE poll2.line_location_id = poll.line_location_id
1623: AND poll2.revision_num <= p_doc_revision_num)
1624: )
1625: )

Line 1752: FROM po_line_locations_archive_all poll

1748:
1749: BEGIN
1750: SELECT SUM(nvl(amount_recouped,0))
1751: INTO l_return_val
1752: FROM po_line_locations_archive_all poll
1753: WHERE poll.po_line_id = p_line_id
1754: AND poll.shipment_type='PREPAYMENT'
1755: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1756: OR (p_doc_revision_num IS NOT NULL

Line 1759: FROM po_line_locations_archive_all poll2

1755: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1756: OR (p_doc_revision_num IS NOT NULL
1757: AND poll.revision_num =
1758: (SELECT max(POLL2.revision_num)
1759: FROM po_line_locations_archive_all poll2
1760: WHERE poll2.line_location_id = poll.line_location_id
1761: AND poll2.revision_num <= p_doc_revision_num)
1762: )
1763: )

Line 1891: FROM po_line_locations_archive_all poll

1887:
1888: BEGIN
1889: SELECT SUM(nvl(amount_recouped,0))
1890: INTO l_return_val
1891: FROM po_line_locations_archive_all poll
1892: WHERE poll.po_header_id = p_header_id
1893: AND poll.shipment_type='PREPAYMENT'
1894: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1895: OR (p_doc_revision_num IS NOT NULL

Line 1898: FROM po_line_locations_archive_all poll2

1894: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
1895: OR (p_doc_revision_num IS NOT NULL
1896: AND poll.revision_num =
1897: (SELECT max(POLL2.revision_num)
1898: FROM po_line_locations_archive_all poll2
1899: WHERE poll2.line_location_id = poll.line_location_id
1900: AND poll2.revision_num <= p_doc_revision_num)
1901: )
1902: )

Line 2032: FROM po_line_locations_archive_all poll

2028: BEGIN
2029: SELECT SUM(nvl(retainage_withheld_amount,0)
2030: - nvl(retainage_released_amount,0))
2031: INTO l_return_val
2032: FROM po_line_locations_archive_all poll
2033: WHERE poll.po_line_id = p_line_id
2034: AND poll.shipment_type='STANDARD'
2035: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2036: OR (p_doc_revision_num IS NOT NULL

Line 2039: FROM po_line_locations_archive_all poll2

2035: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2036: OR (p_doc_revision_num IS NOT NULL
2037: AND poll.revision_num =
2038: (SELECT max(POLL2.revision_num)
2039: FROM po_line_locations_archive_all poll2
2040: WHERE poll2.line_location_id = poll.line_location_id
2041: AND poll2.revision_num <= p_doc_revision_num)
2042: )
2043: )

Line 2174: FROM po_line_locations_archive_all poll

2170: BEGIN
2171: SELECT SUM(nvl(retainage_withheld_amount,0)
2172: - nvl(retainage_released_amount,0))
2173: INTO l_return_val
2174: FROM po_line_locations_archive_all poll
2175: WHERE poll.po_header_id = p_header_id
2176: AND poll.shipment_type='STANDARD'
2177: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2178: OR (p_doc_revision_num IS NOT NULL

Line 2181: FROM po_line_locations_archive_all poll2

2177: AND ( (p_doc_revision_num IS NULL AND poll.latest_external_flag = 'Y')
2178: OR (p_doc_revision_num IS NOT NULL
2179: AND poll.revision_num =
2180: (SELECT max(POLL2.revision_num)
2181: FROM po_line_locations_archive_all poll2
2182: WHERE poll2.line_location_id = poll.line_location_id
2183: AND poll2.revision_num <= p_doc_revision_num)
2184: )
2185: )

Line 3562: PO_LINE_LOCATIONS_ARCHIVE_ALL POLL,

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

Line 3571: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLL2

3567: AND ( (p_doc_revision_num IS NULL AND POLL.latest_external_flag = 'Y')
3568: OR (p_doc_revision_num IS NOT NULL
3569: AND POLL.revision_num =
3570: (SELECT max(POLL2.revision_num)
3571: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLL2
3572: WHERE POLL2.line_location_id = POLL.line_location_id
3573: AND POLL2.revision_num <= p_doc_revision_num)
3574: )
3575: )