eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_DIAGNOSTICS_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 16: FROM po_distributions_all pod,

12: BEGIN
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

Line 44: FROM po_distributions_all pod,

40: BEGIN
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