APPS.PO_UDA_IMPORT_PKG dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 2391: UPDATE po_distributions_draft_all pdda

2387: AND pllda.po_line_id = l_po_lines_tbl(i)
2388: AND pllda.amount = 1
2389: HAVING Count(*) = 1);
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

Line 2401: FROM po_distributions_draft_all pdda

2397: )
2398: WHERE pdda.draft_id = p_draft_id
2399: AND pdda.po_line_id = l_po_lines_tbl(i)
2400: AND EXISTS (SELECT 'there should be only one distribution with quantity equals to 1'
2401: FROM po_distributions_draft_all pdda
2402: WHERE pdda.draft_id = p_draft_id
2403: AND pdda.po_line_id = l_po_lines_tbl(i)
2404: AND pdda.amount_ordered = 1
2405: HAVING Count(*) = 1);

Line 2434: UPDATE po_distributions_draft_all pdda

2430: AND pllda.po_line_id = l_po_lines_tbl(i)
2431: AND pllda.quantity = 1
2432: HAVING Count(*) = 1);
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

Line 2444: FROM po_distributions_draft_all pdda

2440: )
2441: WHERE pdda.draft_id = p_draft_id
2442: AND pdda.po_line_id = l_po_lines_tbl(i)
2443: AND EXISTS (SELECT 'there should be only one distribution with quantity equlas to 1'
2444: FROM po_distributions_draft_all pdda
2445: WHERE pdda.draft_id = p_draft_id
2446: AND pdda.po_line_id = l_po_lines_tbl(i)
2447: AND pdda.quantity_ordered = 1
2448: HAVING Count(*) = 1);