DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_DISTRIBUTIONS_ALL

Line 296: PO_DISTRIBUTIONS_ALL POD

292: ELSE TO_CHAR(POD.quantity_billed)
293: END
294: )
295: FROM
296: PO_DISTRIBUTIONS_ALL POD
297: WHERE
298: POD.po_distribution_id = p_dist_id_tbl(i)
299: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --
300: -- Quantity is being reduced below the current transaction quantity:

Line 448: PO_DISTRIBUTIONS_ALL POD

444: ELSE TO_CHAR(POD.amount_billed)
445: END
446: )
447: FROM
448: PO_DISTRIBUTIONS_ALL POD
449: WHERE
450: POD.po_distribution_id = p_dist_id_tbl(i)
451: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --
452: -- Amount is being reduced below the current transaction amount:

Line 821: l_gl_enc_period_name PO_DISTRIBUTIONS_ALL.gl_encumbered_period_name %TYPE;

817: )
818: IS
819: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
820: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
821: l_gl_enc_period_name PO_DISTRIBUTIONS_ALL.gl_encumbered_period_name %TYPE;
822: l_results_count NUMBER;
823: l_gl_encumbered_date DATE;
824: BEGIN
825: