DBA Data[Home] [Help]

APPS.MSC_SDA_UTILS dependencies on MSC_PQ_TYPES

Line 338: from msc_pq_types mpt,

334: mpq.query_name region_list,
335: mpt.object_type region_id,
336: msc_sda_utils.getRegionName(mpt.object_type) region_code,
337: mpt.sequence_id sort_column
338: from msc_pq_types mpt,
339: msc_personal_queries mpq
340: where mpq.query_id = p_region_list
341: and mpq.query_id = mpt.query_id
342: and p_region_type = c_reg_list_view

Line 407: from msc_pq_types mpt,

403: mpt.source_type inst_id,
404: mpt.object_type org_id,
405: msc_get_name.org_code(mpt.object_type, mpt.source_type) org_code,
406: to_number(null) inventory_item_id
407: from msc_pq_types mpt,
408: msc_personal_queries mpq
409: where mpq.query_id = p_org_list
410: and mpq.query_id = mpt.query_id
411: and p_org_type = c_org_list_view

Line 528: from msc_pq_types mpt,

524: mpt.source_type inst_id,
525: mpt.object_type org_id,
526: msc_get_name.org_code(mpt.object_type, mpt.source_type) org_code,
527: mpt.sequence_id sort_column
528: from msc_pq_types mpt,
529: msc_personal_queries mpq,
530: msc_analysis_query maq
531: where maq.query_id = p_query_id
532: and maq.row_index = p_row_index