DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on PO_LINE_TYPES

Line 672: po_line_types plt

668:
669: CURSOR req_supplier_info (c_req_header_id NUMBER) IS
670: SELECT PRL.suggested_vendor_name, PRL.vendor_id
671: FROM PO_REQUISITION_LINES_ALL PRL,
672: po_line_types plt
673: where prl.requisition_header_id = c_req_header_id
674: and prl.source_type_code = 'VENDOR'
675: and prl.line_type_id = plt.line_type_id
676: and plt.outside_operation_flag = 'N';

Line 682: po_line_types plt

678:
679: CURSOR contractor_req_supplier_info (c_req_header_id NUMBER) IS
680: SELECT prl.suggested_vendor_name, prl.requisition_line_id
681: FROM PO_REQUISITION_LINES_ALL PRL,
682: po_line_types plt
683: where prl.requisition_header_id = c_req_header_id
684: and prl.source_type_code = 'VENDOR'
685: and prl.line_type_id = plt.line_type_id
686: and plt.outside_operation_flag = 'N'