APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 3318: -- PO_DISTRIBUTIONS_ALL.invoice_adjustment_flag.

3314: --Name: Retro_Invoice_Release
3315: --Pre-reqs:
3316: -- None.
3317: --Modifies:
3318: -- PO_DISTRIBUTIONS_ALL.invoice_adjustment_flag.
3319: --Locks:
3320: -- None.
3321: --Function:
3322: -- This procedure updates invoice adjustment flag, and calls Costing

Line 3473: po_distributions_all pod, --

3469: -- Bug 3393219, Consumption transaction owning org
3470: -- financials_system_parameters fsp,
3471: po_line_locations_all poll, --
3472: po_line_locations_archive_all polla, --
3473: po_distributions_all pod, --
3474: -- Bug 3314204, 3303148
3475: po_distributions_archive_all poda --
3476: WHERE pol.po_header_id = p_po_header_id
3477: AND pol.po_header_id = poh.po_header_id

Line 3541: po_distributions_all pod, --

3537: -- Bug 3393219, Consumption transaction owning org
3538: -- financials_system_parameters fsp,
3539: po_line_locations_all poll, --
3540: po_line_locations_archive_all polla, --
3541: po_distributions_all pod, --
3542: -- Bug 3314204, 3303148
3543: po_distributions_archive poda
3544: WHERE por.po_release_id = p_po_release_id
3545: AND por.po_release_id = poll.po_release_id

Line 3720: UPDATE po_distributions_all

3716: END IF; /* IF g_debug_stmt */
3717:
3718: l_progress := '080';
3719: FORALL i in 1..l_line_location_ids_tbl.COUNT
3720: UPDATE po_distributions_all
3721: SET invoice_adjustment_flag = 'R'
3722: WHERE line_location_id = l_line_location_ids_tbl(i)
3723: AND l_quantity_billeds_tbl(i) > 0;
3724:

Line 4341: PO_DISTRIBUTIONS_ALL pod

4337: INTO l_retro_proj_allowed
4338: FROM DUAL
4339: WHERE EXISTS (SELECT 'has project information'
4340: FROM PO_LINE_LOCATIONS_ALL pll,
4341: PO_DISTRIBUTIONS_ALL pod
4342: WHERE pll.po_line_id = p_po_line_id
4343: AND pod.line_location_id = pll.line_location_id
4344: AND ((NVL(pll.quantity_received,0) > 0 AND
4345: NVL(pll.accrue_on_receipt_flag,'N') = 'Y') OR

Line 4362: PO_DISTRIBUTIONS_ALL pod

4358: INTO l_retro_proj_allowed
4359: FROM DUAL
4360: WHERE EXISTS (SELECT 'has project information'
4361: FROM PO_LINE_LOCATIONS_ALL pll,
4362: PO_DISTRIBUTIONS_ALL pod
4363: WHERE pll.line_location_id = p_po_line_loc_id
4364: AND pod.line_location_id = pll.line_location_id
4365: AND ((NVL(pll.quantity_received,0) > 0 AND
4366: NVL(pll.accrue_on_receipt_flag,'N') = 'Y') OR