DBA Data[Home] [Help]

APPS.PO_PRICE_BREAK_GRP dependencies on PO_QUOTATION_APPROVALS

Line 302: FROM po_quotation_approvals pqa

298: AND ( ( poll.shipment_type = 'PRICE BREAK' )
299: OR ( ( poll.shipment_type = 'QUOTATION' )
300: AND ( ( poh.approval_required_flag <> 'Y' )
301: OR ( EXISTS ( SELECT ('Price Break is Approved')
302: FROM po_quotation_approvals pqa
303: WHERE pqa.line_location_id = poll.line_location_id
304: AND pqa.approval_type IN ('ALL ORDERS', 'REQUISITIONS')
305: AND (start_date_active is null
306: OR trunc(nvl(l_pricing_date, sysdate)) >= start_date_active)