DBA Data[Home] [Help]

APPS.PO_AP_INVOICE_MATCH_GRP dependencies on PO_LINES_ALL

Line 308: FROM PO_LINES_ALL POL,

304: NVL2(POL.max_retainage_amount,
305: least(p_line_loc_match_amt_tbl(i) * (POL.retainage_rate/100),POL.max_retainage_amount - nvl(PO_LINES_INT.retained_amount,0)),
306: p_line_loc_match_amt_tbl(i) * (POL.retainage_rate/100)
307: )
308: FROM PO_LINES_ALL POL,
309: PO_LINE_LOCATIONS_ALL PLL,
310: ( select PLL1.po_line_id ,
311: SUM(PLL1.RETAINAGE_WITHHELD_AMOUNT) retained_amount
312: FROM PO_LINE_LOCATIONS_ALL PLL1