APPS.CST_PERENDACCRUALS_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 1470: FROM po_distributions_all

1466: SELECT po_distribution_id,
1467: DECODE (p_service_flag,
1468: 1, amount_ordered - NVL(amount_cancelled, 0),
1469: quantity_ordered - NVL(quantity_cancelled, 0)) distribution_quantity
1470: FROM po_distributions_all
1471: WHERE line_location_id = x_accrual_rec.shipment_id;
1472:
1473: BEGIN
1474:

Line 2760: po_distributions_all pod

2756: FROM ap_invoice_distributions_all aida,
2757: ap_invoices_all aia,
2758: po_lines_all pol,
2759: po_line_locations_all poll,
2760: po_distributions_all pod
2761: WHERE aida.po_distribution_id = pod.po_distribution_id
2762: AND (p_rcv_txn_id IS NULL OR aida.rcv_transaction_id = p_rcv_txn_id)
2763: AND aida.line_type_lookup_code NOT IN ('IPV', 'ERV', 'PREPAY','REC_TAX')
2764: AND aida.accounting_date <= p_end_date