eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_UDA_IMPORT_PKG dependencies on PO_LINES_DRAFT_ALL

Line 2356: --need to update Qunatity/amount in po_lines_draft_all table

2352: WHERE attribute_group_id = l_attr_group_id_tbl(i) and template_id = l_template_id_tbl(i) ;
2353:
2354: IF l_attribute_category = 'PRICING' THEN
2355: BEGIN
2356: --need to update Qunatity/amount in po_lines_draft_all table
2357:
2358: SELECT matching_basis,quantity
2359: INTO l_matching_basis,l_quant
2360: FROM po_lines_draft_all plda

Line 2360: FROM po_lines_draft_all plda

2356: --need to update Qunatity/amount in po_lines_draft_all table
2357:
2358: SELECT matching_basis,quantity
2359: INTO l_matching_basis,l_quant
2360: FROM po_lines_draft_all plda
2361: WHERE plda.draft_id = p_draft_id
2362: AND plda.po_line_id = l_po_lines_tbl(i);
2363:
2364: IF l_matching_basis = 'AMOUNT' THEN

Line 2365: UPDATE po_lines_draft_all plda

2361: WHERE plda.draft_id = p_draft_id
2362: AND plda.po_line_id = l_po_lines_tbl(i);
2363:
2364: IF l_matching_basis = 'AMOUNT' THEN
2365: UPDATE po_lines_draft_all plda
2366: SET (plda.CLM_UDA_PRICING_TOTAL , plda.amount) =
2367: (SELECT plaeb.N_EXT_ATTR20,(plaeb.N_EXT_ATTR20 + Nvl(plda.CLM_APPROVED_UNDEF_AMOUNT,0))-- + plu.undef_amount)
2368: FROM po_lines_all_ext_b plaeb
2369: WHERE plaeb.draft_id = Decode(l_draft_id_tbl(i),p_draft_id,p_draft_id,-1)

Line 2378: FROM po_lines_draft_all plda

2374:
2375: UPDATE po_line_locations_draft_all pllda
2376: SET pllda.amount =
2377: ( SELECT amount
2378: FROM po_lines_draft_all plda
2379: WHERE plda.draft_id = p_draft_id
2380: AND plda.po_line_id = l_po_lines_tbl(i)
2381: )
2382: WHERE pllda.draft_id = p_draft_id

Line 2394: FROM po_lines_draft_all plda

2390:
2391: UPDATE po_distributions_draft_all pdda
2392: SET pdda.amount_ordered =
2393: ( SELECT amount
2394: FROM po_lines_draft_all plda
2395: WHERE plda.draft_id = p_draft_id
2396: AND plda.po_line_id = l_po_lines_tbl(i)
2397: )
2398: WHERE pdda.draft_id = p_draft_id

Line 2408: UPDATE po_lines_draft_all plda

2404: AND pdda.amount_ordered = 1
2405: HAVING Count(*) = 1);
2406:
2407: ELSE
2408: UPDATE po_lines_draft_all plda
2409: SET (plda.CLM_UDA_PRICING_TOTAL,plda.quantity) =
2410: (SELECT plaeb.N_EXT_ATTR20,(plaeb.N_EXT_ATTR20 + Nvl(plda.CLM_APPROVED_UNDEF_AMOUNT,0))-- + plu.undef_amount)
2411: FROM po_lines_all_ext_b plaeb
2412: WHERE plaeb.draft_id = Decode(l_draft_id_tbl(i),p_draft_id,p_draft_id,-1)

Line 2421: FROM po_lines_draft_all plda

2417:
2418: UPDATE po_line_locations_draft_all pllda
2419: SET pllda.quantity =
2420: ( SELECT quantity
2421: FROM po_lines_draft_all plda
2422: WHERE plda.draft_id = p_draft_id
2423: AND plda.po_line_id = l_po_lines_tbl(i)
2424: )
2425: WHERE pllda.draft_id = p_draft_id

Line 2437: FROM po_lines_draft_all plda

2433:
2434: UPDATE po_distributions_draft_all pdda
2435: SET pdda.quantity_ordered =
2436: ( SELECT quantity
2437: FROM po_lines_draft_all plda
2438: WHERE plda.draft_id = p_draft_id
2439: AND plda.po_line_id = l_po_lines_tbl(i)
2440: )
2441: WHERE pdda.draft_id = p_draft_id