4654: UPDATE PO_SESSION_GT
4655: SET num2 =
4656: (
4657: SELECT POD.po_line_id
4658: FROM PO_DISTRIBUTIONS_MERGE_V POD --
4660: AND POD.draft_id = p_draft_id
4661: )
4662: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
4923: UPDATE PO_SESSION_GT
4924: SET num2 =
4925: (
4926: SELECT POD.line_location_id
4927: FROM PO_DISTRIBUTIONS_MERGE_V POD --
4929: AND POD.draft_id = p_draft_id
4930: )
4931: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
5178:
5179: SELECT POD.po_distribution_id
5180: BULK COLLECT INTO x_distribution_id_tbl
5181: FROM
5182: PO_DISTRIBUTIONS_MERGE_V POD --
5184: WHERE POD.po_header_id = IDS.num1
5185: AND POD.draft_id = p_draft_id
5186: AND POD.po_release_id IS NULL
5200:
5201: SELECT POD.po_distribution_id
5202: BULK COLLECT INTO x_distribution_id_tbl
5203: FROM
5204: PO_DISTRIBUTIONS_MERGE_V POD --
5206: WHERE POD.po_line_id = IDS.num1
5207: AND POD.draft_id = p_draft_id
5208: AND POD.po_release_id IS NULL
5222:
5223: SELECT POD.po_distribution_id
5224: BULK COLLECT INTO x_distribution_id_tbl
5225: FROM
5226: PO_DISTRIBUTIONS_MERGE_V POD --
5228: WHERE POD.line_location_id = IDS.num1
5229: AND POD.draft_id = p_draft_id
5230: AND IDS.key = l_doc_level_id_key