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 1472: FROM PO_NOTIFICATION_CONTROLS NTF

1468: )
1469: )
1470: AND EXISTS
1471: ( SELECT NULL
1472: FROM PO_NOTIFICATION_CONTROLS NTF
1473: WHERE
1474: NTF.po_header_id = PO_LINE.po_header_id
1475: AND NTF.notification_condition_code <> c_EXPIRATION
1476: )