APPS.FV_AP_PREPAY_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 65: FROM po_line_locations_all ll

61: NVL(ll.amount,0)-nvl(ll.amount_cancelled,0),
62: (NVL(ll.quantity,0) - NVL(ll.quantity_cancelled,0))* ll.price_override) total_amount,
63: decode(matching_basis , 'AMOUNT' , NVL(ll.amount_financed,0) , NVL(ll.quantity_financed,0) * ll.price_override) billed_amount
64: INTO l_total_amount , l_billed_amount
65: FROM po_line_locations_all ll
66: WHERE ll.line_location_id = p_line_location_id;
67:
68:
69: /* ---------------------- commented out as part of PO-uptake -----------------------

Line 73: FROM po_line_locations_all ll,

69: /* ---------------------- commented out as part of PO-uptake -----------------------
70: SELECT (ll.quantity - ll.quantity_cancelled) * l.unit_price total_amount,
71: (ll.quantity_billed * l.unit_price) remain_amount
72: INTO l_total_amount , l_billed_amount
73: FROM po_line_locations_all ll,
74: po_lines_all l
75: WHERE ll.line_location_id = p_line_location_id
76: AND l.po_line_id = ll.po_line_id;
77: