APPS.PO_ASL_API_PUB dependencies on PO_QUOTATION_APPROVALS

Line 2676: FROM po_quotation_approvals poqa,

2672: OR ( poh.type_lookup_code = 'QUOTATION'
2673: AND ( poh.status_lookup_code = 'A' )
2674: AND ( poh.approval_required_flag = 'Y' )
2675: AND ( EXISTS (SELECT 'x'
2676: FROM po_quotation_approvals poqa,
2677: po_line_locations_all poll,
2678: po_lines_all pol
2679: WHERE poqa.approval_type IS NOT NULL
2680: AND poqa.line_location_id =

Line 2778: FROM po_quotation_approvals poqa,

2774: OR ( poh.type_lookup_code = 'QUOTATION'
2775: AND ( poh.status_lookup_code = 'A' )
2776: AND ( poh.approval_required_flag = 'Y' )
2777: AND ( EXISTS (SELECT 'x'
2778: FROM po_quotation_approvals poqa,
2779: po_line_locations_all poll,
2780: po_lines_all pol
2781: WHERE poqa.approval_type IS NOT NULL
2782: AND poqa.line_location_id =

Line 2932: FROM po_quotation_approvals poqa,

2928: AND ( ( poh.type_lookup_code = 'BLANKET' )
2929: OR ( poh.type_lookup_code = 'QUOTATION'
2930: AND ( poh.approval_required_flag = 'Y' )
2931: AND ( EXISTS (SELECT 1
2932: FROM po_quotation_approvals poqa,
2933: po_line_locations_all poll
2934: WHERE poqa.approval_type IS NOT NULL
2935: AND poqa.line_location_id =
2936: poll.line_location_id

Line 2985: FROM po_quotation_approvals poqa,

2981: AND ( ( poh.type_lookup_code = 'BLANKET' )
2982: OR ( poh.type_lookup_code = 'QUOTATION'
2983: AND ( poh.approval_required_flag = 'Y' )
2984: AND ( EXISTS (SELECT *
2985: FROM po_quotation_approvals poqa,
2986: po_line_locations_all poll
2987: WHERE poqa.approval_type IS NOT NULL
2988: AND poqa.line_location_id =
2989: poll.line_location_id