DBA Data[Home] [Help]

APPS.CST_DIAGNOSTICS_PKG dependencies on PO_HEADERS_ALL

Line 46: po_headers_all poh

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 (
50: (RCT.PO_DISTRIBUTION_ID IS NOT NULL