APPS.CSTPSCEX dependencies on MRP_SOURCES_V

Line 137: from mrp_sources_v MSV

133: l_stmt_num := 15;
134:
135: select min(MSV.rank)
136: into l_min_rank
137: from mrp_sources_v MSV
138: where
139: MSV.assignment_set_id = i_assignment_set_id and
140: MSV.inventory_item_id = i_inventory_item_id and
141: MSV.organization_id = i_organization_id and

Line 149: -- Take snapshot from MRP_SOURCES_V, all rows except for

145: nvl( MSV.disable_date, i_effective_date + 1 ) > i_effective_date;
146:
147: --
148: -- stmt_num 20
149: -- Take snapshot from MRP_SOURCES_V, all rows except for
150: -- same org rows. Those will be inserted in the next
151: -- SQL statement using the percentage left of the 100%.
152: -- Note:
153: -- source_type codes:

Line 216: mrp_sources_v MSV

212: i_prog_id, -- PROGRAM_ID
213: sysdate, -- PROGRAM_UPDATE_DATE
214: msv.sourcing_rule_name
215: from
216: mrp_sources_v MSV
217: where
218: MSV.assignment_set_id = i_assignment_set_id and
219: MSV.inventory_item_id = i_inventory_item_id and
220: MSV.organization_id = i_organization_id and