[Home] [Help]
444: WHEN PLL.shipment_type <> c_STANDARD THEN 0
445: ELSE GREATEST(NVL(PLL.quantity_billed, 0),
446: NVL(PLL.quantity_financed, 0))
447: END)), 0) sum_qty_bill_actuals
448: FROM PO_LINE_LOCATIONS_ALL PLL
449: WHERE PLL.po_line_id = p_line_id_tbl(i)
450: AND NVL(PLL.payment_type, c_DELIVERY) <> c_MILESTONE
451: )
452: ) POLL_TOTAL, PO_LINES_ALL POL
974: END
975: ELSE GREATEST(NVL(PLL.amount_billed, 0),
976: NVL(PLL.amount_financed, 0))
977: END)), 0) sum_amt_bill_actuals
978: FROM PO_LINE_LOCATIONS_ALL PLL
979: , PO_SESSION_GT GTT
980: WHERE PLL.po_line_id = p_line_id_tbl(i)
981: AND GTT.key = l_gt_key
982: AND GTT.index_num1(+) = PLL.po_line_id
2452: FROM
2453: ( SELECT
2454: NVL(MAX(quantity_received), 0) max_qty_recv,
2455: NVL(MAX(quantity_billed), 0) max_qty_bill
2456: FROM PO_LINE_LOCATIONS_ALL PLL
2457: WHERE PLL.po_line_id = p_line_id_tbl(i)
2458: AND PLL.payment_type = c_MILESTONE
2459: AND PLL.value_basis = c_QUANTITY
2460: AND PLL.shipment_type = c_STANDARD
2541: WHEN PLL.quantity_billed > 0
2542: THEN NVL(PLL.price_override, 0)
2543: ELSE 0
2544: END),0) sum_price_executed
2545: FROM PO_LINE_LOCATIONS_ALL PLL
2546: WHERE PLL.po_line_id = p_line_id_tbl(i)
2547: AND PLL.payment_type = c_MILESTONE
2548: AND PLL.value_basis = c_QUANTITY
2549: AND PLL.shipment_type = c_STANDARD
3383: , TO_CHAR(LOCATIONS_TOTAL.amount_retained)
3384: FROM
3385: ( SELECT NVL(SUM(POLL.retainage_withheld_amount),0) amount_retained
3386: FROM
3387: PO_LINE_LOCATIONS_ALL POLL
3388: WHERE
3389: POLL.po_line_id = p_line_id_tbl(i)
3390: ) LOCATIONS_TOTAL
3391: WHERE
3897: FROM DUAL
3898: WHERE nvl(p_control_action_tbl(i), '*') = 'CANCEL'
3899: AND not exists
3900: (SELECT 'Y'
3901: FROM PO_LINE_LOCATIONS_ALL
3902: WHERE po_line_id = p_line_id_tbl(i)
3903: AND quantity > quantity_received);
3904:
3905: IF (SQL%ROWCOUNT > 0) THEN