APPS.POS_EXCELASN_PVT dependencies on PO_LOOKUP_CODES

Line 1542: (select 1 from po_lookup_codes plc

1538: select pht.line_number, pht.freight_terms
1539: from pos_exasn_headers pht
1540: where pht.freight_terms is not null
1541: and not exists
1542: (select 1 from po_lookup_codes plc
1543: where plc.lookup_type = 'FREIGHT TERMS'and sysdate < nvl(plc.inactive_date, sysdate + 1)
1544: and plc.lookup_code = pht.freight_terms);
1545:
1546: --H7: SHIPMENT DATE has to be < SYSDATE