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.POS_COMPLEX_WORK_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 35: from PO_LINE_LOCATIONS_ALL PLL

31: CURSOR l_amt_approved_csr IS
32: select SUM(DECODE(PLL.matching_basis,
33: 'AMOUNT', NVL(PLL.amount_received, 0),
34: 'QUANTITY', NVL(PLL.quantity_received, 0)*NVL(PLL.price_override, 0)))
35: from PO_LINE_LOCATIONS_ALL PLL
36: where PLL.po_header_id = p_po_header_id
37: and PLL.payment_type in ('MILESTONE', 'RATE', 'LUMPSUM');
38:
39:

Line 44: from PO_LINE_LOCATIONS_ALL PLL

40: CURSOR l_amt_billed_csr IS
41: select SUM(DECODE(PLL.matching_basis,
42: 'AMOUNT', NVL(PLL.amount_billed, 0),
43: 'QUANTITY', NVL(PLL.quantity_billed, 0)*NVL(PLL.price_override, 0)))
44: from PO_LINE_LOCATIONS_ALL PLL
45: where PLL.po_header_id = p_po_header_id
46: and PLL.payment_type <> 'ADVANCE'
47: and PLL.shipment_type = 'STANDARD';
48:

Line 51: from PO_LINE_LOCATIONS_ALL PLL

47: and PLL.shipment_type = 'STANDARD';
48:
49: CURSOR l_adv_billed_csr IS
50: select sum(NVL(PLL.amount_financed, 0))
51: from PO_LINE_LOCATIONS_ALL PLL
52: where PLL.po_header_id = p_po_header_id
53: and PLL.payment_type = 'ADVANCE'
54: and PLL.shipment_type = 'PREPAYMENT';
55:

Line 60: from PO_LINE_LOCATIONS_ALL PLL

56: CURSOR l_amt_financed_csr IS
57: select SUM(DECODE(PLL.matching_basis,
58: 'AMOUNT', NVL(PLL.amount_financed,0),
59: 'QUANTITY', NVL(PLL.quantity_financed, 0)*NVL(PLL.price_override, 0)))
60: from PO_LINE_LOCATIONS_ALL PLL
61: where PLL.po_header_id = p_po_header_id
62: and PLL.payment_type in ('MILESTONE', 'RATE', 'LUMPSUM')
63: and PLL.shipment_type = 'PREPAYMENT';
64:

Line 73: from PO_LINE_LOCATIONS_ALL PLL

69: 'QUANTITY', NVL(PLL.quantity_billed, 0)*NVL(PLL.price_override, 0)),
70: 'PREPAYMENT', DECODE(PLL.matching_basis,
71: 'AMOUNT', NVL(PLL.amount_financed, 0),
72: 'QUANTITY', NVL(PLL.quantity_financed, 0)*NVL(PLL.price_override, 0))))
73: from PO_LINE_LOCATIONS_ALL PLL
74: where PLL.po_header_id = p_po_header_id
75: and PLL.payment_type in ('MILESTONE', 'RATE', 'LUMPSUM')
76: and PLL.shipment_type in('STANDARD', 'PREPAYMENT'); --???
77:

Line 82: from PO_LINE_LOCATIONS_ALL PLL

78: CURSOR l_amt_recouped_csr IS
79: select SUM(DECODE(PLL.matching_basis,
80: 'AMOUNT', NVL(PLL.amount_recouped, 0),
81: 'QUANTITY', NVL(PLL.quantity_recouped, 0)*NVL(PLL.price_override, 0)))
82: from PO_LINE_LOCATIONS_ALL PLL
83: where PLL.po_header_id = p_po_header_id
84: and PLL.shipment_type = 'PREPAYMENT'; -- could be advance or financing pp
85:
86: CURSOR l_amt_retained_csr IS

Line 88: from PO_LINE_LOCATIONS_ALL PLL

