DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_LINES_ALL

Line 250: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,

246: poll.price_override, nvl(poll.need_by_date,sysdate),
247: poh.po_header_id,
248: poh.authorization_status, poh.revision_num,
249: poha.revision_num
250: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
251: po_headers_archive_all poha,financials_system_params_all fsp
252: where pol.from_line_id = l_po_line_id
253: and poh.po_header_id = pol.po_header_id
254: and poh.org_id = fsp.org_id -- -- Bug 3573266

Line 359: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,

355: poll.price_override, nvl(poll.need_by_date,sysdate),
356: poh.po_header_id,
357: poh.authorization_status, poh.revision_num,
358: poha.revision_num
359: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
360: po_headers_archive_all poha, po_document_types_all_b pdt,
361: financials_system_params_all fsp
362: where pol.from_line_id = l_po_line_id
363: and poh.po_header_id = pol.po_header_id

Line 432: po_lines_all pol,

428: poh.authorization_status,
429: poh.revision_num,
430: poha.revision_num
431: FROM po_headers_all poh,
432: po_lines_all pol,
433: po_line_locations_all poll,
434: po_headers_archive_all poha,
435: financials_system_params_all fsp
436: WHERE pol.Contract_id = l_po_header_id

Line 496: po_lines_all pol,

492: poh.authorization_status,
493: poh.revision_num,
494: poha.revision_num
495: FROM po_headers_all poh,
496: po_lines_all pol,
497: po_line_locations_all poll,
498: po_headers_archive_all poha,
499: po_document_types_all_b pdt,
500: financials_system_params_all fsp

Line 585: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;

581:
582: l_agreement_cur g_agreement_cur_type;
583:
584:
585: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;
586: l_retroactive_date PO_LINES_ALL.retroactive_date%TYPE;
587: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
588:
589:

Line 586: l_retroactive_date PO_LINES_ALL.retroactive_date%TYPE;

582: l_agreement_cur g_agreement_cur_type;
583:
584:
585: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;
586: l_retroactive_date PO_LINES_ALL.retroactive_date%TYPE;
587: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
588:
589:
590:

Line 820: '(select ''has stdpo'' from po_lines_all pl where '||

816: '((nvl(poh.global_agreement_flag,''N'') = ''Y'') '||
817: ' and ' ||
818: ' (:l_ga_security = ''Y'') '||
819: ' and exists '||
820: '(select ''has stdpo'' from po_lines_all pl where '||
821: ' pl.from_line_id = pol.po_line_id))) ' ;
822: --
823: l_sql_str9 := ' UNION ALL '||
824: 'select poh.po_header_id,NULL, ' ||

Line 836: ' ( SELECT ''has stdpo'' FROM po_lines_all pl '||

832: 'and nvl(poh.authorization_status,''INCOMPLETE'') = ''APPROVED'' ' ||
833: 'and nvl(poh.frozen_flag, ''N'') = ''N'' ' ||
834: 'and nvl(poh.consigned_consumption_flag,''N'') =''N'' '||
835: 'and exists ' ||
836: ' ( SELECT ''has stdpo'' FROM po_lines_all pl '||
837: ' WHERE pl.contract_id = poh.po_header_id ) ';
838: --
839:
840:

Line 1688: UPDATE po_lines_all

1684:
1685: l_module := g_log_head||l_api_name||'.'||'110'||'.';
1686: if l_temp_row_id_table.COUNT <> 0 then
1687: FORALL price_update_index in 1..l_temp_row_id_table.COUNT
1688: UPDATE po_lines_all
1689: SET unit_price = l_temp_new_price_table(price_update_index),
1690: base_unit_price = NVL(l_temp_new_base_price_table(price_update_index)
1691: ,base_unit_price), --Enhanced Pricing
1692: manual_price_change_flag = 'N', --

Line 1713: from po_lines_all pll where

1709: NVL(tax_attribute_update_code,'UPDATE')
1710: --
1711: WHERE poll.po_line_id =
1712: (select pll.po_line_id
1713: from po_lines_all pll where
1714: rowid=l_temp_row_id_table(price_update_index));
1715:
1716: end if; /*l_temp_row_id_table.COUNT <> 0 */
1717: exit when update_line_price%notfound;

Line 2206: from po_lines_all pll where

2202: poll.last_update_date = g_sysdate,
2203: poll.last_updated_by = g_user_id
2204: WHERE poll.po_line_id =
2205: (select pll.po_line_id
2206: from po_lines_all pll where
2207: rowid=l_row_id_table(ship_update_index));
2208:
2209: exception
2210: when l_tax_failure then

Line 2267: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;

2263: l_api_name CONSTANT VARCHAR2(50) := 'Process_Price_Change';
2264: l_error_message varchar2(2000);
2265: l_std_po_price_change VARCHAR2(1);
2266: l_retroactive_update VARCHAR2(30) := 'NEVER';
2267: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
2268: l_enhanced_pricing_flag VARCHAR2(1); --Enhanced Pricing
2269:
2270: --
2271: l_quantity PO_LINES.quantity%TYPE;

Line 2462: FROM po_line_locations_all PLL, po_lines_all POL,

2458: l_vendor_site_id,
2459: l_uom,
2460: l_in_unit_price,
2461: l_currency_code
2462: FROM po_line_locations_all PLL, po_lines_all POL,
2463: po_headers_all POH
2464: WHERE PLL.line_location_id = p_po_line_location_id
2465: AND POL.po_line_id = PLL.po_line_id
2466: AND POH.po_header_id = POL.po_header_id;

Line 2570: PO_LINES_ALL LIN

2566: SELECT DISTINCT STL.enhanced_pricing_flag
2567: INTO l_enhanced_pricing_flag
2568: FROM PO_DOC_STYLE_HEADERS STL,
2569: PO_HEADERS_ALL HDR,
2570: PO_LINES_ALL LIN
2571: WHERE LIN.po_line_id = l_po_line_id
2572: AND LIN.po_header_id = HDR.po_header_id
2573: AND HDR.style_id = STL.style_id;
2574: EXCEPTION

Line 3382: UPDATE po_lines_all

3378: -- SQL What: Reset retroactive_date for this PO
3379: -- SQL Why : For Standard PO, column po_lines.retroactive_date will
3380: -- be updated if any retroactive pricing changes. Reset it
3381: -- to NULL after processing retroactive pricing.
3382: UPDATE po_lines_all
3383: SET retroactive_date = NULL,
3384: last_update_date = SYSDATE,
3385: last_updated_by = l_user_id
3386: WHERE po_header_id = p_document_id;

Line 3409: FROM po_lines_all pl

3405: -- to the corresponding blanket line retroactive_date after
3406: -- processing retroactive pricing.
3407: UPDATE po_line_locations_all pll
3408: SET retroactive_date = (SELECT pl.retroactive_date
3409: FROM po_lines_all pl
3410: WHERE pl.po_line_id = pll.po_line_id),
3411: last_update_date = SYSDATE,
3412: last_updated_by = l_user_id
3413: WHERE pll.po_release_id = p_document_id;

Line 3589: po_lines_all pol, --

3585: pod.project_id,
3586: pod.task_id,
3587: pod.accrual_account_id distribute_account_id
3588: FROM po_headers poh,
3589: po_lines_all pol, --
3590: -- Bug 3393219, Consumption transaction owning org
3591: -- financials_system_parameters fsp,
3592: po_line_locations_all poll, --
3593: po_line_locations_archive_all polla, --