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_ALL

Line 12: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE

8: PO_LOG.get_package_base('PO_DOCUMENT_TOTALS_PVT');
9:
10: -- Shipment type constants
11: C_ship_type_STANDARD CONSTANT
12: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
13: := PO_CORE_S.g_ship_type_STANDARD;
14: C_ship_type_PLANNED CONSTANT
15: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
16: := PO_CORE_S.g_ship_type_PLANNED;

Line 15: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE

11: C_ship_type_STANDARD CONSTANT
12: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
13: := PO_CORE_S.g_ship_type_STANDARD;
14: C_ship_type_PLANNED CONSTANT
15: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
16: := PO_CORE_S.g_ship_type_PLANNED;
17: C_ship_type_SCHEDULED CONSTANT
18: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
19: := PO_CORE_S.g_ship_type_SCHEDULED;

Line 18: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE

14: C_ship_type_PLANNED CONSTANT
15: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
16: := PO_CORE_S.g_ship_type_PLANNED;
17: C_ship_type_SCHEDULED CONSTANT
18: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
19: := PO_CORE_S.g_ship_type_SCHEDULED;
20: C_ship_type_BLANKET CONSTANT
21: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
22: := PO_CORE_S.g_ship_type_BLANKET;

Line 21: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE

17: C_ship_type_SCHEDULED CONSTANT
18: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
19: := PO_CORE_S.g_ship_type_SCHEDULED;
20: C_ship_type_BLANKET CONSTANT
21: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
22: := PO_CORE_S.g_ship_type_BLANKET;
23: C_ship_type_PREPAYMENT CONSTANT
24: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
25: := PO_CORE_S.g_ship_type_PREPAYMENT;

Line 24: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE

20: C_ship_type_BLANKET CONSTANT
21: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
22: := PO_CORE_S.g_ship_type_BLANKET;
23: C_ship_type_PREPAYMENT CONSTANT
24: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE
25: := PO_CORE_S.g_ship_type_PREPAYMENT;
26:
27: -- Payment type constants
28: C_payment_type_MILESTONE CONSTANT

Line 29: PO_LINE_LOCATIONS_ALL.payment_type%TYPE

25: := PO_CORE_S.g_ship_type_PREPAYMENT;
26:
27: -- Payment type constants
28: C_payment_type_MILESTONE CONSTANT
29: PO_LINE_LOCATIONS_ALL.payment_type%TYPE
30: := PO_CORE_S.g_payment_type_MILESTONE;
31:
32: C_payment_type_RATE CONSTANT
33: PO_LINE_LOCATIONS_ALL.payment_type%TYPE

Line 33: PO_LINE_LOCATIONS_ALL.payment_type%TYPE

29: PO_LINE_LOCATIONS_ALL.payment_type%TYPE
30: := PO_CORE_S.g_payment_type_MILESTONE;
31:
32: C_payment_type_RATE CONSTANT
33: PO_LINE_LOCATIONS_ALL.payment_type%TYPE
34: := PO_CORE_S.g_payment_type_RATE;
35:
36: C_payment_type_LUMPSUM CONSTANT
37: PO_LINE_LOCATIONS_ALL.payment_type%TYPE

Line 37: PO_LINE_LOCATIONS_ALL.payment_type%TYPE

33: PO_LINE_LOCATIONS_ALL.payment_type%TYPE
34: := PO_CORE_S.g_payment_type_RATE;
35:
36: C_payment_type_LUMPSUM CONSTANT
37: PO_LINE_LOCATIONS_ALL.payment_type%TYPE
38: := PO_CORE_S.g_payment_type_LUMPSUM;
39:
40: -------------------------------------------------------------------------------
41: -- Spec definitions for private procedures

Line 325: FROM po_line_locations_all poll

321: *poll.price_override/l_mau) * l_mau
322: , round(((poll.quantity-nvl(poll.quantity_cancelled,0))
323: *poll.price_override),l_precision) )) -- Bug# 5378134
324: INTO l_return_val
325: FROM po_line_locations_all poll
326: WHERE poll.line_location_id = p_doc_level_id
327: ;
328:
329: ELSIF p_data_source = g_data_source_ARCHIVE THEN

Line 379: FROM po_line_locations_all poll

375: *poll.price_override/l_mau) * l_mau
376: , round(((pod.quantity_ordered-nvl(pod.quantity_cancelled,0))
377: *poll.price_override),l_precision) )) -- Bug# 5378134
378: INTO l_return_val
379: FROM po_line_locations_all poll
380: , po_distributions_all pod
381: WHERE pod.po_distribution_id = p_doc_level_id
382: AND poll.line_location_id = pod.line_location_id
383: ;

Line 536: FROM po_line_locations_all poll

532: nvl2(l_mau
533: , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
534: , round((poll.quantity_received*poll.price_override),l_precision)) )) --Bug5391045
535: INTO l_return_val
536: FROM po_line_locations_all poll
537: WHERE poll.po_line_id = p_line_id
538: AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE') --Bug5391045
539: ;
540: EXCEPTION

Line 689: FROM po_line_locations_all poll

685: nvl2(l_mau
686: , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
687: , round((poll.quantity_received*poll.price_override),l_precision)) )) --Bug5391045
688: INTO l_return_val
689: FROM po_line_locations_all poll
690: WHERE poll.po_header_id = p_header_id
691: AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE') --Bug5391045
692: ;
693: EXCEPTION

Line 845: FROM po_line_locations_all poll

