DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_DISTRIBUTIONS_MERGE_V

Line 1799: -- and the stored data(PO_DISTRIBUTIONS_MERGE_V.funded_value) into the temp table.

1795: --
1796: -- A view of the in-memory and stored data will be constructed
1797: -- as follows:
1798: -- 1. Gather the in-memory data(distribution_id,req_distribution_id,funded_value)
1799: -- and the stored data(PO_DISTRIBUTIONS_MERGE_V.funded_value) into the temp table.
1800: -- Valid Distributions are CLM-enabled, STANDARD type,
1801: -- having a Req reference, and when PO and Req Encumbrance is On
1802: -- 2. Compare the temp table data with Funds remaining on Req as follows:
1803: -- For each distinct Req being referred to by the Distributions, record error If

Line 1831: FROM po_distributions_merge_v

1827: Decode(Sign(Nvl(p_funded_value_tbl(i),0) - Nvl(p_enc_amount_tbl(i),0)), -1, 0,
1828: Nvl(p_funded_value_tbl(i),0) - Nvl(p_enc_amount_tbl(i), 0))),
1829: (SELECT Decode(Nvl(p_draft_id_tbl(i), -1), -1, funded_value,
1830: Decode(Sign(change_in_funded_value), -1, 0, change_in_funded_value))
1831: FROM po_distributions_merge_v
1832: WHERE po_distribution_id = p_dist_id_tbl(i)
1833: AND draft_id = Nvl(p_draft_id_tbl(i), -1))
1834: FROM dual
1835: WHERE p_req_dist_id_tbl(i) IS NOT NULL