APPS.MSC_ALLOCATION_PLAN dependencies on MSC_PQ_TYPES

Line 152: from msc_pq_types

148: AND (arg_customer_list_id is null or
149: ( arg_customer_list_id is not null and
150: ((md.customer_id, md.customer_site_id) in (
151: select source_type, object_type
152: from msc_pq_types
153: where query_id = arg_customer_list_id
154: and object_type <> 0) or
155: md.customer_id in (
156: select source_type

Line 157: from msc_pq_types

153: where query_id = arg_customer_list_id
154: and object_type <> 0) or
155: md.customer_id in (
156: select source_type
157: from msc_pq_types
158: where query_id = arg_customer_list_id
159: and object_type = 0) or
160: md.customer_id is null)
161: )

Line 226: from msc_pq_types

222: AND (arg_customer_list_id is null or
223: ( arg_customer_list_id is not null and
224: ((md.customer_id, md.customer_site_id) in (
225: select source_type, object_type
226: from msc_pq_types
227: where query_id = arg_customer_list_id
228: and object_type <> 0) or
229: md.customer_id in (
230: select source_type

Line 231: from msc_pq_types

227: where query_id = arg_customer_list_id
228: and object_type <> 0) or
229: md.customer_id in (
230: select source_type
231: from msc_pq_types
232: where query_id = arg_customer_list_id
233: and object_type = 0) or
234: md.customer_id is null)
235: )