APPS.CST_DIAGNOSTICS_PKG dependencies on RCV_TRANSACTIONS

Line 17: rcv_transactions rt9

13: SELECT nvl((SUM( nvl(pod.nonrecoverable_tax,0))
14: /SUM(pod.quantity_ordered)),0)
15: INTO l_tax
16: FROM po_distributions_all pod,
17: rcv_transactions rt9
18: WHERE RT9.TRANSACTION_ID = i_txn_id
19: AND (
20: ( RT9.PO_DISTRIBUTION_ID IS NOT NULL
21: AND RT9.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID )

Line 45: rcv_transactions rct,

41: SELECT
42: SUM(pod.quantity_ordered*nvl(pod.rate,1))/SUM(pod.quantity_ordered)
43: INTO l_rate
44: FROM po_distributions_all pod,
45: rcv_transactions rct,
46: po_headers_all poh
47: WHERE rct.transaction_id = i_txn_id
48: AND pod.po_header_id = poh.po_header_id
49: AND (