DBA Data[Home] [Help]

APPS.POS_WC_CREATE_UPDATE_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 822: --po_distributions_all pod,

818: rsl.requested_amount requested_amount,
819: rsl.material_stored_amount material_stored_amount,
820: pll.matching_basis
821: FROM
822: --po_distributions_all pod,
823: po_line_locations_all pll,
824: po_lines_all pl,
825: po_headers_all ph,
826: rcv_shipment_lines rsl,

Line 857: from po_distributions_all pod

853: pod.quantity_ordered,
854: pod.amount_ordered,
855: pod.destination_type_code destination_type_code,
856: pod.destination_type_code destination_context
857: from po_distributions_all pod
858: where pod.line_location_id = l_line_location_id;
859:
860: l_shipment_header_id NUMBER;
861: l_line_location_id NUMBER;

Line 959: FROM po_distributions_all pod

955:
956: -- getting the number of distributions associated at the current pay item level
957: SELECT Count(*)
958: INTO l_max_dist
959: FROM po_distributions_all pod
960: where pod.line_location_id = wcr_line_info.po_line_location_id;
961:
962: -- the following two attributes take care that the requested amount and material stored values get updated only for the
963: -- first distribution, and for the subsequent distributions they are entered as 0.