APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on PO_ENCUMBRANCE_GT_S

Line 1636: SET ENC.sequence_num = PO_ENCUMBRANCE_GT_S.nextval

1632: -- Fill in the sequence_num.
1633: -- Do this for prevent rows as well, for error reporting.
1634:
1635: UPDATE PO_ENCUMBRANCE_GT ENC
1636: SET ENC.sequence_num = PO_ENCUMBRANCE_GT_S.nextval
1637: WHERE ENC.sequence_num IS NULL
1638: ;
1639:
1640: l_progress := '190';

Line 2198: , PO_ENCUMBRANCE_GT SR_DIST

2194: , x_origin_seq_num_tbl
2195: FROM
2196: PO_DISTRIBUTIONS_ALL POD
2197: , PO_LINE_LOCATIONS_ALL POLL
2198: , PO_ENCUMBRANCE_GT SR_DIST
2199: WHERE POLL.line_location_id = POD.line_location_id --JOIN
2200: AND POD.po_distribution_id = SR_DIST.source_distribution_id --JOIN
2201: AND NVL(POD.prevent_encumbrance_flag,'N') = 'N'
2202: AND NVL(POLL.closed_code,g_clsd_OPEN) <> g_clsd_FINALLY_CLOSED

Line 5740: FROM PO_ENCUMBRANCE_GT SR_DISTS

5736:
5737: UPDATE PO_ENCUMBRANCE_GT PPO_DISTS
5738: SET PPO_DISTS.qty_open =
5739: (SELECT SR_DISTS.qty_ordered - SR_DISTS.qty_closed
5740: FROM PO_ENCUMBRANCE_GT SR_DISTS
5741: WHERE SR_DISTS.sequence_num = PPO_DISTS.origin_sequence_num
5742: )
5743: WHERE PPO_DISTS.origin_sequence_num IS NOT NULL
5744: AND PPO_DISTS.prevent_encumbrance_flag = 'N'

Line 5774: FROM PO_ENCUMBRANCE_GT SR_DISTS

5770:
5771: --put entire cancelled qty on PPO
5772: , p_ap_cancelled_qty
5773: )
5774: FROM PO_ENCUMBRANCE_GT SR_DISTS
5775: WHERE PPO_DISTS.origin_sequence_num = SR_DISTS.sequence_num
5776: )
5777: WHERE PPO_DISTS.origin_sequence_num IS NOT NULL
5778: AND PPO_DISTS.prevent_encumbrance_flag = 'N'