[Home] [Help]
174: bbui.building_block_category,
175: bbit.bld_blk_info_type_id,
176: bbit.bld_blk_info_type
177: from hxc_mapping_components mc
178: ,hxc_mapping_comp_usages mcu
179: ,hxc_mappings m
180: ,hxc_retrieval_processes rp
181: ,hxc_bld_blk_info_types bbit
182: ,hxc_bld_blk_info_type_usages bbui
194: bbui.building_block_category,
195: bbit.bld_blk_info_type_id,
196: bbit.bld_blk_info_type
197: from hxc_mapping_components mc
198: ,hxc_mapping_comp_usages mcu
199: ,hxc_mappings m
200: ,hxc_deposit_processes dp
201: ,hxc_bld_blk_info_types bbit
202: ,hxc_bld_blk_info_type_usages bbui
1654: hxc_bld_blk_info_types bbit
1655: WHERE
1656: mc.mapping_component_id in (Select mcu.mapping_component_id from
1657: hxc_mappings m ,
1658: hxc_mapping_comp_usages mcu,
1659: hxc_retrieval_processes rp
1660: WHERE
1661: rp.mapping_id = m.mapping_id and
1662: rp.retrieval_process_id = p_retrieval_process_id and
1670: CURSOR csr_wtd_components(p_attribute_category VARCHAR2)
1671: IS
1672: select mc.segment, mc.field_name, bbui.building_block_category
1673: from hxc_mapping_components mc
1674: ,hxc_mapping_comp_usages mcu
1675: ,hxc_mappings m
1676: ,hxc_deposit_processes dp
1677: ,hxc_bld_blk_info_types bbit
1678: ,hxc_bld_blk_info_type_usages bbui
2322: ,p_bbit_id NUMBER)
2323: IS
2324: select mc.segment, mc.field_name,bbit.bld_blk_info_type
2325: from hxc_mapping_components mc
2326: ,hxc_mapping_comp_usages mcu
2327: ,hxc_mappings m
2328: ,hxc_deposit_processes dp
2329: ,hxc_bld_blk_info_types bbit
2330: where dp.mapping_id = m.mapping_id
2682: ,p_field_name VARCHAR2)
2683: IS
2684: select mc.segment
2685: from hxc_mapping_components mc
2686: ,hxc_mapping_comp_usages mcu
2687: ,hxc_mappings m
2688: ,hxc_retrieval_processes rp
2689: ,hxc_bld_blk_info_types bbit
2690: ,hxc_bld_blk_info_type_usages bbui