DBA Data[Home] [Help]

APPS.PO_AUTOSOURCE_SV dependencies on PO_QUOTATION_APPROVALS

Line 1577: FROM po_quotation_approvals poqa,

1573: --Bug7384016 segregated the coditions for approval_required_flag = Y/N
1574: OR (poh.approval_required_flag = 'Y'
1575: AND ( EXISTS (
1576: SELECT 'quote is approved'
1577: FROM po_quotation_approvals poqa,
1578: po_line_locations_all poll --CTO changes FPH
1579: WHERE poqa.approval_type IS NOT NULL
1580: AND poqa.line_location_id = poll.line_location_id
1581: AND poll.po_line_id = pol.po_line_id

Line 2575: FROM po_quotation_approvals poqa,

2571: OR (
2572: (poh.approval_required_flag = 'Y')
2573: AND ( EXISTS (
2574: SELECT *
2575: FROM po_quotation_approvals poqa,
2576: po_line_locations_all poll --CTO changes FPH
2577: WHERE poqa.approval_type IS NOT NULL
2578: AND poqa.line_location_id = poll.line_location_id
2579: AND poll.po_line_id = pol.po_line_id