DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on PO_DISTRIBUTIONS_MERGE_V

Line 4658: FROM PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

4654: UPDATE PO_SESSION_GT
4655: SET num2 =
4656: (
4657: SELECT POD.po_line_id
4658: FROM PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
4659: WHERE POD.po_distribution_id = p_doc_level_id_tbl(i)
4660: AND POD.draft_id = p_draft_id
4661: )
4662: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))

Line 4927: FROM PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

4923: UPDATE PO_SESSION_GT
4924: SET num2 =
4925: (
4926: SELECT POD.line_location_id
4927: FROM PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
4928: WHERE POD.po_distribution_id = p_doc_level_id_tbl(i)
4929: AND POD.draft_id = p_draft_id
4930: )
4931: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))

Line 5182: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

5178:
5179: SELECT POD.po_distribution_id
5180: BULK COLLECT INTO x_distribution_id_tbl
5181: FROM
5182: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
5183: , PO_SESSION_GT IDS
5184: WHERE POD.po_header_id = IDS.num1
5185: AND POD.draft_id = p_draft_id
5186: AND POD.po_release_id IS NULL

Line 5204: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

5200:
5201: SELECT POD.po_distribution_id
5202: BULK COLLECT INTO x_distribution_id_tbl
5203: FROM
5204: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
5205: , PO_SESSION_GT IDS
5206: WHERE POD.po_line_id = IDS.num1
5207: AND POD.draft_id = p_draft_id
5208: AND POD.po_release_id IS NULL

Line 5226: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

5222:
5223: SELECT POD.po_distribution_id
5224: BULK COLLECT INTO x_distribution_id_tbl
5225: FROM
5226: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
5227: , PO_SESSION_GT IDS
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