DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on PO_DISTRIBUTIONS_ALL

Line 698: po_distributions_all pod

694:
695: select pod.quantity_ordered * (poll.price_override) + nvl(pod.nonrecoverable_tax,0)
696: into l_total_dist_amount
697: from po_line_locations_all poll,
698: po_distributions_all pod
699: where poll.po_header_id =pod.po_header_id
700: and poll.line_location_id =pod.line_location_id
701: and pod.po_distribution_id =l_loc_po_distribution_id;
702:

Line 6627: po_distributions_all pod

6623: SELECT POD.ussgl_transaction_code
6624: INTO l_ussgl_tc
6625: FROM mtl_material_transactions mmt,
6626: rcv_transactions rt,
6627: po_distributions_all pod
6628: WHERE mmt.transaction_id = i_txn_id
6629: AND mmt.rcv_transaction_id = rt.transaction_id
6630: AND pod.po_distribution_id = rt.po_distribution_id;
6631: END IF;