APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 3439: -- PO_DISTRIBUTIONS_ALL.invoice_adjustment_flag.

3435: --Name: Retro_Invoice_Release
3436: --Pre-reqs:
3437: -- None.
3438: --Modifies:
3439: -- PO_DISTRIBUTIONS_ALL.invoice_adjustment_flag.
3440: --Locks:
3441: -- None.
3442: --Function:
3443: -- This procedure updates invoice adjustment flag, and calls Costing

Line 3594: po_distributions_all pod, --

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, --
3594: po_distributions_all pod, --
3595: -- Bug 3314204, 3303148
3596: po_distributions_archive_all poda --
3597: WHERE pol.po_header_id = p_po_header_id
3598: AND pol.po_header_id = poh.po_header_id

Line 3662: po_distributions_all pod, --

3658: -- Bug 3393219, Consumption transaction owning org
3659: -- financials_system_parameters fsp,
3660: po_line_locations_all poll, --
3661: po_line_locations_archive_all polla, --
3662: po_distributions_all pod, --
3663: -- Bug 3314204, 3303148
3664: po_distributions_archive poda
3665: WHERE por.po_release_id = p_po_release_id
3666: AND por.po_release_id = poll.po_release_id

Line 3841: UPDATE po_distributions_all

3837: END IF; /* IF g_debug_stmt */
3838:
3839: l_progress := '080';
3840: FORALL i in 1..l_line_location_ids_tbl.COUNT
3841: UPDATE po_distributions_all
3842: SET invoice_adjustment_flag = 'R'
3843: WHERE line_location_id = l_line_location_ids_tbl(i)
3844: AND l_quantity_billeds_tbl(i) > 0;
3845:

Line 4462: PO_DISTRIBUTIONS_ALL pod

4458: INTO l_retro_proj_allowed
4459: FROM DUAL
4460: WHERE EXISTS (SELECT 'has project information'
4461: FROM PO_LINE_LOCATIONS_ALL pll,
4462: PO_DISTRIBUTIONS_ALL pod
4463: WHERE pll.po_line_id = p_po_line_id
4464: AND pod.line_location_id = pll.line_location_id
4465: AND ((NVL(pll.quantity_received,0) > 0 AND
4466: NVL(pll.accrue_on_receipt_flag,'N') = 'Y') OR

Line 4483: PO_DISTRIBUTIONS_ALL pod

4479: INTO l_retro_proj_allowed
4480: FROM DUAL
4481: WHERE EXISTS (SELECT 'has project information'
4482: FROM PO_LINE_LOCATIONS_ALL pll,
4483: PO_DISTRIBUTIONS_ALL pod
4484: WHERE pll.line_location_id = p_po_line_loc_id
4485: AND pod.line_location_id = pll.line_location_id
4486: AND ((NVL(pll.quantity_received,0) > 0 AND
4487: NVL(pll.accrue_on_receipt_flag,'N') = 'Y') OR