APPS.PO_AUTOSOURCE_SV dependencies on PO_LINE_LOCATIONS_ALL

Line 1551: FROM po_line_locations_all poll

1547: AND ( ( poh.type_lookup_code = 'QUOTATION'
1548: AND poh.status_lookup_code = 'A'
1549: AND ( NOT EXISTS (
1550: SELECT 'no shipments exists'
1551: FROM po_line_locations_all poll
1552: WHERE poll.po_line_id = pol.po_line_id
1553: ) --Bug7384016 added this condition to include quotations without price breaks
1554:
1555: OR ( poh.approval_required_flag = 'N'

Line 1557: FROM po_line_locations_all poll

1553: ) --Bug7384016 added this condition to include quotations without price breaks
1554:
1555: OR ( poh.approval_required_flag = 'N'
1556: AND (EXISTS (SELECT 'valid'
1557: FROM po_line_locations_all poll
1558: WHERE poll.po_line_id = pol.po_line_id
1559: AND TRUNC (NVL (poll.end_date, x_sourcing_date)) >= --Bug6982267
1560: trunc(x_sourcing_date)
1561: )

Line 1569: po_line_locations_all poll --CTO changes FPH

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
1573: AND TRUNC (NVL (poll.end_date, x_sourcing_date)) >= --Bug6982267

Line 2549: FROM po_line_locations_all poll

2545: OR ( poh.type_lookup_code = 'QUOTATION'
2546: AND (poh.status_lookup_code = 'A')
2547: AND ( NOT EXISTS (
2548: SELECT 'no shipments exists'
2549: FROM po_line_locations_all poll
2550: WHERE poll.po_line_id = pol.po_line_id
2551: )--Bug7384016 added this condition to include quotations without price breaks
2552: OR (
2553: (poh.approval_required_flag = 'Y')

Line 2557: po_line_locations_all poll --CTO changes FPH

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
2561: AND TRUNC (NVL (poll.end_date, x_sourcing_date)) >=

Line 2570: FROM po_line_locations_all poll

2566: OR (
2567: (poh.approval_required_flag = 'N')
2568: AND ( EXISTS (
2569: SELECT 'valid'
2570: FROM po_line_locations_all poll
2571: WHERE poll.po_line_id = pol.po_line_id
2572: AND TRUNC (NVL (poll.end_date, x_sourcing_date)) >=
2573: trunc(x_sourcing_date)
2574: ) --Bug6982267

Line 6048: l_discount po_line_locations_all.price_discount%TYPE;

6044: NVL (poh.global_agreement_flag, 'N') ASC,
6045: poh.creation_date DESC;
6046: --
6047:
6048: l_discount po_line_locations_all.price_discount%TYPE;
6049: l_rate_type po_headers_all.rate_type%TYPE;
6050: l_rate_date po_headers_all.rate_date%TYPE;
6051: l_rate po_headers_all.rate%TYPE;
6052: l_base_unit_price po_lines_all.base_unit_price%TYPE; --

Line 6058: l_price_break_id po_line_locations_all.line_location_id%TYPE;

6054: l_currency_price po_lines_all.unit_price%TYPE;
6055: l_currency_amount po_lines_all.unit_price%TYPE;
6056: l_base_amount po_lines_all.unit_price%TYPE;
6057: l_currency_code po_headers_all.currency_code%TYPE;
6058: l_price_break_id po_line_locations_all.line_location_id%TYPE;
6059: l_price_diff_src_id po_price_differentials.entity_id%TYPE;
6060: l_using_organization_id po_approved_supplier_list.using_organization_id%TYPE;
6061: l_entity_type po_price_differentials.entity_type%TYPE;
6062: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;