APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on PO_ENCUMBRANCE_GT_S

Line 1674: SET ENC.sequence_num = PO_ENCUMBRANCE_GT_S.nextval

1670: -- Fill in the sequence_num.
1671: -- Do this for prevent rows as well, for error reporting.
1672:
1673: UPDATE PO_ENCUMBRANCE_GT ENC
1674: SET ENC.sequence_num = PO_ENCUMBRANCE_GT_S.nextval
1675: WHERE ENC.sequence_num IS NULL
1676: ;
1677:
1678: l_progress := '190';

Line 2236: , PO_ENCUMBRANCE_GT SR_DIST

2232: , x_origin_seq_num_tbl
2233: FROM
2234: PO_DISTRIBUTIONS_ALL POD
2235: , PO_LINE_LOCATIONS_ALL POLL
2236: , PO_ENCUMBRANCE_GT SR_DIST
2237: WHERE POLL.line_location_id = POD.line_location_id --JOIN
2238: AND POD.po_distribution_id = SR_DIST.source_distribution_id --JOIN
2239: AND NVL(POD.prevent_encumbrance_flag,'N') = 'N'
2240: AND NVL(POLL.closed_code,g_clsd_OPEN) <> g_clsd_FINALLY_CLOSED

Line 5975: FROM PO_ENCUMBRANCE_GT SR_DISTS

5971:
5972: UPDATE PO_ENCUMBRANCE_GT PPO_DISTS
5973: SET PPO_DISTS.qty_open =
5974: (SELECT SR_DISTS.qty_ordered - SR_DISTS.qty_closed
5975: FROM PO_ENCUMBRANCE_GT SR_DISTS
5976: WHERE SR_DISTS.sequence_num = PPO_DISTS.origin_sequence_num
5977: )
5978: WHERE PPO_DISTS.origin_sequence_num IS NOT NULL
5979: AND PPO_DISTS.prevent_encumbrance_flag = 'N'

Line 6009: FROM PO_ENCUMBRANCE_GT SR_DISTS

6005:
6006: --put entire cancelled qty on PPO
6007: , p_ap_cancelled_qty
6008: )
6009: FROM PO_ENCUMBRANCE_GT SR_DISTS
6010: WHERE PPO_DISTS.origin_sequence_num = SR_DISTS.sequence_num
6011: )
6012: WHERE PPO_DISTS.origin_sequence_num IS NOT NULL
6013: AND PPO_DISTS.prevent_encumbrance_flag = 'N'