8771: select DISTINCT
8772: fpov2.profile_option_value
8773: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8774: where fpov1.profile_option_id = (select fpo.profile_option_id
8775: from fnd_profile_options fpo
8776: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8777: and fpov1.level_id = 10003
8778: and fpov1.application_id = 235
8779: AND fpov2.profile_option_id = (select fpo.profile_option_id
8776: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8777: and fpov1.level_id = 10003
8778: and fpov1.application_id = 235
8779: AND fpov2.profile_option_id = (select fpo.profile_option_id
8780: from fnd_profile_options fpo
8781: where fpo.profile_option_name = 'ORG_ID')
8782: and fpov2.level_id = 10003
8783: and fpov2.application_id = 0
8784: AND fpov2.level_value=fpov1.level_value
8788: select DISTINCT
8789: fpov2.profile_option_value
8790: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8791: where fpov1.profile_option_id = (select fpo.profile_option_id
8792: from fnd_profile_options fpo
8793: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8794: and fpov1.level_id = 10003
8795: and fpov1.application_id = 235
8796: AND fpov2.profile_option_id = (select fpo.profile_option_id
8793: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8794: and fpov1.level_id = 10003
8795: and fpov1.application_id = 235
8796: AND fpov2.profile_option_id = (select fpo.profile_option_id
8797: from fnd_profile_options fpo
8798: where fpo.profile_option_name = 'ORG_ID')
8799: and fpov2.level_id = 10003
8800: and fpov2.application_id = 0
8801: AND fpov2.level_value=fpov1.level_value