84: and PLL.shipment_type = 'PREPAYMENT'; -- could be advance or financing pp
85:
86: CURSOR l_amt_retained_csr IS
87: select sum(NVL(PLL.retainage_withheld_amount,0) - NVL(retainage_released_amount,0))
88: from PO_LINE_LOCATIONS_ALL PLL
89: where PLL.po_header_id = p_po_header_id
90: and PLL.payment_type in ('MILESTONE', 'RATE', 'LUMPSUM')
91: and PLL.shipment_type = 'STANDARD';
92:

Line 97: PO_LINE_LOCATIONS_ALL PLL

93:
94: CURSOR l_amt_delivered_csr IS
95: select sum(NVL(RSL.amount, NVL(RSL.quantity_shipped,0)*NVL(PLL.price_override,0)))
96: from RCV_SHIPMENT_LINES RSL,
97: PO_LINE_LOCATIONS_ALL PLL
98: where PLL.po_header_id = p_po_header_id
99: and PLL.shipment_type = 'STANDARD'
100: and PLL.payment_type = 'DELIVERY'
101: and RSL.PO_line_location_id = PLL.line_location_id;

Line 230: PO_LINE_LOCATIONS_ALL PLL

226: NVL(RSL.quantity_shipped,0)*NVL(PLL.price_override,0)
227: )
228: )
229: from RCV_SHIPMENT_LINES RSL,
230: PO_LINE_LOCATIONS_ALL PLL
231: where PLL.po_line_id = p_po_line_id
232: and PLL.shipment_type = 'STANDARD'
233: --5488052 and PLL.payment_type = 'DELIVERY'
234: and RSL.PO_line_location_id = PLL.line_location_id

Line 242: from PO_LINE_LOCATIONS_ALL PLL

238: CURSOR l_amt_billed_csr IS
239: select SUM(DECODE(PLL.matching_basis,
240: 'AMOUNT', NVL(PLL.amount_billed, 0),
241: 'QUANTITY', NVL(PLL.quantity_billed, 0)*NVL(PLL.price_override, 0)))
242: from PO_LINE_LOCATIONS_ALL PLL
243: where PLL.po_line_id = p_po_line_id
244: --5488052 and PLL.payment_type = 'DELIVERY'
245: and PLL.shipment_type = 'STANDARD';
246:

Line 250: from PO_LINE_LOCATIONS_ALL PLL

246:
247:
248: CURSOR l_advance_amt_csr IS
249: select PLL.amount
250: from PO_LINE_LOCATIONS_ALL PLL
251: where PLL.po_line_id = p_po_line_id
252: and PLL.payment_type = 'ADVANCE'
253: and PLL.shipment_type = 'PREPAYMENT';
254:

Line 258: from PO_LINE_LOCATIONS_ALL PLL

254:
255:
256: CURSOR l_adv_billed_csr IS
257: select PLL.amount_financed
258: from PO_LINE_LOCATIONS_ALL PLL
259: where PLL.po_line_id = p_po_line_id
260: and PLL.payment_type = 'ADVANCE'
261: and PLL.shipment_type = 'PREPAYMENT';
262:

Line 268: from PO_LINE_LOCATIONS_ALL PLL

264: CURSOR l_amt_recouped_csr IS
265: select SUM(DECODE(PLL.matching_basis,
266: 'AMOUNT', NVL(PLL.amount_recouped, 0),
267: 'QUANTITY', NVL(PLL.quantity_recouped, 0)*NVL(PLL.price_override, 0)))
268: from PO_LINE_LOCATIONS_ALL PLL
269: where PLL.po_line_id = p_po_line_id
270: and PLL.shipment_type = 'PREPAYMENT'; -- could be advance or financ pp
271:
272:

Line 371: from PO_LINE_LOCATIONS_ALL PLL

367: CURSOR l_amt_approved_csr IS
368: select DECODE(PLL.matching_basis,
369: 'AMOUNT', NVL(PLL.amount_received, 0),
370: 'QUANTITY', NVL(PLL.quantity_received, 0)*NVL(PLL.price_override, 0))
371: from PO_LINE_LOCATIONS_ALL PLL
372: where PLL.line_location_id = p_po_line_location_id;
373:
374:
375: BEGIN