APPS.POS_EXCELASN_PVT dependencies on PO_LOOKUP_CODES

Line 1472: (select 1 from po_lookup_codes plc

1468: select pht.line_number, pht.freight_terms
1469: from pos_exasn_headers pht
1470: where pht.freight_terms is not null
1471: and not exists
1472: (select 1 from po_lookup_codes plc
1473: where plc.lookup_type = 'FREIGHT TERMS'and sysdate < nvl(plc.inactive_date, sysdate + 1)
1474: and plc.lookup_code = pht.freight_terms);
1475:
1476: --H7: SHIPMENT DATE has to be < SYSDATE