5: c_RATE CONSTANT VARCHAR2(30) := 'RATE';
6: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
7: c_NEW CONSTANT VARCHAR2(30) := 'NEW';
8:
9: -- PO_NOTIFICATION_CONTROLS.notification_control_code
10: c_EXPIRATION CONSTANT VARCHAR2(30) := 'EXPIRATION';
11:
12: -- Constants for column names.
13: c_DISTRIBUTION_NUM CONSTANT VARCHAR2(30) := 'DISTRIBUTION_NUM';
1622: )
1623: )
1624: AND EXISTS
1625: ( SELECT NULL
1626: FROM PO_NOTIFICATION_CONTROLS NTF
1627: WHERE
1628: NTF.po_header_id = PO_LINE.po_header_id
1629: AND NTF.notification_condition_code <> c_EXPIRATION
1630: )