DBA Data[Home] [Help]

APPS.PO_PRICE_BREAK_GRP dependencies on PO_QUOTATION_APPROVALS

Line 299: FROM po_quotation_approvals pqa

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