APPS.PO_REQS_INQ_SV dependencies on PO_REQUISITION_LINES_ALL

Line 490: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;

486: RETURN NUMBER IS
487:
488: l_progress VARCHAR2(3) := NULL;
489: l_value_basis PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
490: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
491:
492: BEGIN
493:
494: l_progress := '010';

Line 506: po_requisition_lines_all prl --

502:
503: Select plt.order_type_lookup_code
504: Into l_value_basis
505: From po_line_types_b plt,
506: po_requisition_lines_all prl --
507: Where plt.line_type_id = prl.line_type_id
508: And prl.requisition_line_id = p_req_entity_id;
509:
510:

Line 521: po_requisition_lines_all prl, --

517:
518: Select plt.order_type_lookup_code
519: Into l_value_basis
520: From po_line_types_b plt,
521: po_requisition_lines_all prl, --
522: po_req_distributions_all prd --
523: Where plt.line_type_id = prl.line_type_id
524: And prl.requisition_line_id = prd.requisition_line_id
525: And prd.distribution_id = p_req_entity_id;

Line 540: From po_requisition_lines_all prl --

536: l_progress := '040';
537:
538: Select prl.amount
539: Into l_req_amount
540: From po_requisition_lines_all prl --
541: Where prl.requisition_line_id = p_req_entity_id;
542:
543: ELSE
544: -- Sql What : Gets the amount on the req distribution