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 329: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all

325: *poll.price_override/l_mau) * l_mau
326: , round(((poll.quantity-nvl(poll.quantity_cancelled,0))
327: *poll.price_override),l_precision) )) -- Bug# 5378134
328: INTO l_return_val
329: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all
330: WHERE poll.line_location_id = p_doc_level_id
331: AND poll.draft_id = p_draft_id;
332:
333: ELSIF p_data_source = g_data_source_ARCHIVE THEN

Line 383: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all

379: *poll.price_override/l_mau) * l_mau
380: , round(((pod.quantity_ordered-nvl(pod.quantity_cancelled,0))
381: *poll.price_override),l_precision) )) -- Bug# 5378134
382: INTO l_return_val
383: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all
384: , po_distributions_merge_v pod -- Changed from po_distributions_all
385: WHERE pod.po_distribution_id = p_doc_level_id
386: AND poll.line_location_id = pod.line_location_id
387: AND poll.draft_id = pod.draft_id

Line 545: FROM po_line_locations_all poll

541: nvl2(l_mau
542: , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
543: , round((poll.quantity_received*poll.price_override),l_precision)) )) --Bug5391045
544: INTO l_return_val
545: FROM po_line_locations_all poll
546: WHERE poll.po_line_id = p_line_id
547: AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE') --Bug5391045
548: ;
549: EXCEPTION

Line 698: FROM po_line_locations_all poll

694: nvl2(l_mau
695: , round(poll.quantity_received*poll.price_override/l_mau) * l_mau
696: , round((poll.quantity_received*poll.price_override),l_precision)) )) --Bug5391045
697: INTO l_return_val
698: FROM po_line_locations_all poll
699: WHERE poll.po_header_id = p_header_id
700: AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE') --Bug5391045
701: ;
702: EXCEPTION

Line 854: FROM po_line_locations_all poll

850: nvl2(l_mau
851: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
852: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
853: INTO l_return_val
854: FROM po_line_locations_all poll
855: , po_distributions_all pod
856: WHERE poll.po_line_id = p_line_id
857: AND pod.line_location_id = poll.line_location_id
858: AND pod.distribution_type = 'STANDARD'

Line 1021: FROM po_line_locations_all poll

1017: nvl2(l_mau
1018: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
1019: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
1020: INTO l_return_val
1021: FROM po_line_locations_all poll
1022: , po_distributions_all pod
1023: WHERE poll.po_header_id = p_header_id
1024: AND pod.line_location_id = poll.line_location_id
1025: AND pod.distribution_type = 'STANDARD'

Line 1179: FROM po_line_locations_all poll

1175:
1176: BEGIN
1177: SELECT SUM(nvl(amount_billed,0))
1178: INTO l_return_val
1179: FROM po_line_locations_all poll
1180: WHERE poll.po_line_id = p_line_id
1181: AND poll.shipment_type = 'STANDARD'
1182: ;
1183: EXCEPTION

Line 1321: FROM po_line_locations_all poll

1317:
1318: BEGIN
1319: SELECT SUM(nvl(amount_billed,0))
1320: INTO l_return_val
1321: FROM po_line_locations_all poll
1322: WHERE poll.po_header_id = p_header_id
1323: AND poll.shipment_type = 'STANDARD'
1324: ;
1325: EXCEPTION

Line 1462: FROM po_line_locations_all poll

1458:
1459: BEGIN
1460: SELECT SUM(nvl(amount_financed,0))
1461: INTO l_return_val
1462: FROM po_line_locations_all poll
1463: WHERE poll.po_line_id = p_line_id
1464: AND poll.shipment_type = 'PREPAYMENT'
1465: ;
1466: EXCEPTION

Line 1604: FROM po_line_locations_all poll

1600:
1601: BEGIN
1602: SELECT SUM(nvl(amount_financed,0))
1603: INTO l_return_val
1604: FROM po_line_locations_all poll
1605: WHERE poll.po_header_id = p_header_id
1606: AND poll.shipment_type = 'PREPAYMENT'
1607: ;
1608: EXCEPTION

Line 1742: FROM po_line_locations_all poll

1738:
1739: BEGIN
1740: SELECT SUM(nvl(amount_recouped,0))
1741: INTO l_return_val
1742: FROM po_line_locations_all poll
1743: WHERE poll.po_line_id = p_line_id
1744: AND poll.shipment_type = 'PREPAYMENT'
1745: ;
1746: EXCEPTION

Line 1881: FROM po_line_locations_all poll

1877:
1878: BEGIN
1879: SELECT SUM(nvl(amount_recouped,0))
1880: INTO l_return_val
1881: FROM po_line_locations_all poll
1882: WHERE poll.po_header_id = p_header_id
1883: AND poll.shipment_type = 'PREPAYMENT'
1884: ;
1885: EXCEPTION

Line 2021: FROM po_line_locations_all poll

2017: BEGIN
2018: SELECT SUM(nvl(retainage_withheld_amount,0)
2019: - nvl(retainage_released_amount,0))
2020: INTO l_return_val
2021: FROM po_line_locations_all poll
2022: WHERE poll.po_line_id = p_line_id
2023: AND poll.shipment_type = 'STANDARD'
2024: ;
2025: EXCEPTION

Line 2163: FROM po_line_locations_all poll

2159: BEGIN
2160: SELECT SUM(nvl(retainage_withheld_amount,0)
2161: - nvl(retainage_released_amount,0))
2162: INTO l_return_val
2163: FROM po_line_locations_all poll
2164: WHERE poll.po_header_id = p_header_id
2165: AND poll.shipment_type = 'STANDARD'
2166: ;
2167: EXCEPTION

Line 2295: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all

2291:
2292: BEGIN
2293: SELECT SUM(poll.quantity)
2294: INTO l_return_val
2295: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all
2296: WHERE poll.po_line_id = p_line_id
2297: AND poll.draft_id = p_draft_id
2298: AND poll.shipment_type = 'STANDARD';
2299: EXCEPTION

Line 2406: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all

2402: *poll.price_override/l_mau) * l_mau
2403: , round(((poll.quantity-nvl(poll.quantity_cancelled,0))
2404: *poll.price_override),l_precision) ) )) --Bug5391045
2405: INTO l_return_val
2406: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all
2407: WHERE poll.po_line_id = p_line_id
2408: AND poll.draft_id = p_draft_id
2409: AND poll.shipment_type = 'STANDARD'
2410: ;

Line 3588: PO_LINE_LOCATIONS_ALL POLL,

3584: DECODE(p_doc_level, g_doc_level_DISTRIBUTION, 0, POLL.amount_shipped),
3585: SUM( nvl(POD.retainage_withheld_amount,0) ),
3586: SUM( nvl(POD.retainage_released_amount,0) )
3587: FROM
3588: PO_LINE_LOCATIONS_ALL POLL,
3589: PO_DISTRIBUTIONS_ALL POD
3590: WHERE POD.po_distribution_id = l_distribution_id_tbl(i)
3591: AND POD.line_location_id = POLL.line_location_id
3592: GROUP BY POLL.line_location_id, POLL.value_basis, POLL.shipment_type,