[Home] [Help]
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
183: where rp.mapping_id = m.mapping_id
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
203: where dp.mapping_id = m.mapping_id
1653: 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
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
1679: where dp.mapping_id = m.mapping_id
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
2331: and dp.deposit_process_id = p_deposit_process_id
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
2691: where rp.mapping_id = m.mapping_id