DBA Data[Home] [Help]

APPS.AP_PPA_PKG dependencies on RCV_SHIPMENT_LINES

Line 588: FROM ap_invoices i, rcv_transactions rt, rcv_shipment_lines rsl,

584: to_date(nvl(rt.transaction_date,
585: nvl(i.goods_received_date +
586: nvl(p_receipt_acc_days,0),p_inv_date))))))
587: INTO p_start_date
588: FROM ap_invoices i, rcv_transactions rt, rcv_shipment_lines rsl,
589: ap_invoice_distributions ad, po_distributions_ap_v d
590: WHERE i.invoice_id = p_invoice_id
591: AND i.invoice_id = ad.invoice_id(+)
592: AND ad.po_distribution_id = d.po_distribution_id

Line 608: FROM rcv_transactions rt, rcv_shipment_lines rsl,

604:
605: Begin
606: SELECT MIN(rt.transaction_date)
607: INTO l_transaction_date
608: FROM rcv_transactions rt, rcv_shipment_lines rsl,
609: ap_invoice_distributions ad, po_distributions d
610: WHERE ad.invoice_id = p_invoice_id
611: AND ad.po_distribution_id = d.po_distribution_id
612: AND d.po_header_id = rsl.po_header_id