APPS.POS_COMPLEX_WORK_PVT dependencies on STANDARD

Line 47: and PLL.shipment_type = 'STANDARD';

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:
49: CURSOR l_adv_billed_csr IS
50: select sum(NVL(PLL.amount_financed, 0))
51: from PO_LINE_LOCATIONS_ALL PLL

Line 67: 'STANDARD', DECODE(PLL.matching_basis,

63: and PLL.shipment_type = 'PREPAYMENT';
64:
65: CURSOR l_progress_pmt_csr IS
66: select SUM(DECODE(PLL.shipment_type,
67: 'STANDARD', DECODE(PLL.matching_basis,
68: 'AMOUNT', NVL(PLL.amount_billed, 0),
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),

Line 76: and PLL.shipment_type in('STANDARD', 'PREPAYMENT'); --???

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:
78: CURSOR l_amt_recouped_csr IS
79: select SUM(DECODE(PLL.matching_basis,
80: 'AMOUNT', NVL(PLL.amount_recouped, 0),

Line 91: and PLL.shipment_type = 'STANDARD';

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:
93:
94: CURSOR l_amt_delivered_csr IS
95: select sum(NVL(RSL.amount, NVL(RSL.quantity_shipped,0)*NVL(PLL.price_override,0)))

Line 99: and PLL.shipment_type = 'STANDARD'

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;
102: --and RSL.approval_status in ('APPROVED', 'PROCESSED');
103:

Line 232: and PLL.shipment_type = 'STANDARD'

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
235: and RSL.approval_status in ('APPROVED', 'PROCESSED');
236:

Line 245: and PLL.shipment_type = 'STANDARD';

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:
247:
248: CURSOR l_advance_amt_csr IS
249: select PLL.amount