--采购订单审批状态(AUTHORIZATION_STATUS)
SELECT *
FROM PO_LOOKUP_CODES PLC
WHERE PLC.LOOKUP_TYPE = 'AUTHORIZATION STATUS';
--采购订单状态(CLOSED_CODE)
SELECT * FROM PO_LOOKUP_CODES PLC WHERE PLC.LOOKUP_TYPE = 'DOCUMENT STATE';
SELECT *
FROM PO_LOOKUP_CODES PLC
WHERE PLC.LOOKUP_TYPE = 'AUTHORIZATION STATUS';
--采购订单状态(CLOSED_CODE)
SELECT * FROM PO_LOOKUP_CODES PLC WHERE PLC.LOOKUP_TYPE = 'DOCUMENT STATE';