DBA Data[Home] [Help]

APPS.PO_AUTOSOURCE_SV dependencies on PO_QUOTATION_APPROVALS

Line 1568: FROM po_quotation_approvals poqa,

1564: --Bug7384016 segregated the coditions for approval_required_flag = Y/N
1565: OR (poh.approval_required_flag = 'Y'
1566: AND ( EXISTS (
1567: SELECT 'quote is approved'
1568: FROM po_quotation_approvals poqa,
1569: po_line_locations_all poll --CTO changes FPH
1570: WHERE poqa.approval_type IS NOT NULL
1571: AND poqa.line_location_id = poll.line_location_id
1572: AND poll.po_line_id = pol.po_line_id

Line 2556: FROM po_quotation_approvals poqa,

2552: OR (
2553: (poh.approval_required_flag = 'Y')
2554: AND ( EXISTS (
2555: SELECT *
2556: FROM po_quotation_approvals poqa,
2557: po_line_locations_all poll --CTO changes FPH
2558: WHERE poqa.approval_type IS NOT NULL
2559: AND poqa.line_location_id = poll.line_location_id
2560: AND poll.po_line_id = pol.po_line_id