DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_DISTRIBUTIONS_ALL

Line 239: PO_DISTRIBUTIONS_ALL POD

235: ELSE TO_CHAR(POD.quantity_billed)
236: END
237: )
238: FROM
239: PO_DISTRIBUTIONS_ALL POD
240: WHERE
241: POD.po_distribution_id = p_dist_id_tbl(i)
242: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --
243: -- Quantity is being reduced below the current transaction quantity:

Line 375: PO_DISTRIBUTIONS_ALL POD

371: ELSE TO_CHAR(POD.amount_billed)
372: END
373: )
374: FROM
375: PO_DISTRIBUTIONS_ALL POD
376: WHERE
377: POD.po_distribution_id = p_dist_id_tbl(i)
378: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --
379: -- Amount is being reduced below the current transaction amount:

Line 746: l_gl_enc_period_name PO_DISTRIBUTIONS_ALL.gl_encumbered_period_name %TYPE;

742: )
743: IS
744: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
745: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
746: l_gl_enc_period_name PO_DISTRIBUTIONS_ALL.gl_encumbered_period_name %TYPE;
747: l_results_count NUMBER;
748: BEGIN
749:
750: IF (x_results IS NULL) THEN