DBA Data[Home] [Help]

APPS.ITG_IP_LINES_ALL_ARU dependencies on STANDARD

Line 13: WHERE UPPER(type_lookup_code) IN ('STANDARD', 'PLANNED')

9:
10: CURSOR checkHeader IS
11: SELECT segment1
12: FROM po_headers_all
13: WHERE UPPER(type_lookup_code) IN ('STANDARD', 'PLANNED')
14: AND UPPER(authorization_status) = 'APPROVED'
15: AND UPPER(NVL(cancel_flag, 'N')) = 'N'
16: AND po_header_id = :new.po_header_id;
17: