APPS.CST_PERENDACCRUALS_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 1451: FROM po_distributions_all

1447: SELECT po_distribution_id,
1448: DECODE (p_service_flag,
1449: 1, amount_ordered - NVL(amount_cancelled, 0),
1450: quantity_ordered - NVL(quantity_cancelled, 0)) distribution_quantity
1451: FROM po_distributions_all
1452: WHERE line_location_id = x_accrual_rec.shipment_id;
1453:
1454: BEGIN
1455:

Line 2645: po_distributions_all pod

2641: FROM ap_invoice_distributions_all aida,
2642: ap_invoices_all aia,
2643: po_lines_all pol,
2644: po_line_locations_all poll,
2645: po_distributions_all pod
2646: WHERE aida.po_distribution_id = pod.po_distribution_id
2647: AND (p_rcv_txn_id IS NULL OR aida.rcv_transaction_id = p_rcv_txn_id)
2648: AND aida.line_type_lookup_code NOT IN ('IPV', 'ERV', 'PREPAY')
2649: AND aida.accounting_date <= p_end_date