DBA Data[Home] [Help]

APPS.PO_VALIDATION_HELPER dependencies on PO_NOTIFICATION_CONTROLS

Line 9: -- PO_NOTIFICATION_CONTROLS.notification_control_code

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';

Line 1626: FROM PO_NOTIFICATION_CONTROLS NTF

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: )