DBA Data[Home] [Help]

APPS.MSC_SDA_UTILS dependencies on MSC_PQ_TYPES

Line 703: from msc_pq_types mpt,

699: mpq.query_name region_list,
700: mpt.object_type region_id,
701: msc_sda_utils.getRegionName(mpt.object_type) region_code,
702: mpt.sequence_id sort_column
703: from msc_pq_types mpt,
704: msc_personal_queries mpq
705: where mpq.query_id = p_region_list
706: and mpq.query_id = mpt.query_id
707: and p_region_type = c_reg_list_view

Line 772: from msc_pq_types mpt,

768: mpt.source_type inst_id,
769: mpt.object_type org_id,
770: msc_get_name.org_code(mpt.object_type, mpt.source_type) org_code,
771: to_number(null) inventory_item_id
772: from msc_pq_types mpt,
773: msc_personal_queries mpq
774: where mpq.query_id = p_org_list
775: and mpq.query_id = mpt.query_id
776: and p_org_type = c_org_list_view

Line 893: from msc_pq_types mpt,

889: mpt.source_type inst_id,
890: mpt.object_type org_id,
891: msc_get_name.org_code(mpt.object_type, mpt.source_type) org_code,
892: mpt.sequence_id sort_column
893: from msc_pq_types mpt,
894: msc_personal_queries mpq,
895: msc_analysis_query maq
896: where maq.query_id = p_query_id
897: and maq.row_index = p_row_index