APPS.MSC_ALLOCATION_PLAN dependencies on MSC_PQ_TYPES

Line 154: from msc_pq_types

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

Line 159: from msc_pq_types

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

Line 230: from msc_pq_types

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

Line 235: from msc_pq_types

231: where query_id = arg_customer_list_id
232: and object_type <> 0) or
233: md.customer_id in (
234: select source_type
235: from msc_pq_types
236: where query_id = arg_customer_list_id
237: and object_type = 0) or
238: md.customer_id is null)
239: )