DBA Data[Home] [Help]

APPS.PO_AUTO_DIST_PROCESS_PVT dependencies on PO_DISTRIBUTIONS_MERGE_V

Line 131: FROM po_distributions_merge_v --Add req to mod project

127: --get previous max distribution number for this shipment
128: IF po_autocreate_params.g_process_code = 'ADD_FUNDS' THEN
129: SELECT NVL(MAX(distribution_num), 0)
130: INTO x_distribution_num
131: FROM po_distributions_merge_v --Add req to mod project
132: WHERE line_location_id = p_lines.line_loc_id_tbl(i)
133: AND draft_id = po_autocreate_params.g_draft_id;
134: ELSE
135: /*Bug 13586217 replaced base table with the merge view to cater to add to mod flow */

Line 138: FROM po_distributions_merge_v --

134: ELSE
135: /*Bug 13586217 replaced base table with the merge view to cater to add to mod flow */
136: SELECT NVL(MAX(distribution_num), 0)
137: INTO x_distribution_num
138: FROM po_distributions_merge_v --
139: WHERE line_location_id = p_lines.line_loc_id_tbl(i)
140: AND draft_id = po_autocreate_params.g_draft_id;
141: END IF;
142: