DBA Data[Home] [Help]

APPS.AP_PPA_PKG dependencies on RCV_TRANSACTIONS

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

559: to_date(nvl(rt.transaction_date,
560: nvl(i.goods_received_date +
561: nvl(p_receipt_acc_days,0),p_inv_date))))))
562: INTO p_start_date
563: FROM ap_invoices i, rcv_transactions rt, rcv_shipment_lines rsl,
564: ap_invoice_distributions ad, po_distributions_ap_v d
565: WHERE i.invoice_id = p_invoice_id
566: AND i.invoice_id = ad.invoice_id(+)
567: AND ad.po_distribution_id = d.po_distribution_id

Line 583: FROM rcv_transactions rt, rcv_shipment_lines rsl,

579:
580: Begin
581: SELECT MIN(rt.transaction_date)
582: INTO l_transaction_date
583: FROM rcv_transactions rt, rcv_shipment_lines rsl,
584: ap_invoice_distributions ad, po_distributions d
585: WHERE ad.invoice_id = p_invoice_id
586: AND ad.po_distribution_id = d.po_distribution_id
587: AND d.po_header_id = rsl.po_header_id