DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on PO_DISTRIBUTIONS_ALL

Line 787: po_distributions_all pod

783:
784: select pod.quantity_ordered * (poll.price_override) + nvl(pod.nonrecoverable_tax,0)
785: into l_total_dist_amount
786: from po_line_locations_all poll,
787: po_distributions_all pod
788: where poll.po_header_id =pod.po_header_id
789: and poll.line_location_id =pod.line_location_id
790: and pod.po_distribution_id =l_loc_po_distribution_id;
791:

Line 6748: po_distributions_all pod,

6744: SELECT POD.ussgl_transaction_code, nvl(pod.rate,1), pod.rate_date, poh.rate_type
6745: INTO l_ussgl_tc, l_conv_rate, l_conv_date, l_conv_type
6746: FROM mtl_material_transactions mmt,
6747: rcv_transactions rt,
6748: po_distributions_all pod,
6749: po_headers_all poh
6750: WHERE mmt.transaction_id = i_txn_id
6751: AND mmt.rcv_transaction_id = rt.transaction_id
6752: AND pod.po_distribution_id = rt.po_distribution_id