APPS.PO_AUTOSOURCE_SV dependencies on PO_LINE_LOCATIONS_ALL

Line 1560: FROM po_line_locations_all poll

1556: AND ( ( poh.type_lookup_code = 'QUOTATION'
1557: AND poh.status_lookup_code = 'A'
1558: AND ( NOT EXISTS (
1559: SELECT 'no shipments exists'
1560: FROM po_line_locations_all poll
1561: WHERE poll.po_line_id = pol.po_line_id
1562: ) --Bug7384016 added this condition to include quotations without price breaks
1563:
1564: OR ( poh.approval_required_flag = 'N'

Line 1566: FROM po_line_locations_all poll

1562: ) --Bug7384016 added this condition to include quotations without price breaks
1563:
1564: OR ( poh.approval_required_flag = 'N'
1565: AND (EXISTS (SELECT 'valid'
1566: FROM po_line_locations_all poll
1567: WHERE poll.po_line_id = pol.po_line_id
1568: AND TRUNC (NVL (poll.end_date, x_sourcing_date)) >= --Bug6982267
1569: trunc(x_sourcing_date)
1570: )

Line 1578: po_line_locations_all poll --CTO changes FPH

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

Line 2568: FROM po_line_locations_all poll

2564: OR ( poh.type_lookup_code = 'QUOTATION'
2565: AND (poh.status_lookup_code = 'A')
2566: AND ( NOT EXISTS (
2567: SELECT 'no shipments exists'
2568: FROM po_line_locations_all poll
2569: WHERE poll.po_line_id = pol.po_line_id
2570: )--Bug7384016 added this condition to include quotations without price breaks
2571: OR (
2572: (poh.approval_required_flag = 'Y')

Line 2576: po_line_locations_all poll --CTO changes FPH

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

Line 2589: FROM po_line_locations_all poll

2585: OR (
2586: (poh.approval_required_flag = 'N')
2587: AND ( EXISTS (
2588: SELECT 'valid'
2589: FROM po_line_locations_all poll
2590: WHERE poll.po_line_id = pol.po_line_id
2591: AND TRUNC (NVL (poll.end_date, x_sourcing_date)) >=
2592: trunc(x_sourcing_date)
2593: ) --Bug6982267

Line 6125: l_discount po_line_locations_all.price_discount%TYPE;

6121: NVL (poh.global_agreement_flag, 'N') ASC,
6122: poh.creation_date DESC;
6123: --
6124:
6125: l_discount po_line_locations_all.price_discount%TYPE;
6126: l_rate_type po_headers_all.rate_type%TYPE;
6127: l_rate_date po_headers_all.rate_date%TYPE;
6128: l_rate po_headers_all.rate%TYPE;
6129: l_base_unit_price po_lines_all.base_unit_price%TYPE; --

Line 6135: l_price_break_id po_line_locations_all.line_location_id%TYPE;

6131: l_currency_price po_lines_all.unit_price%TYPE;
6132: l_currency_amount po_lines_all.unit_price%TYPE;
6133: l_base_amount po_lines_all.unit_price%TYPE;
6134: l_currency_code po_headers_all.currency_code%TYPE;
6135: l_price_break_id po_line_locations_all.line_location_id%TYPE;
6136: l_price_diff_src_id po_price_differentials.entity_id%TYPE;
6137: l_using_organization_id po_approved_supplier_list.using_organization_id%TYPE;
6138: l_entity_type po_price_differentials.entity_type%TYPE;
6139: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;