DBA Data[Home] [Help]

APPS.AP_FUNDS_CONTROL_PKG dependencies on PO_LINE_LOCATIONS

Line 2143: po_line_locations poll

2139: NVL(d1.quantity_invoiced,0)
2140: ) quantity_invoiced
2141: FROM ap_invoice_distributions_all d1) qty,
2142: po_distributions pd,
2143: po_line_locations poll
2144: where pd.po_distribution_id = d.po_distribution_id
2145: and d.po_distribution_id = p_po_dist_id
2146: and d.line_type_lookup_code NOT IN ('NONREC_TAX','TRV','TIPV')
2147: and d.invoice_distribution_id = qty.invoice_distribution_id

Line 2465: po_line_locations poll

2461: l_new_base_amt_var,
2462: l_unapproved_amt
2463: from ap_invoice_distributions d,
2464: po_distributions pd,
2465: po_line_locations poll
2466: where pd.po_distribution_id = d.po_distribution_id
2467: and d.po_distribution_id = p_po_dist_id
2468: and poll.line_location_id = pd.line_location_id
2469: and d.line_type_lookup_code IN ('ITEM','ACCRUAL') --bugfix:3881673