DBA Data[Home] [Help]

APPS.PO_REQS_INQ_SV dependencies on PO_LINE_TYPES_B

Line 489: l_value_basis PO_LINE_TYPES_B.order_type_lookup_code%TYPE;

485: p_req_entity_id IN NUMBER)
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:

Line 505: From po_line_types_b plt,

501: l_progress := '020';
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:

Line 520: From po_line_types_b plt,

516: l_progress := '030';
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