841: nvl2(l_mau
842: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
843: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
844: INTO l_return_val
845: FROM po_line_locations_all poll
846: , po_distributions_all pod
847: WHERE poll.po_line_id = p_line_id
848: AND pod.line_location_id = poll.line_location_id
849: AND pod.distribution_type = 'STANDARD'

Line 1012: FROM po_line_locations_all poll

1008: nvl2(l_mau
1009: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
1010: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
1011: INTO l_return_val
1012: FROM po_line_locations_all poll
1013: , po_distributions_all pod
1014: WHERE poll.po_header_id = p_header_id
1015: AND pod.line_location_id = poll.line_location_id
1016: AND pod.distribution_type = 'STANDARD'

Line 1170: FROM po_line_locations_all poll

1166:
1167: BEGIN
1168: SELECT SUM(nvl(amount_billed,0))
1169: INTO l_return_val
1170: FROM po_line_locations_all poll
1171: WHERE poll.po_line_id = p_line_id
1172: AND poll.shipment_type = 'STANDARD'
1173: ;
1174: EXCEPTION

Line 1312: FROM po_line_locations_all poll

1308:
1309: BEGIN
1310: SELECT SUM(nvl(amount_billed,0))
1311: INTO l_return_val
1312: FROM po_line_locations_all poll
1313: WHERE poll.po_header_id = p_header_id
1314: AND poll.shipment_type = 'STANDARD'
1315: ;
1316: EXCEPTION

Line 1453: FROM po_line_locations_all poll

1449:
1450: BEGIN
1451: SELECT SUM(nvl(amount_financed,0))
1452: INTO l_return_val
1453: FROM po_line_locations_all poll
1454: WHERE poll.po_line_id = p_line_id
1455: AND poll.shipment_type = 'PREPAYMENT'
1456: ;
1457: EXCEPTION

Line 1595: FROM po_line_locations_all poll

1591:
1592: BEGIN
1593: SELECT SUM(nvl(amount_financed,0))
1594: INTO l_return_val
1595: FROM po_line_locations_all poll
1596: WHERE poll.po_header_id = p_header_id
1597: AND poll.shipment_type = 'PREPAYMENT'
1598: ;
1599: EXCEPTION

Line 1733: FROM po_line_locations_all poll

1729:
1730: BEGIN
1731: SELECT SUM(nvl(amount_recouped,0))
1732: INTO l_return_val
1733: FROM po_line_locations_all poll
1734: WHERE poll.po_line_id = p_line_id
1735: AND poll.shipment_type = 'PREPAYMENT'
1736: ;
1737: EXCEPTION

Line 1872: FROM po_line_locations_all poll

1868:
1869: BEGIN
1870: SELECT SUM(nvl(amount_recouped,0))
1871: INTO l_return_val
1872: FROM po_line_locations_all poll
1873: WHERE poll.po_header_id = p_header_id
1874: AND poll.shipment_type = 'PREPAYMENT'
1875: ;
1876: EXCEPTION

Line 2012: FROM po_line_locations_all poll

2008: BEGIN
2009: SELECT SUM(nvl(retainage_withheld_amount,0)
2010: - nvl(retainage_released_amount,0))
2011: INTO l_return_val
2012: FROM po_line_locations_all poll
2013: WHERE poll.po_line_id = p_line_id
2014: AND poll.shipment_type = 'STANDARD'
2015: ;
2016: EXCEPTION

Line 2154: FROM po_line_locations_all poll

2150: BEGIN
2151: SELECT SUM(nvl(retainage_withheld_amount,0)
2152: - nvl(retainage_released_amount,0))
2153: INTO l_return_val
2154: FROM po_line_locations_all poll
2155: WHERE poll.po_header_id = p_header_id
2156: AND poll.shipment_type = 'STANDARD'
2157: ;
2158: EXCEPTION

Line 2284: FROM po_line_locations_all poll

2280:
2281: BEGIN
2282: SELECT SUM(poll.quantity)
2283: INTO l_return_val
2284: FROM po_line_locations_all poll
2285: WHERE poll.po_line_id = p_line_id
2286: AND poll.shipment_type = 'STANDARD'
2287: ;
2288: EXCEPTION

Line 2393: FROM po_line_locations_all poll

2389: *poll.price_override/l_mau) * l_mau
2390: , round(((poll.quantity-nvl(poll.quantity_cancelled,0))
2391: *poll.price_override),l_precision) ) )) --Bug5391045
2392: INTO l_return_val
2393: FROM po_line_locations_all poll
2394: WHERE poll.po_line_id = p_line_id
2395: AND poll.shipment_type = 'STANDARD'
2396: ;
2397: EXCEPTION

Line 2632: FROM po_line_locations_all poll

2628:
2629: d_position := 40;
2630: SELECT poll.po_header_id
2631: INTO l_header_id
2632: FROM po_line_locations_all poll
2633: WHERE poll.line_location_id = p_doc_level_id;
2634:
2635: ELSIF p_doc_level = g_doc_level_DISTRIBUTION THEN
2636:

Line 3469: PO_LINE_LOCATIONS_ALL POLL,

3465: DECODE(p_doc_level, g_doc_level_DISTRIBUTION, 0, POLL.amount_shipped),
3466: SUM( nvl(POD.retainage_withheld_amount,0) ),
3467: SUM( nvl(POD.retainage_released_amount,0) )
3468: FROM
3469: PO_LINE_LOCATIONS_ALL POLL,
3470: PO_DISTRIBUTIONS_ALL POD
3471: WHERE POD.po_distribution_id = l_distribution_id_tbl(i)
3472: AND POD.line_location_id = POLL.line_location_id
3473: GROUP BY POLL.line_location_id, POLL.value_basis, POLL.shipment_type,