APPS.POR_VIEW_REQS_PKG dependencies on PO_LINE_TYPES

Line 594: po_line_types plt

590:
591: CURSOR req_supplier_info (c_req_header_id NUMBER) IS
592: SELECT PRL.suggested_vendor_name, PRL.vendor_id
593: FROM PO_REQUISITION_LINES_ALL PRL,
594: po_line_types plt
595: where prl.requisition_header_id = c_req_header_id
596: and prl.source_type_code = 'VENDOR'
597: and prl.line_type_id = plt.line_type_id
598: and plt.outside_operation_flag = 'N';

Line 604: po_line_types plt

600:
601: CURSOR contractor_req_supplier_info (c_req_header_id NUMBER) IS
602: SELECT prl.suggested_vendor_name, prl.requisition_line_id
603: FROM PO_REQUISITION_LINES_ALL PRL,
604: po_line_types plt
605: where prl.requisition_header_id = c_req_header_id
606: and prl.source_type_code = 'VENDOR'
607: and prl.line_type_id = plt.line_type_id
608: and plt.outside_operation_flag = 'N'