APPS.POS_WCAPPROVE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 3734: po_line_locations_all pll,

3730: rsl.material_stored_amount material_stored_amount,
3731: pll.matching_basis
3732: FROM
3733: --po_distributions_all pod,
3734: po_line_locations_all pll,
3735: po_lines_all pl,
3736: po_headers_all ph,
3737: rcv_shipment_lines rsl,
3738: rcv_shipment_headers rsh

Line 4985: l_amount po_line_locations_all.amount%type;

4981:
4982: FUNCTION GET_ORDERED_AMOUNT (p_wc_id IN NUMBER)
4983: RETURN number IS
4984: l_count number;
4985: l_amount po_line_locations_all.amount%type;
4986: begin
4987:
4988: select count(*)
4989: into l_count

Line 4990: from po_line_locations_all poll

4986: begin
4987:
4988: select count(*)
4989: into l_count
4990: from po_line_locations_all poll
4991: where poll.line_location_id = p_wc_id
4992: and nvl(poll.matching_basis,'QUANTITY')='AMOUNT';
4993:
4994:

Line 5001: from po_line_locations_all poll

4997: else
4998:
4999: select poll.amount
5000: into l_amount
5001: from po_line_locations_all poll
5002: where poll.line_location_id = p_wc_id
5003: and nvl(poll.matching_basis,'QUANTITY')='AMOUNT';
5004:
5005:

Line 5014: l_quantity po_line_locations_all.quantity%type;

5010:
5011: FUNCTION GET_ORDERED_QUANTITY (p_wc_id IN NUMBER)
5012: RETURN number IS
5013: l_count number;
5014: l_quantity po_line_locations_all.quantity%type;
5015: begin
5016:
5017: select count(*)
5018: into l_count

Line 5019: from po_line_locations_all poll

5015: begin
5016:
5017: select count(*)
5018: into l_count
5019: from po_line_locations_all poll
5020: where poll.line_location_id = p_wc_id
5021: and nvl(poll.matching_basis,'QUANTITY')='QUANTITY';
5022:
5023:

Line 5030: from po_line_locations_all poll

5026: else
5027:
5028: select poll.quantity
5029: into l_quantity
5030: from po_line_locations_all poll
5031: where poll.line_location_id = p_wc_id
5032: and nvl(poll.matching_basis,'QUANTITY')='QUANTITY';
5033:
5034: