ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US B1A7F0C2D3E4F506172839AA5B6C7D03Y select null action_, null status_, null message_, null modified_columns_, row_number() over (order by x.recipe, x.recipe_version, x.row_type_sort, x.step, x.product, x.validity_rule_id) upload_row, x.organization_code, x.recipe, x.recipe_version, x.row_type, x.creation_organization_code, x.recipe_description, x.formula, x.formula_version, x.routing, x.routing_version, x.recipe_type, x.recipe_status, x.planned_process_loss, x.fixed_process_loss, x.fixed_process_loss_uom, x.recipe_yield, x.contiguous, x.enhanced_process_instructions, x.calculate_step_quantity, x.owner, x.ha_attribute_category, x.ha_attribute1, x.ha_attribute2, x.ha_attribute3, x.ha_attribute4, x.ha_attribute5, x.ha_attribute6, x.ha_attribute7, x.ha_attribute8, x.ha_attribute9, x.ha_attribute10, x.ha_attribute11, x.ha_attribute12, x.ha_attribute13, x.ha_attribute14, x.ha_attribute15, x.ha_attribute16, x.ha_attribute17, x.ha_attribute18, x.ha_attribute19, x.ha_attribute20, x.ha_attribute21, x.ha_attribute22, x.ha_attribute23, x.ha_attribute24, x.ha_attribute25, x.ha_attribute26, x.ha_attribute27, x.ha_attribute28, x.ha_attribute29, x.ha_attribute30, x.validity_rule_use, x.validity_organization_code, x.product, x.vr_revision, x.preference, x.standard_quantity, x.minimum_quantity, x.maximum_quantity, x.vr_detail_uom, x.start_date, x.end_date, x.vr_planned_process_loss, x.vr_fixed_process_loss, x.vr_fixed_process_loss_uom, x.va_attribute_category, x.va_attribute1, x.va_attribute2, x.va_attribute3, x.va_attribute4, x.va_attribute5, x.va_attribute6, x.va_attribute7, x.va_attribute8, x.va_attribute9, x.va_attribute10, x.va_attribute11, x.va_attribute12, x.va_attribute13, x.va_attribute14, x.va_attribute15, x.va_attribute16, x.va_attribute17, x.va_attribute18, x.va_attribute19, x.va_attribute20, x.va_attribute21, x.va_attribute22, x.va_attribute23, x.va_attribute24, x.va_attribute25, x.va_attribute26, x.va_attribute27, x.va_attribute28, x.va_attribute29, x.va_attribute30, x.step, x.operation, x.operation_version, x.step_quantity, x.operation_yield, x.material_line_type, x.material_item, x.minimum_transfer_quantity, x.minimum_delay, x.maximum_delay, x.sub_organization_code, x.process_loss, x.pl_fixed_process_loss, x.pl_fixed_process_loss_uom, x.pl_contiguous, x.customer, x.operation_line, x.activity_factor, x.resource_code, x.resource_usage, x.usage_uom, x.process_quantity, x.process_uom, x.minimum_capacity, x.maximum_capacity, x.process_parameter_1, x.process_parameter_2, x.process_parameter_3, x.process_parameter_4, x.process_parameter_5, x.recipe_id, x.validity_rule_id, x.routing_step_id, x.formulaline_id, x.recipe_process_loss_id from ( select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Recipe' row_type, (select mp2.organization_code from mtl_parameters mp2 where mp2.organization_id=grcv.creation_organization_id) creation_organization_code, grcv.recipe_description, (select ffmb.formula_no from fm_form_mst_b ffmb where ffmb.formula_id=grcv.formula_id) formula, (select ffmb.formula_vers from fm_form_mst_b ffmb where ffmb.formula_id=grcv.formula_id) formula_version, (select grb.routing_no from gmd_routings_b grb where grb.routing_id=grcv.routing_id) routing, (select grb.routing_vers from gmd_routings_b grb where grb.routing_id=grcv.routing_id) routing_version, xxen_util.meaning(to_char(grcv.recipe_type),'GMD_RECIPE_TYPE',552) recipe_type, (select gsv.meaning from gmd_status_vl gsv where gsv.status_code=grcv.recipe_status) recipe_status, grcv.planned_process_loss, grcv.fixed_process_loss, grcv.fixed_process_loss_uom, grcv.recipe_yield, xxen_util.meaning(decode(grcv.contiguous_ind,1,'Y','N'),'YES_NO',0) contiguous, xxen_util.meaning(grcv.enhanced_pi_ind,'YES_NO',552) enhanced_process_instructions, xxen_util.meaning(decode(grcv.calculate_step_quantity,1,'Y','N'),'YES_NO',0) calculate_step_quantity, (select fu.user_name from fnd_user fu where fu.user_id=grcv.owner_id) owner, xxen_util.display_flexfield_context(552,'GMD_RECIPES_FLEX',grcv.attribute_category) ha_attribute_category, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE1',grcv.rowid,grcv.attribute1) ha_attribute1, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE2',grcv.rowid,grcv.attribute2) ha_attribute2, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE3',grcv.rowid,grcv.attribute3) ha_attribute3, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE4',grcv.rowid,grcv.attribute4) ha_attribute4, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE5',grcv.rowid,grcv.attribute5) ha_attribute5, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE6',grcv.rowid,grcv.attribute6) ha_attribute6, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE7',grcv.rowid,grcv.attribute7) ha_attribute7, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE8',grcv.rowid,grcv.attribute8) ha_attribute8, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE9',grcv.rowid,grcv.attribute9) ha_attribute9, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE10',grcv.rowid,grcv.attribute10) ha_attribute10, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE11',grcv.rowid,grcv.attribute11) ha_attribute11, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE12',grcv.rowid,grcv.attribute12) ha_attribute12, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE13',grcv.rowid,grcv.attribute13) ha_attribute13, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE14',grcv.rowid,grcv.attribute14) ha_attribute14, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE15',grcv.rowid,grcv.attribute15) ha_attribute15, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE16',grcv.rowid,grcv.attribute16) ha_attribute16, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE17',grcv.rowid,grcv.attribute17) ha_attribute17, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE18',grcv.rowid,grcv.attribute18) ha_attribute18, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE19',grcv.rowid,grcv.attribute19) ha_attribute19, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE20',grcv.rowid,grcv.attribute20) ha_attribute20, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE21',grcv.rowid,grcv.attribute21) ha_attribute21, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE22',grcv.rowid,grcv.attribute22) ha_attribute22, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE23',grcv.rowid,grcv.attribute23) ha_attribute23, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE24',grcv.rowid,grcv.attribute24) ha_attribute24, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE25',grcv.rowid,grcv.attribute25) ha_attribute25, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE26',grcv.rowid,grcv.attribute26) ha_attribute26, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE27',grcv.rowid,grcv.attribute27) ha_attribute27, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE28',grcv.rowid,grcv.attribute28) ha_attribute28, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE29',grcv.rowid,grcv.attribute29) ha_attribute29, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE30',grcv.rowid,grcv.attribute30) ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, null step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, null sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, null routing_step_id, null formulaline_id, null recipe_process_loss_id, 1 row_type_sort from gmd_recipes_vl grcv, mtl_parameters mp where grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Validity Rule' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, xxen_util.meaning(grvr.recipe_use,'GMD_FORMULA_USE',552) validity_rule_use, (select mp2.organization_code from mtl_parameters mp2 where mp2.organization_id=grvr.organization_id) validity_organization_code, (select msiv.concatenated_segments from mtl_system_items_vl msiv where msiv.inventory_item_id=grvr.inventory_item_id and msiv.organization_id=grcv.owner_organization_id) product, grvr.revision vr_revision, grvr.preference, grvr.std_qty standard_quantity, grvr.min_qty minimum_quantity, grvr.max_qty maximum_quantity, grvr.detail_uom vr_detail_uom, grvr.start_date, grvr.end_date, grvr.planned_process_loss vr_planned_process_loss, grvr.fixed_process_loss vr_fixed_process_loss, grvr.fixed_process_loss_uom vr_fixed_process_loss_uom, xxen_util.display_flexfield_context(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category) va_attribute_category, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE1',grvr.rowid,grvr.attribute1) va_attribute1, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE2',grvr.rowid,grvr.attribute2) va_attribute2, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE3',grvr.rowid,grvr.attribute3) va_attribute3, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE4',grvr.rowid,grvr.attribute4) va_attribute4, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE5',grvr.rowid,grvr.attribute5) va_attribute5, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE6',grvr.rowid,grvr.attribute6) va_attribute6, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE7',grvr.rowid,grvr.attribute7) va_attribute7, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE8',grvr.rowid,grvr.attribute8) va_attribute8, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE9',grvr.rowid,grvr.attribute9) va_attribute9, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE10',grvr.rowid,grvr.attribute10) va_attribute10, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE11',grvr.rowid,grvr.attribute11) va_attribute11, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE12',grvr.rowid,grvr.attribute12) va_attribute12, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE13',grvr.rowid,grvr.attribute13) va_attribute13, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE14',grvr.rowid,grvr.attribute14) va_attribute14, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE15',grvr.rowid,grvr.attribute15) va_attribute15, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE16',grvr.rowid,grvr.attribute16) va_attribute16, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE17',grvr.rowid,grvr.attribute17) va_attribute17, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE18',grvr.rowid,grvr.attribute18) va_attribute18, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE19',grvr.rowid,grvr.attribute19) va_attribute19, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE20',grvr.rowid,grvr.attribute20) va_attribute20, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE21',grvr.rowid,grvr.attribute21) va_attribute21, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE22',grvr.rowid,grvr.attribute22) va_attribute22, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE23',grvr.rowid,grvr.attribute23) va_attribute23, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE24',grvr.rowid,grvr.attribute24) va_attribute24, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE25',grvr.rowid,grvr.attribute25) va_attribute25, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE26',grvr.rowid,grvr.attribute26) va_attribute26, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE27',grvr.rowid,grvr.attribute27) va_attribute27, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE28',grvr.rowid,grvr.attribute28) va_attribute28, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE29',grvr.rowid,grvr.attribute29) va_attribute29, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE30',grvr.rowid,grvr.attribute30) va_attribute30, null step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, null sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, grvr.recipe_validity_rule_id validity_rule_id, null routing_step_id, null formulaline_id, null recipe_process_loss_id, 2 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_validity_rules grvr, mtl_parameters mp where grcv.recipe_id=grvr.recipe_id and grcv.owner_organization_id=mp.organization_id and nvl(grvr.delete_mark,0)=0 and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Routing Step' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, frd.routingstep_no step, (select gov.oprn_no from gmd_operations_vl gov where gov.oprn_id=frd.oprn_id) operation, (select gov.oprn_vers from gmd_operations_vl gov where gov.oprn_id=frd.oprn_id) operation_version, grrs.step_qty step_quantity, grrs.oprn_yield operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, null sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, frd.routingstep_id routing_step_id, null formulaline_id, null recipe_process_loss_id, 3 row_type_sort from gmd_recipes_vl grcv, fm_rout_dtl frd, gmd_recipe_routing_steps grrs, mtl_parameters mp where frd.routing_id=grcv.routing_id and grrs.recipe_id(+)=grcv.recipe_id and grrs.routingstep_id(+)=frd.routingstep_id and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Step Material' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, (select frd.routingstep_no from fm_rout_dtl frd where frd.routingstep_id=grsm.routingstep_id) step, null operation, null operation_version, null step_quantity, null operation_yield, (select xxen_util.meaning(to_char(fmd.line_type),'GMD_FORMULA_ITEM_TYPE',552) from fm_matl_dtl fmd where fmd.formulaline_id=grsm.formulaline_id) material_line_type, (select msiv.concatenated_segments from fm_matl_dtl fmd, mtl_system_items_vl msiv where fmd.formulaline_id=grsm.formulaline_id and msiv.inventory_item_id=fmd.inventory_item_id and msiv.organization_id=fmd.organization_id) material_item, grsm.minimum_transfer_qty minimum_transfer_quantity, grsm.minimum_delay, grsm.maximum_delay, null sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, grsm.routingstep_id routing_step_id, grsm.formulaline_id, null recipe_process_loss_id, 4 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_step_materials grsm, mtl_parameters mp where grcv.recipe_id=grsm.recipe_id and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Process Loss' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, null step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, grpl.orgn_code sub_organization_code, grpl.process_loss, grpl.fixed_process_loss pl_fixed_process_loss, grpl.fixed_process_loss_uom pl_fixed_process_loss_uom, xxen_util.meaning(decode(grpl.contiguous_ind,1,'Y','N'),'YES_NO',0) pl_contiguous, null customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, null routing_step_id, null formulaline_id, grpl.recipe_process_loss_id, 5 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_process_loss grpl, mtl_parameters mp where grcv.recipe_id=grpl.recipe_id and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Customer' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, null step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, null sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, (select hca_c.account_number from hz_cust_accounts hca_c where hca_c.cust_account_id=grc.customer_id) customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, null routing_step_id, null formulaline_id, null recipe_process_loss_id, 6 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_customers grc, mtl_parameters mp where grcv.recipe_id=grc.recipe_id and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Org Operation' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, frd.routingstep_no step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, groa.orgn_code sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, goa.activity operation_line, groa.activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, null routing_step_id, null formulaline_id, null recipe_process_loss_id, 7 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_orgn_activities groa, fm_rout_dtl frd, gmd_operation_activities goa, mtl_parameters mp where grcv.recipe_id=groa.recipe_id and groa.routingstep_id=frd.routingstep_id(+) and groa.oprn_line_id=goa.oprn_line_id(+) and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Org Resource' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, frd.routingstep_no step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, gror.orgn_code sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, goa.activity operation_line, null activity_factor, gror.resources resource_code, gror.resource_usage, gror.usage_uom, gror.process_qty process_quantity, gror.process_um process_uom, gror.min_capacity minimum_capacity, gror.max_capacity maximum_capacity, gror.process_parameter_1, gror.process_parameter_2, gror.process_parameter_3, gror.process_parameter_4, gror.process_parameter_5, grcv.recipe_id, null validity_rule_id, null routing_step_id, null formulaline_id, null recipe_process_loss_id, 8 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_orgn_resources gror, fm_rout_dtl frd, gmd_operation_activities goa, mtl_parameters mp where grcv.recipe_id=gror.recipe_id and gror.routingstep_id=frd.routingstep_id(+) and gror.oprn_line_id=goa.oprn_line_id(+) and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update ) x where 1=1 Multi-entity (Row-Type) recipe upload: header, validity rules, routing steps, step/material associations U A xxen_opm_upload.upload_recipe US OPM Recipe Upload Enginatics Upload 1=1 :p_upload_mode 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 1=1 x.organization_code=:p_organization_code LOV custom Y select mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv, org_access_view oav where mp.process_enabled_flag='Y' and mp.organization_id=haouv.organization_id and mp.organization_id=oav.organization_id and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id order by 1 US Organization Code 3 30 1=1 x.recipe=:p_recipe Char US Recipe 7DC8A45A94D34BC285EB2C70AC7A5B46 Customer Recipe customer associations. SYSADMIN 5 CUSTOMER 1 ORGANIZATION_CODE 2 RECIPE 3 RECIPE_VERSION 4 ROW_TYPE Y Customer S Site 3F581F028F214F77B2391990E0C1BEAC Org Operation Recipe organization operations: activity factor per organization, routing step and operation activity. SYSADMIN 8 ACTIVITY_FACTOR 7 OPERATION_LINE 1 ORGANIZATION_CODE 2 RECIPE 3 RECIPE_VERSION 4 ROW_TYPE Y Org Operation 5 STEP 6 SUB_ORGANIZATION_CODE S Site 8FCA9A48BABD417C8C9636E79130A8DC Org Resource Recipe organization resources: usage, process quantity, capacity and process parameters per organization, routing step and operation activity. SYSADMIN 14 MAXIMUM_CAPACITY 13 MINIMUM_CAPACITY 7 OPERATION_LINE 1 ORGANIZATION_CODE 15 PROCESS_PARAMETER_1 16 PROCESS_PARAMETER_2 17 PROCESS_PARAMETER_3 18 PROCESS_PARAMETER_4 19 PROCESS_PARAMETER_5 11 PROCESS_QUANTITY 12 PROCESS_UOM 2 RECIPE 3 RECIPE_VERSION 8 RESOURCE_CODE 9 RESOURCE_USAGE 4 ROW_TYPE Y Org Resource 5 STEP 6 SUB_ORGANIZATION_CODE 10 USAGE_UOM S Site 9327F69360C94DDAB6AEED1D8859BE71 Process Loss Recipe process loss per organization. SYSADMIN 1 ORGANIZATION_CODE 9 PL_CONTIGUOUS 7 PL_FIXED_PROCESS_LOSS 8 PL_FIXED_PROCESS_LOSS_UOM 6 PROCESS_LOSS 2 RECIPE 3 RECIPE_VERSION 4 ROW_TYPE Y Process Loss 5 SUB_ORGANIZATION_CODE S Site 40E9C56A1DF14384827E4F9C262B5938 Recipe Recipe header: formula, routing, process loss defaults, owner and recipe descriptive flexfield attributes. SYSADMIN 19 CALCULATE_STEP_QUANTITY 17 CONTIGUOUS 5 CREATION_ORGANIZATION_CODE 18 ENHANCED_PROCESS_INSTRUCTIONS 14 FIXED_PROCESS_LOSS 15 FIXED_PROCESS_LOSS_UOM 7 FORMULA 8 FORMULA_VERSION 22 HA_ATTRIBUTE1 31 HA_ATTRIBUTE10 32 HA_ATTRIBUTE11 33 HA_ATTRIBUTE12 34 HA_ATTRIBUTE13 35 HA_ATTRIBUTE14 36 HA_ATTRIBUTE15 37 HA_ATTRIBUTE16 38 HA_ATTRIBUTE17 39 HA_ATTRIBUTE18 40 HA_ATTRIBUTE19 23 HA_ATTRIBUTE2 41 HA_ATTRIBUTE20 42 HA_ATTRIBUTE21 43 HA_ATTRIBUTE22 44 HA_ATTRIBUTE23 45 HA_ATTRIBUTE24 46 HA_ATTRIBUTE25 47 HA_ATTRIBUTE26 48 HA_ATTRIBUTE27 49 HA_ATTRIBUTE28 50 HA_ATTRIBUTE29 24 HA_ATTRIBUTE3 51 HA_ATTRIBUTE30 25 HA_ATTRIBUTE4 26 HA_ATTRIBUTE5 27 HA_ATTRIBUTE6 28 HA_ATTRIBUTE7 29 HA_ATTRIBUTE8 30 HA_ATTRIBUTE9 21 HA_ATTRIBUTE_CATEGORY 1 ORGANIZATION_CODE 20 OWNER 13 PLANNED_PROCESS_LOSS 2 RECIPE 6 RECIPE_DESCRIPTION 12 RECIPE_STATUS 11 RECIPE_TYPE 3 RECIPE_VERSION 16 RECIPE_YIELD 9 ROUTING 10 ROUTING_VERSION 4 ROW_TYPE Y Recipe S Site 67F254FF1A6C4BC6B07369A7C641FC6E Routing Step Recipe routing steps: step quantity and operation yield overrides per routing step. SYSADMIN 6 OPERATION 7 OPERATION_VERSION 9 OPERATION_YIELD 1 ORGANIZATION_CODE 2 RECIPE 3 RECIPE_VERSION 4 ROW_TYPE Y Routing Step 5 STEP 8 STEP_QUANTITY S Site A2C64C31077B4F2CB71BD94D8088146A Step Material Step and material associations: transfer quantity and delays per routing step and formula line. SYSADMIN 7 MATERIAL_ITEM 6 MATERIAL_LINE_TYPE 10 MAXIMUM_DELAY 9 MINIMUM_DELAY 8 MINIMUM_TRANSFER_QUANTITY 1 ORGANIZATION_CODE 2 RECIPE 3 RECIPE_VERSION 4 ROW_TYPE Y Step Material 5 STEP S Site 51627B3C651B405D8CD69FA958DA9720 Validity Rule Recipe validity rules: use, product, quantity range, effective dates, process loss and validity rule descriptive flexfield attributes. SYSADMIN 15 END_DATE 12 MAXIMUM_QUANTITY 11 MINIMUM_QUANTITY 1 ORGANIZATION_CODE 9 PREFERENCE 7 PRODUCT 2 RECIPE 3 RECIPE_VERSION 4 ROW_TYPE Y Validity Rule 10 STANDARD_QUANTITY 14 START_DATE 6 VALIDITY_ORGANIZATION_CODE 5 VALIDITY_RULE_USE 20 VA_ATTRIBUTE1 29 VA_ATTRIBUTE10 30 VA_ATTRIBUTE11 31 VA_ATTRIBUTE12 32 VA_ATTRIBUTE13 33 VA_ATTRIBUTE14 34 VA_ATTRIBUTE15 35 VA_ATTRIBUTE16 36 VA_ATTRIBUTE17 37 VA_ATTRIBUTE18 38 VA_ATTRIBUTE19 21 VA_ATTRIBUTE2 39 VA_ATTRIBUTE20 40 VA_ATTRIBUTE21 41 VA_ATTRIBUTE22 42 VA_ATTRIBUTE23 43 VA_ATTRIBUTE24 44 VA_ATTRIBUTE25 45 VA_ATTRIBUTE26 46 VA_ATTRIBUTE27 47 VA_ATTRIBUTE28 48 VA_ATTRIBUTE29 22 VA_ATTRIBUTE3 49 VA_ATTRIBUTE30 23 VA_ATTRIBUTE4 24 VA_ATTRIBUTE5 25 VA_ATTRIBUTE6 26 VA_ATTRIBUTE7 27 VA_ATTRIBUTE8 28 VA_ATTRIBUTE9 19 VA_ATTRIBUTE_CATEGORY 13 VR_DETAIL_UOM 17 VR_FIXED_PROCESS_LOSS 18 VR_FIXED_PROCESS_LOSS_UOM 16 VR_PLANNED_PROCESS_LOSS 8 VR_REVISION S Site 40E9C56A1DF14384827E4F9C262B5938 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 UPLOAD_ROW Number number Y 6 ORGANIZATION_CODE LOV custom varchar2 3 Y select mp.organization_code id, mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv, org_access_view oav where mp.process_enabled_flag='Y' and mp.organization_id=haouv.organization_id and mp.organization_id=oav.organization_id and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id order by 1 Y 7 RECIPE Char varchar2 32 Y 8 RECIPE_VERSION Number number Y 9 ROW_TYPE LOV custom varchar2 13 Y select 'Recipe' id, 'Recipe' value, null description from dual union all select 'Validity Rule' id, 'Validity Rule' value, null description from dual union all select 'Routing Step' id, 'Routing Step' value, null description from dual union all select 'Step Material' id, 'Step Material' value, null description from dual union all select 'Process Loss' id, 'Process Loss' value, null description from dual union all select 'Customer' id, 'Customer' value, null description from dual union all select 'Org Operation' id, 'Org Operation' value, null description from dual union all select 'Org Resource' id, 'Org Resource' value, null description from dual Y 10 CREATION_ORGANIZATION_CODE LOV custom varchar2 3 Y select mp.organization_code id, mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv, org_access_view oav where mp.process_enabled_flag='Y' and mp.organization_id=haouv.organization_id and mp.organization_id=oav.organization_id and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id order by 1 11 RECIPE_DESCRIPTION Char varchar2 240 12 FORMULA LOV custom varchar2 32 Y select ffmv.formula_no id, ffmv.formula_no value, min(ffmv.formula_desc1) description from fm_form_mst_vl ffmv, mtl_parameters mp where ffmv.owner_organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and ffmv.delete_mark=0 and nvl(ffmv.inactive_ind,0)=0 group by ffmv.formula_no order by 1 13 FORMULA_VERSION Number number 14 ROUTING LOV custom varchar2 32 Y select grv.routing_no id, grv.routing_no value, min(grv.routing_desc) description from gmd_routings_vl grv, mtl_parameters mp where grv.owner_organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and grv.delete_mark=0 group by grv.routing_no order by 1 15 ROUTING_VERSION Number number 16 RECIPE_TYPE LOV custom varchar2 Y select to_number(flvv.lookup_code) id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='GMD_RECIPE_TYPE' and flvv.view_application_id=552 and flvv.enabled_flag='Y' and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by 1 17 RECIPE_STATUS LOV custom varchar2 80 Y select gsv.status_code id, gsv.meaning value, gsv.description from gmd_status_vl gsv where to_number(gsv.status_code)<1000 order by 1 18 PLANNED_PROCESS_LOSS Number number 19 FIXED_PROCESS_LOSS Number number 20 FIXED_PROCESS_LOSS_UOM LOV custom varchar2 3 Y select muomv.uom_code id, muomv.uom_code value, muomv.unit_of_measure description from mtl_units_of_measure_vl muomv where muomv.disable_date is null order by 1 21 RECIPE_YIELD Number number 22 CONTIGUOUS LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 23 ENHANCED_PROCESS_INSTRUCTIONS LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 24 CALCULATE_STEP_QUANTITY LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 25 OWNER LOV custom varchar2 100 Y select fu.user_id id, fu.user_name value, fu.description from fnd_user fu where sysdate between fu.start_date and nvl(fu.end_date,sysdate+1) order by 2 26 HA_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=552 and fdfcv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by 2 27 HA_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE1' 28 HA_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE2' 29 HA_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE3' 30 HA_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE4' 31 HA_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE5' 32 HA_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE6' 33 HA_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE7' 34 HA_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE8' 35 HA_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE9' 36 HA_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE10' 37 HA_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE11' 38 HA_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE12' 39 HA_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE13' 40 HA_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE14' 41 HA_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE15' 42 HA_ATTRIBUTE16 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE16' 43 HA_ATTRIBUTE17 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE17' 44 HA_ATTRIBUTE18 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE18' 45 HA_ATTRIBUTE19 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE19' 46 HA_ATTRIBUTE20 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE20' 47 HA_ATTRIBUTE21 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE21' 48 HA_ATTRIBUTE22 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE22' 49 HA_ATTRIBUTE23 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE23' 50 HA_ATTRIBUTE24 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE24' 51 HA_ATTRIBUTE25 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE25' 52 HA_ATTRIBUTE26 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE26' 53 HA_ATTRIBUTE27 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE27' 54 HA_ATTRIBUTE28 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE28' 55 HA_ATTRIBUTE29 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE29' 56 HA_ATTRIBUTE30 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPES_FLEX', p_context_name=>:$column$.ha_attribute_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.ha_attribute1, p_attribute2=>:$column$.ha_attribute2, p_attribute3=>:$column$.ha_attribute3, p_attribute4=>:$column$.ha_attribute4, p_attribute5=>:$column$.ha_attribute5, p_attribute6=>:$column$.ha_attribute6, p_attribute7=>:$column$.ha_attribute7, p_attribute8=>:$column$.ha_attribute8, p_attribute9=>:$column$.ha_attribute9, p_attribute10=>:$column$.ha_attribute10, p_attribute11=>:$column$.ha_attribute11, p_attribute12=>:$column$.ha_attribute12, p_attribute13=>:$column$.ha_attribute13, p_attribute14=>:$column$.ha_attribute14, p_attribute15=>:$column$.ha_attribute15, p_attribute16=>:$column$.ha_attribute16, p_attribute17=>:$column$.ha_attribute17, p_attribute18=>:$column$.ha_attribute18, p_attribute19=>:$column$.ha_attribute19, p_attribute20=>:$column$.ha_attribute20, p_attribute21=>:$column$.ha_attribute21, p_attribute22=>:$column$.ha_attribute22, p_attribute23=>:$column$.ha_attribute23, p_attribute24=>:$column$.ha_attribute24, p_attribute25=>:$column$.ha_attribute25, p_attribute26=>:$column$.ha_attribute26, p_attribute27=>:$column$.ha_attribute27, p_attribute28=>:$column$.ha_attribute28, p_attribute29=>:$column$.ha_attribute29, p_attribute30=>:$column$.ha_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE30' 57 VALIDITY_RULE_USE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='GMD_FORMULA_USE' and flvv.view_application_id=552 and flvv.enabled_flag='Y' and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by 1 58 VALIDITY_ORGANIZATION_CODE LOV custom varchar2 3 Y select mp.organization_code id, mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv, org_access_view oav where mp.process_enabled_flag='Y' and mp.organization_id=haouv.organization_id and mp.organization_id=oav.organization_id and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id order by 1 59 PRODUCT LOV custom varchar2 40 Y select msiv.concatenated_segments id, msiv.concatenated_segments value, msiv.description from fm_matl_dtl fmd, fm_form_mst_b ffmb, mtl_system_items_vl msiv, mtl_parameters mp where fmd.formula_id=ffmb.formula_id and ffmb.formula_no=:$column$.formula and ffmb.formula_vers=:$column$.formula_version and ffmb.owner_organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and fmd.line_type in (1,2) and fmd.inventory_item_id=msiv.inventory_item_id and fmd.organization_id=msiv.organization_id order by 1 60 VR_REVISION Char varchar2 3 61 PREFERENCE Number number 62 STANDARD_QUANTITY Number number 63 MINIMUM_QUANTITY Number number 64 MAXIMUM_QUANTITY Number number 65 VR_DETAIL_UOM LOV custom varchar2 3 Y select muomv.uom_code id, muomv.uom_code value, muomv.unit_of_measure description from mtl_units_of_measure_vl muomv where muomv.disable_date is null order by 1 66 START_DATE Date date 67 END_DATE Date date 68 VR_PLANNED_PROCESS_LOSS Number number 69 VR_FIXED_PROCESS_LOSS Number number 70 VR_FIXED_PROCESS_LOSS_UOM LOV custom varchar2 3 Y select muomv.uom_code id, muomv.uom_code value, muomv.unit_of_measure description from mtl_units_of_measure_vl muomv where muomv.disable_date is null order by 1 71 VA_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=552 and fdfcv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by 2 72 VA_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE1' 73 VA_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE2' 74 VA_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE3' 75 VA_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE4' 76 VA_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE5' 77 VA_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE6' 78 VA_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE7' 79 VA_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE8' 80 VA_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE9' 81 VA_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE10' 82 VA_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE11' 83 VA_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE12' 84 VA_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE13' 85 VA_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE14' 86 VA_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE15' 87 VA_ATTRIBUTE16 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE16' 88 VA_ATTRIBUTE17 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE17' 89 VA_ATTRIBUTE18 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE18' 90 VA_ATTRIBUTE19 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE19' 91 VA_ATTRIBUTE20 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE20' 92 VA_ATTRIBUTE21 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE21' 93 VA_ATTRIBUTE22 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE22' 94 VA_ATTRIBUTE23 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE23' 95 VA_ATTRIBUTE24 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE24' 96 VA_ATTRIBUTE25 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE25' 97 VA_ATTRIBUTE26 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE26' 98 VA_ATTRIBUTE27 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE27' 99 VA_ATTRIBUTE28 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE28' 100 VA_ATTRIBUTE29 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE29' 101 VA_ATTRIBUTE30 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'GMD_RECIPE_VALIDITY_RULES_FLEX', p_context_name=>:$column$.va_attribute_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.va_attribute1, p_attribute2=>:$column$.va_attribute2, p_attribute3=>:$column$.va_attribute3, p_attribute4=>:$column$.va_attribute4, p_attribute5=>:$column$.va_attribute5, p_attribute6=>:$column$.va_attribute6, p_attribute7=>:$column$.va_attribute7, p_attribute8=>:$column$.va_attribute8, p_attribute9=>:$column$.va_attribute9, p_attribute10=>:$column$.va_attribute10, p_attribute11=>:$column$.va_attribute11, p_attribute12=>:$column$.va_attribute12, p_attribute13=>:$column$.va_attribute13, p_attribute14=>:$column$.va_attribute14, p_attribute15=>:$column$.va_attribute15, p_attribute16=>:$column$.va_attribute16, p_attribute17=>:$column$.va_attribute17, p_attribute18=>:$column$.va_attribute18, p_attribute19=>:$column$.va_attribute19, p_attribute20=>:$column$.va_attribute20, p_attribute21=>:$column$.va_attribute21, p_attribute22=>:$column$.va_attribute22, p_attribute23=>:$column$.va_attribute23, p_attribute24=>:$column$.va_attribute24, p_attribute25=>:$column$.va_attribute25, p_attribute26=>:$column$.va_attribute26, p_attribute27=>:$column$.va_attribute27, p_attribute28=>:$column$.va_attribute28, p_attribute29=>:$column$.va_attribute29, p_attribute30=>:$column$.va_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='GMD_RECIPE_VALIDITY_RULES_FLEX' and fdfcuv.application_column_name='ATTRIBUTE30' 102 STEP Number number 103 OPERATION LOV custom varchar2 16 Y select gov.oprn_no id, gov.oprn_no value, gov.oprn_desc description from gmd_operations_vl gov, mtl_parameters mp where gov.owner_organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and gov.delete_mark=0 order by 1 Y 104 OPERATION_VERSION Number number Y 105 STEP_QUANTITY Number number 106 OPERATION_YIELD Number number 107 MATERIAL_LINE_TYPE LOV custom varchar2 Y select to_number(flvv.lookup_code) id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='GMD_FORMULA_ITEM_TYPE' and flvv.view_application_id=552 and flvv.enabled_flag='Y' and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by 1 108 MATERIAL_ITEM LOV custom varchar2 40 Y select msiv.concatenated_segments id, msiv.concatenated_segments value, msiv.description from gmd_recipes_b grb, fm_matl_dtl fmd, mtl_system_items_vl msiv, mtl_parameters mp where mp.organization_code=:$column$.organization_code and grb.owner_organization_id=mp.organization_id and grb.recipe_no=:$column$.recipe and grb.recipe_version=:$column$.recipe_version and fmd.formula_id=grb.formula_id and msiv.inventory_item_id=fmd.inventory_item_id and msiv.organization_id=fmd.organization_id order by 1 109 MINIMUM_TRANSFER_QUANTITY Number number 110 MINIMUM_DELAY Number number 111 MAXIMUM_DELAY Number number 112 SUB_ORGANIZATION_CODE LOV custom varchar2 4 Y select mp.organization_code id, mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv, org_access_view oav where mp.process_enabled_flag='Y' and mp.organization_id=haouv.organization_id and mp.organization_id=oav.organization_id and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id order by 1 113 PROCESS_LOSS Number number 114 PL_FIXED_PROCESS_LOSS Number number 115 PL_FIXED_PROCESS_LOSS_UOM LOV custom varchar2 3 Y select muomv.uom_code id, muomv.uom_code value, muomv.unit_of_measure description from mtl_units_of_measure_vl muomv where muomv.disable_date is null order by 1 116 PL_CONTIGUOUS LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 117 CUSTOMER LOV custom varchar2 30 Y select hca.account_number id, hca.account_number value, hp.party_name description from hz_cust_accounts hca, hz_parties hp where hca.party_id=hp.party_id and hca.status='A' order by 1 118 OPERATION_LINE LOV custom varchar2 16 Y select goa.activity value, gab.activity_desc description from gmd_recipes_b grb, fm_rout_dtl frd, gmd_operation_activities goa, gmd_activities_b gab, mtl_parameters mp where mp.organization_code=:$column$.organization_code and grb.owner_organization_id=mp.organization_id and grb.recipe_no=:$column$.recipe and grb.recipe_version=:$column$.recipe_version and frd.routing_id=grb.routing_id and frd.routingstep_no=:$column$.step and goa.oprn_id=frd.oprn_id and goa.delete_mark=0 and goa.activity=gab.activity order by goa.activity 119 ACTIVITY_FACTOR Number number 120 RESOURCE_CODE Char varchar2 16 121 RESOURCE_USAGE Number number 122 USAGE_UOM LOV custom varchar2 3 Y select muomv.uom_code id, muomv.uom_code value, muomv.unit_of_measure description from mtl_units_of_measure_vl muomv where muomv.disable_date is null order by 1 123 PROCESS_QUANTITY Number number 124 PROCESS_UOM Char varchar2 3 Y 125 MINIMUM_CAPACITY Number number 126 MAXIMUM_CAPACITY Number number 127 PROCESS_PARAMETER_1 Char varchar2 16 128 PROCESS_PARAMETER_2 Char varchar2 16 129 PROCESS_PARAMETER_3 Char varchar2 16 130 PROCESS_PARAMETER_4 Char varchar2 16 131 PROCESS_PARAMETER_5 Char varchar2 16 132 RECIPE_ID Number number Y 133 VALIDITY_RULE_ID Number number Y 134 ROUTING_STEP_ID Number number Y 135 FORMULALINE_ID Number number Y 136 RECIPE_PROCESS_LOSS_ID Number number Y Error SQL Order By upload_row Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_row, nvl(mp.organization_code, xu.organization_code) organization_code, nvl(grcv.recipe_no, xu.recipe) recipe, nvl(grcv.recipe_version, xu.recipe_version) recipe_version, xu.row_type, nvl((select mp2.organization_code from mtl_parameters mp2 where mp2.organization_id=grcv.creation_organization_id), xu.creation_organization_code) creation_organization_code, nvl(grcv.recipe_description, xu.recipe_description) recipe_description, nvl((select ffmb.formula_no from fm_form_mst_b ffmb where ffmb.formula_id=grcv.formula_id), xu.formula) formula, nvl((select ffmb.formula_vers from fm_form_mst_b ffmb where ffmb.formula_id=grcv.formula_id), xu.formula_version) formula_version, nvl((select grb.routing_no from gmd_routings_b grb where grb.routing_id=grcv.routing_id), xu.routing) routing, nvl((select grb.routing_vers from gmd_routings_b grb where grb.routing_id=grcv.routing_id), xu.routing_version) routing_version, nvl(xxen_util.meaning(to_char(grcv.recipe_type),'GMD_RECIPE_TYPE',552), xu.recipe_type) recipe_type, nvl((select gsv.meaning from gmd_status_vl gsv where gsv.status_code=grcv.recipe_status), xu.recipe_status) recipe_status, nvl(grcv.planned_process_loss, xu.planned_process_loss) planned_process_loss, nvl(grcv.fixed_process_loss, xu.fixed_process_loss) fixed_process_loss, nvl(grcv.fixed_process_loss_uom, xu.fixed_process_loss_uom) fixed_process_loss_uom, nvl(grcv.recipe_yield, xu.recipe_yield) recipe_yield, nvl(xxen_util.meaning(decode(grcv.contiguous_ind,1,'Y','N'),'YES_NO',0), xu.contiguous) contiguous, nvl(xxen_util.meaning(grcv.enhanced_pi_ind,'YES_NO',552), xu.enhanced_process_instructions) enhanced_process_instructions, nvl(xxen_util.meaning(decode(grcv.calculate_step_quantity,1,'Y','N'),'YES_NO',0), xu.calculate_step_quantity) calculate_step_quantity, nvl((select fu.user_name from fnd_user fu where fu.user_id=grcv.owner_id), xu.owner) owner, nvl(xxen_util.display_flexfield_context(552,'GMD_RECIPES_FLEX',grcv.attribute_category), xu.ha_attribute_category) ha_attribute_category, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE1',grcv.rowid,grcv.attribute1), xu.ha_attribute1) ha_attribute1, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE2',grcv.rowid,grcv.attribute2), xu.ha_attribute2) ha_attribute2, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE3',grcv.rowid,grcv.attribute3), xu.ha_attribute3) ha_attribute3, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE4',grcv.rowid,grcv.attribute4), xu.ha_attribute4) ha_attribute4, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE5',grcv.rowid,grcv.attribute5), xu.ha_attribute5) ha_attribute5, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE6',grcv.rowid,grcv.attribute6), xu.ha_attribute6) ha_attribute6, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE7',grcv.rowid,grcv.attribute7), xu.ha_attribute7) ha_attribute7, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE8',grcv.rowid,grcv.attribute8), xu.ha_attribute8) ha_attribute8, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE9',grcv.rowid,grcv.attribute9), xu.ha_attribute9) ha_attribute9, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE10',grcv.rowid,grcv.attribute10), xu.ha_attribute10) ha_attribute10, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE11',grcv.rowid,grcv.attribute11), xu.ha_attribute11) ha_attribute11, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE12',grcv.rowid,grcv.attribute12), xu.ha_attribute12) ha_attribute12, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE13',grcv.rowid,grcv.attribute13), xu.ha_attribute13) ha_attribute13, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE14',grcv.rowid,grcv.attribute14), xu.ha_attribute14) ha_attribute14, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE15',grcv.rowid,grcv.attribute15), xu.ha_attribute15) ha_attribute15, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE16',grcv.rowid,grcv.attribute16), xu.ha_attribute16) ha_attribute16, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE17',grcv.rowid,grcv.attribute17), xu.ha_attribute17) ha_attribute17, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE18',grcv.rowid,grcv.attribute18), xu.ha_attribute18) ha_attribute18, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE19',grcv.rowid,grcv.attribute19), xu.ha_attribute19) ha_attribute19, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE20',grcv.rowid,grcv.attribute20), xu.ha_attribute20) ha_attribute20, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE21',grcv.rowid,grcv.attribute21), xu.ha_attribute21) ha_attribute21, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE22',grcv.rowid,grcv.attribute22), xu.ha_attribute22) ha_attribute22, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE23',grcv.rowid,grcv.attribute23), xu.ha_attribute23) ha_attribute23, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE24',grcv.rowid,grcv.attribute24), xu.ha_attribute24) ha_attribute24, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE25',grcv.rowid,grcv.attribute25), xu.ha_attribute25) ha_attribute25, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE26',grcv.rowid,grcv.attribute26), xu.ha_attribute26) ha_attribute26, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE27',grcv.rowid,grcv.attribute27), xu.ha_attribute27) ha_attribute27, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE28',grcv.rowid,grcv.attribute28), xu.ha_attribute28) ha_attribute28, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE29',grcv.rowid,grcv.attribute29), xu.ha_attribute29) ha_attribute29, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE30',grcv.rowid,grcv.attribute30), xu.ha_attribute30) ha_attribute30, xu.validity_rule_use, xu.validity_organization_code, xu.product, xu.vr_revision, xu.preference, xu.standard_quantity, xu.minimum_quantity, xu.maximum_quantity, xu.vr_detail_uom, xu.start_date, xu.end_date, xu.vr_planned_process_loss, xu.vr_fixed_process_loss, xu.vr_fixed_process_loss_uom, xu.va_attribute_category, xu.va_attribute1, xu.va_attribute2, xu.va_attribute3, xu.va_attribute4, xu.va_attribute5, xu.va_attribute6, xu.va_attribute7, xu.va_attribute8, xu.va_attribute9, xu.va_attribute10, xu.va_attribute11, xu.va_attribute12, xu.va_attribute13, xu.va_attribute14, xu.va_attribute15, xu.va_attribute16, xu.va_attribute17, xu.va_attribute18, xu.va_attribute19, xu.va_attribute20, xu.va_attribute21, xu.va_attribute22, xu.va_attribute23, xu.va_attribute24, xu.va_attribute25, xu.va_attribute26, xu.va_attribute27, xu.va_attribute28, xu.va_attribute29, xu.va_attribute30, xu.step, xu.operation, xu.operation_version, xu.step_quantity, xu.operation_yield, xu.material_line_type, xu.material_item, xu.minimum_transfer_quantity, xu.minimum_delay, xu.maximum_delay, xu.sub_organization_code, xu.process_loss, xu.pl_fixed_process_loss, xu.pl_fixed_process_loss_uom, xu.pl_contiguous, xu.customer, xu.operation_line, xu.activity_factor, xu.resource_code, xu.resource_usage, xu.usage_uom, xu.process_quantity, xu.process_uom, xu.minimum_capacity, xu.maximum_capacity, xu.process_parameter_1, xu.process_parameter_2, xu.process_parameter_3, xu.process_parameter_4, xu.process_parameter_5, nvl(grcv.recipe_id, xu.recipe_id) recipe_id, xu.validity_rule_id, xu.routing_step_id, xu.formulaline_id, xu.recipe_process_loss_id from xxen_opm_recipe_upload_3936_u xu, mtl_parameters mp, gmd_recipes_vl grcv where xu.row_type='Recipe' and mp.organization_code(+)=xu.organization_code and grcv.recipe_no(+)=upper(xu.recipe) and grcv.recipe_version(+)=xu.recipe_version and grcv.owner_organization_id(+)=mp.organization_id and xu.status_code_=xxen_upload.status_success union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_row, nvl(mp.organization_code, xu.organization_code) organization_code, nvl(grcv.recipe_no, xu.recipe) recipe, nvl(grcv.recipe_version, xu.recipe_version) recipe_version, xu.row_type, xu.creation_organization_code, xu.recipe_description, xu.formula, xu.formula_version, xu.routing, xu.routing_version, xu.recipe_type, xu.recipe_status, xu.planned_process_loss, xu.fixed_process_loss, xu.fixed_process_loss_uom, xu.recipe_yield, xu.contiguous, xu.enhanced_process_instructions, xu.calculate_step_quantity, xu.owner, xu.ha_attribute_category, xu.ha_attribute1, xu.ha_attribute2, xu.ha_attribute3, xu.ha_attribute4, xu.ha_attribute5, xu.ha_attribute6, xu.ha_attribute7, xu.ha_attribute8, xu.ha_attribute9, xu.ha_attribute10, xu.ha_attribute11, xu.ha_attribute12, xu.ha_attribute13, xu.ha_attribute14, xu.ha_attribute15, xu.ha_attribute16, xu.ha_attribute17, xu.ha_attribute18, xu.ha_attribute19, xu.ha_attribute20, xu.ha_attribute21, xu.ha_attribute22, xu.ha_attribute23, xu.ha_attribute24, xu.ha_attribute25, xu.ha_attribute26, xu.ha_attribute27, xu.ha_attribute28, xu.ha_attribute29, xu.ha_attribute30, nvl(xxen_util.meaning(grvr.recipe_use,'GMD_FORMULA_USE',552), xu.validity_rule_use) validity_rule_use, nvl((select mp2.organization_code from mtl_parameters mp2 where mp2.organization_id=grvr.organization_id), xu.validity_organization_code) validity_organization_code, nvl((select msiv.concatenated_segments from mtl_system_items_vl msiv where msiv.inventory_item_id=grvr.inventory_item_id and msiv.organization_id=grcv.owner_organization_id), xu.product) product, nvl(grvr.revision, xu.vr_revision) vr_revision, nvl(grvr.preference, xu.preference) preference, nvl(grvr.std_qty, xu.standard_quantity) standard_quantity, nvl(grvr.min_qty, xu.minimum_quantity) minimum_quantity, nvl(grvr.max_qty, xu.maximum_quantity) maximum_quantity, nvl(grvr.detail_uom, xu.vr_detail_uom) vr_detail_uom, nvl(grvr.start_date, xu.start_date) start_date, nvl(grvr.end_date, xu.end_date) end_date, nvl(grvr.planned_process_loss, xu.vr_planned_process_loss) vr_planned_process_loss, nvl(grvr.fixed_process_loss, xu.vr_fixed_process_loss) vr_fixed_process_loss, nvl(grvr.fixed_process_loss_uom, xu.vr_fixed_process_loss_uom) vr_fixed_process_loss_uom, nvl(xxen_util.display_flexfield_context(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category), xu.va_attribute_category) va_attribute_category, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE1',grvr.rowid,grvr.attribute1), xu.va_attribute1) va_attribute1, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE2',grvr.rowid,grvr.attribute2), xu.va_attribute2) va_attribute2, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE3',grvr.rowid,grvr.attribute3), xu.va_attribute3) va_attribute3, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE4',grvr.rowid,grvr.attribute4), xu.va_attribute4) va_attribute4, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE5',grvr.rowid,grvr.attribute5), xu.va_attribute5) va_attribute5, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE6',grvr.rowid,grvr.attribute6), xu.va_attribute6) va_attribute6, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE7',grvr.rowid,grvr.attribute7), xu.va_attribute7) va_attribute7, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE8',grvr.rowid,grvr.attribute8), xu.va_attribute8) va_attribute8, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE9',grvr.rowid,grvr.attribute9), xu.va_attribute9) va_attribute9, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE10',grvr.rowid,grvr.attribute10), xu.va_attribute10) va_attribute10, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE11',grvr.rowid,grvr.attribute11), xu.va_attribute11) va_attribute11, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE12',grvr.rowid,grvr.attribute12), xu.va_attribute12) va_attribute12, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE13',grvr.rowid,grvr.attribute13), xu.va_attribute13) va_attribute13, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE14',grvr.rowid,grvr.attribute14), xu.va_attribute14) va_attribute14, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE15',grvr.rowid,grvr.attribute15), xu.va_attribute15) va_attribute15, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE16',grvr.rowid,grvr.attribute16), xu.va_attribute16) va_attribute16, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE17',grvr.rowid,grvr.attribute17), xu.va_attribute17) va_attribute17, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE18',grvr.rowid,grvr.attribute18), xu.va_attribute18) va_attribute18, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE19',grvr.rowid,grvr.attribute19), xu.va_attribute19) va_attribute19, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE20',grvr.rowid,grvr.attribute20), xu.va_attribute20) va_attribute20, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE21',grvr.rowid,grvr.attribute21), xu.va_attribute21) va_attribute21, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE22',grvr.rowid,grvr.attribute22), xu.va_attribute22) va_attribute22, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE23',grvr.rowid,grvr.attribute23), xu.va_attribute23) va_attribute23, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE24',grvr.rowid,grvr.attribute24), xu.va_attribute24) va_attribute24, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE25',grvr.rowid,grvr.attribute25), xu.va_attribute25) va_attribute25, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE26',grvr.rowid,grvr.attribute26), xu.va_attribute26) va_attribute26, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE27',grvr.rowid,grvr.attribute27), xu.va_attribute27) va_attribute27, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE28',grvr.rowid,grvr.attribute28), xu.va_attribute28) va_attribute28, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE29',grvr.rowid,grvr.attribute29), xu.va_attribute29) va_attribute29, nvl(xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE30',grvr.rowid,grvr.attribute30), xu.va_attribute30) va_attribute30, xu.step, xu.operation, xu.operation_version, xu.step_quantity, xu.operation_yield, xu.material_line_type, xu.material_item, xu.minimum_transfer_quantity, xu.minimum_delay, xu.maximum_delay, xu.sub_organization_code, xu.process_loss, xu.pl_fixed_process_loss, xu.pl_fixed_process_loss_uom, xu.pl_contiguous, xu.customer, xu.operation_line, xu.activity_factor, xu.resource_code, xu.resource_usage, xu.usage_uom, xu.process_quantity, xu.process_uom, xu.minimum_capacity, xu.maximum_capacity, xu.process_parameter_1, xu.process_parameter_2, xu.process_parameter_3, xu.process_parameter_4, xu.process_parameter_5, nvl(grcv.recipe_id, xu.recipe_id) recipe_id, nvl(grvr.recipe_validity_rule_id, xu.validity_rule_id) validity_rule_id, xu.routing_step_id, xu.formulaline_id, xu.recipe_process_loss_id from xxen_opm_recipe_upload_3936_u xu, mtl_parameters mp, gmd_recipes_vl grcv, gmd_recipe_validity_rules grvr where xu.row_type='Validity Rule' and mp.organization_code(+)=xu.organization_code and grcv.recipe_no(+)=upper(xu.recipe) and grcv.recipe_version(+)=xu.recipe_version and grcv.owner_organization_id(+)=mp.organization_id and grvr.recipe_validity_rule_id(+)=xu.validity_rule_id and xu.status_code_=xxen_upload.status_success union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_row, nvl(mp.organization_code, xu.organization_code) organization_code, nvl(grcv.recipe_no, xu.recipe) recipe, nvl(grcv.recipe_version, xu.recipe_version) recipe_version, xu.row_type, xu.creation_organization_code, xu.recipe_description, xu.formula, xu.formula_version, xu.routing, xu.routing_version, xu.recipe_type, xu.recipe_status, xu.planned_process_loss, xu.fixed_process_loss, xu.fixed_process_loss_uom, xu.recipe_yield, xu.contiguous, xu.enhanced_process_instructions, xu.calculate_step_quantity, xu.owner, xu.ha_attribute_category, xu.ha_attribute1, xu.ha_attribute2, xu.ha_attribute3, xu.ha_attribute4, xu.ha_attribute5, xu.ha_attribute6, xu.ha_attribute7, xu.ha_attribute8, xu.ha_attribute9, xu.ha_attribute10, xu.ha_attribute11, xu.ha_attribute12, xu.ha_attribute13, xu.ha_attribute14, xu.ha_attribute15, xu.ha_attribute16, xu.ha_attribute17, xu.ha_attribute18, xu.ha_attribute19, xu.ha_attribute20, xu.ha_attribute21, xu.ha_attribute22, xu.ha_attribute23, xu.ha_attribute24, xu.ha_attribute25, xu.ha_attribute26, xu.ha_attribute27, xu.ha_attribute28, xu.ha_attribute29, xu.ha_attribute30, xu.validity_rule_use, xu.validity_organization_code, xu.product, xu.vr_revision, xu.preference, xu.standard_quantity, xu.minimum_quantity, xu.maximum_quantity, xu.vr_detail_uom, xu.start_date, xu.end_date, xu.vr_planned_process_loss, xu.vr_fixed_process_loss, xu.vr_fixed_process_loss_uom, xu.va_attribute_category, xu.va_attribute1, xu.va_attribute2, xu.va_attribute3, xu.va_attribute4, xu.va_attribute5, xu.va_attribute6, xu.va_attribute7, xu.va_attribute8, xu.va_attribute9, xu.va_attribute10, xu.va_attribute11, xu.va_attribute12, xu.va_attribute13, xu.va_attribute14, xu.va_attribute15, xu.va_attribute16, xu.va_attribute17, xu.va_attribute18, xu.va_attribute19, xu.va_attribute20, xu.va_attribute21, xu.va_attribute22, xu.va_attribute23, xu.va_attribute24, xu.va_attribute25, xu.va_attribute26, xu.va_attribute27, xu.va_attribute28, xu.va_attribute29, xu.va_attribute30, nvl(frd.routingstep_no, xu.step) step, nvl((select gov.oprn_no from gmd_operations_vl gov where gov.oprn_id=frd.oprn_id), xu.operation) operation, nvl((select gov.oprn_vers from gmd_operations_vl gov where gov.oprn_id=frd.oprn_id), xu.operation_version) operation_version, nvl(grrs.step_qty, xu.step_quantity) step_quantity, nvl(grrs.oprn_yield, xu.operation_yield) operation_yield, xu.material_line_type, xu.material_item, xu.minimum_transfer_quantity, xu.minimum_delay, xu.maximum_delay, xu.sub_organization_code, xu.process_loss, xu.pl_fixed_process_loss, xu.pl_fixed_process_loss_uom, xu.pl_contiguous, xu.customer, xu.operation_line, xu.activity_factor, xu.resource_code, xu.resource_usage, xu.usage_uom, xu.process_quantity, xu.process_uom, xu.minimum_capacity, xu.maximum_capacity, xu.process_parameter_1, xu.process_parameter_2, xu.process_parameter_3, xu.process_parameter_4, xu.process_parameter_5, nvl(grcv.recipe_id, xu.recipe_id) recipe_id, xu.validity_rule_id, nvl(frd.routingstep_id, xu.routing_step_id) routing_step_id, xu.formulaline_id, xu.recipe_process_loss_id from xxen_opm_recipe_upload_3936_u xu, mtl_parameters mp, gmd_recipes_vl grcv, fm_rout_dtl frd, gmd_recipe_routing_steps grrs where xu.row_type='Routing Step' and mp.organization_code(+)=xu.organization_code and grcv.recipe_no(+)=upper(xu.recipe) and grcv.recipe_version(+)=xu.recipe_version and grcv.owner_organization_id(+)=mp.organization_id and frd.routingstep_id(+)=xu.routing_step_id and grrs.recipe_id(+)=grcv.recipe_id and grrs.routingstep_id(+)=frd.routingstep_id and xu.status_code_=xxen_upload.status_success union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_row, nvl(mp.organization_code, xu.organization_code) organization_code, nvl(grcv.recipe_no, xu.recipe) recipe, nvl(grcv.recipe_version, xu.recipe_version) recipe_version, xu.row_type, xu.creation_organization_code, xu.recipe_description, xu.formula, xu.formula_version, xu.routing, xu.routing_version, xu.recipe_type, xu.recipe_status, xu.planned_process_loss, xu.fixed_process_loss, xu.fixed_process_loss_uom, xu.recipe_yield, xu.contiguous, xu.enhanced_process_instructions, xu.calculate_step_quantity, xu.owner, xu.ha_attribute_category, xu.ha_attribute1, xu.ha_attribute2, xu.ha_attribute3, xu.ha_attribute4, xu.ha_attribute5, xu.ha_attribute6, xu.ha_attribute7, xu.ha_attribute8, xu.ha_attribute9, xu.ha_attribute10, xu.ha_attribute11, xu.ha_attribute12, xu.ha_attribute13, xu.ha_attribute14, xu.ha_attribute15, xu.ha_attribute16, xu.ha_attribute17, xu.ha_attribute18, xu.ha_attribute19, xu.ha_attribute20, xu.ha_attribute21, xu.ha_attribute22, xu.ha_attribute23, xu.ha_attribute24, xu.ha_attribute25, xu.ha_attribute26, xu.ha_attribute27, xu.ha_attribute28, xu.ha_attribute29, xu.ha_attribute30, xu.validity_rule_use, xu.validity_organization_code, xu.product, xu.vr_revision, xu.preference, xu.standard_quantity, xu.minimum_quantity, xu.maximum_quantity, xu.vr_detail_uom, xu.start_date, xu.end_date, xu.vr_planned_process_loss, xu.vr_fixed_process_loss, xu.vr_fixed_process_loss_uom, xu.va_attribute_category, xu.va_attribute1, xu.va_attribute2, xu.va_attribute3, xu.va_attribute4, xu.va_attribute5, xu.va_attribute6, xu.va_attribute7, xu.va_attribute8, xu.va_attribute9, xu.va_attribute10, xu.va_attribute11, xu.va_attribute12, xu.va_attribute13, xu.va_attribute14, xu.va_attribute15, xu.va_attribute16, xu.va_attribute17, xu.va_attribute18, xu.va_attribute19, xu.va_attribute20, xu.va_attribute21, xu.va_attribute22, xu.va_attribute23, xu.va_attribute24, xu.va_attribute25, xu.va_attribute26, xu.va_attribute27, xu.va_attribute28, xu.va_attribute29, xu.va_attribute30, nvl((select frd.routingstep_no from fm_rout_dtl frd where frd.routingstep_id=grsm.routingstep_id), xu.step) step, xu.operation, xu.operation_version, xu.step_quantity, xu.operation_yield, nvl((select xxen_util.meaning(to_char(fmd.line_type),'GMD_FORMULA_ITEM_TYPE',552) from fm_matl_dtl fmd where fmd.formulaline_id=grsm.formulaline_id), xu.material_line_type) material_line_type, nvl((select msiv.concatenated_segments from fm_matl_dtl fmd, mtl_system_items_vl msiv where fmd.formulaline_id=grsm.formulaline_id and msiv.inventory_item_id=fmd.inventory_item_id and msiv.organization_id=fmd.organization_id), xu.material_item) material_item, nvl(grsm.minimum_transfer_qty, xu.minimum_transfer_quantity) minimum_transfer_quantity, nvl(grsm.minimum_delay, xu.minimum_delay) minimum_delay, nvl(grsm.maximum_delay, xu.maximum_delay) maximum_delay, xu.sub_organization_code, xu.process_loss, xu.pl_fixed_process_loss, xu.pl_fixed_process_loss_uom, xu.pl_contiguous, xu.customer, xu.operation_line, xu.activity_factor, xu.resource_code, xu.resource_usage, xu.usage_uom, xu.process_quantity, xu.process_uom, xu.minimum_capacity, xu.maximum_capacity, xu.process_parameter_1, xu.process_parameter_2, xu.process_parameter_3, xu.process_parameter_4, xu.process_parameter_5, nvl(grcv.recipe_id, xu.recipe_id) recipe_id, xu.validity_rule_id, nvl(grsm.routingstep_id, xu.routing_step_id) routing_step_id, nvl(grsm.formulaline_id, xu.formulaline_id) formulaline_id, xu.recipe_process_loss_id from xxen_opm_recipe_upload_3936_u xu, mtl_parameters mp, gmd_recipes_vl grcv, gmd_recipe_step_materials grsm where xu.row_type='Step Material' and mp.organization_code(+)=xu.organization_code and grcv.recipe_no(+)=upper(xu.recipe) and grcv.recipe_version(+)=xu.recipe_version and grcv.owner_organization_id(+)=mp.organization_id and grsm.recipe_id(+)=grcv.recipe_id and grsm.formulaline_id(+)=xu.formulaline_id and grsm.routingstep_id(+)=xu.routing_step_id and xu.status_code_=xxen_upload.status_success union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_row, nvl(mp.organization_code, xu.organization_code) organization_code, nvl(grcv.recipe_no, xu.recipe) recipe, nvl(grcv.recipe_version, xu.recipe_version) recipe_version, xu.row_type, xu.creation_organization_code, xu.recipe_description, xu.formula, xu.formula_version, xu.routing, xu.routing_version, xu.recipe_type, xu.recipe_status, xu.planned_process_loss, xu.fixed_process_loss, xu.fixed_process_loss_uom, xu.recipe_yield, xu.contiguous, xu.enhanced_process_instructions, xu.calculate_step_quantity, xu.owner, xu.ha_attribute_category, xu.ha_attribute1, xu.ha_attribute2, xu.ha_attribute3, xu.ha_attribute4, xu.ha_attribute5, xu.ha_attribute6, xu.ha_attribute7, xu.ha_attribute8, xu.ha_attribute9, xu.ha_attribute10, xu.ha_attribute11, xu.ha_attribute12, xu.ha_attribute13, xu.ha_attribute14, xu.ha_attribute15, xu.ha_attribute16, xu.ha_attribute17, xu.ha_attribute18, xu.ha_attribute19, xu.ha_attribute20, xu.ha_attribute21, xu.ha_attribute22, xu.ha_attribute23, xu.ha_attribute24, xu.ha_attribute25, xu.ha_attribute26, xu.ha_attribute27, xu.ha_attribute28, xu.ha_attribute29, xu.ha_attribute30, xu.validity_rule_use, xu.validity_organization_code, xu.product, xu.vr_revision, xu.preference, xu.standard_quantity, xu.minimum_quantity, xu.maximum_quantity, xu.vr_detail_uom, xu.start_date, xu.end_date, xu.vr_planned_process_loss, xu.vr_fixed_process_loss, xu.vr_fixed_process_loss_uom, xu.va_attribute_category, xu.va_attribute1, xu.va_attribute2, xu.va_attribute3, xu.va_attribute4, xu.va_attribute5, xu.va_attribute6, xu.va_attribute7, xu.va_attribute8, xu.va_attribute9, xu.va_attribute10, xu.va_attribute11, xu.va_attribute12, xu.va_attribute13, xu.va_attribute14, xu.va_attribute15, xu.va_attribute16, xu.va_attribute17, xu.va_attribute18, xu.va_attribute19, xu.va_attribute20, xu.va_attribute21, xu.va_attribute22, xu.va_attribute23, xu.va_attribute24, xu.va_attribute25, xu.va_attribute26, xu.va_attribute27, xu.va_attribute28, xu.va_attribute29, xu.va_attribute30, xu.step, xu.operation, xu.operation_version, xu.step_quantity, xu.operation_yield, xu.material_line_type, xu.material_item, xu.minimum_transfer_quantity, xu.minimum_delay, xu.maximum_delay, nvl(grpl.orgn_code, xu.sub_organization_code) sub_organization_code, nvl(grpl.process_loss, xu.process_loss) process_loss, nvl(grpl.fixed_process_loss, xu.pl_fixed_process_loss) pl_fixed_process_loss, nvl(grpl.fixed_process_loss_uom, xu.pl_fixed_process_loss_uom) pl_fixed_process_loss_uom, nvl(xxen_util.meaning(decode(grpl.contiguous_ind,1,'Y','N'),'YES_NO',0), xu.pl_contiguous) pl_contiguous, xu.customer, xu.operation_line, xu.activity_factor, xu.resource_code, xu.resource_usage, xu.usage_uom, xu.process_quantity, xu.process_uom, xu.minimum_capacity, xu.maximum_capacity, xu.process_parameter_1, xu.process_parameter_2, xu.process_parameter_3, xu.process_parameter_4, xu.process_parameter_5, nvl(grcv.recipe_id, xu.recipe_id) recipe_id, xu.validity_rule_id, xu.routing_step_id, xu.formulaline_id, nvl(grpl.recipe_process_loss_id, xu.recipe_process_loss_id) recipe_process_loss_id from xxen_opm_recipe_upload_3936_u xu, mtl_parameters mp, gmd_recipes_vl grcv, gmd_recipe_process_loss grpl where xu.row_type='Process Loss' and mp.organization_code(+)=xu.organization_code and grcv.recipe_no(+)=upper(xu.recipe) and grcv.recipe_version(+)=xu.recipe_version and grcv.owner_organization_id(+)=mp.organization_id and grpl.recipe_process_loss_id(+)=xu.recipe_process_loss_id and xu.status_code_=xxen_upload.status_success union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_row, nvl(mp.organization_code, xu.organization_code) organization_code, nvl(grcv.recipe_no, xu.recipe) recipe, nvl(grcv.recipe_version, xu.recipe_version) recipe_version, xu.row_type, xu.creation_organization_code, xu.recipe_description, xu.formula, xu.formula_version, xu.routing, xu.routing_version, xu.recipe_type, xu.recipe_status, xu.planned_process_loss, xu.fixed_process_loss, xu.fixed_process_loss_uom, xu.recipe_yield, xu.contiguous, xu.enhanced_process_instructions, xu.calculate_step_quantity, xu.owner, xu.ha_attribute_category, xu.ha_attribute1, xu.ha_attribute2, xu.ha_attribute3, xu.ha_attribute4, xu.ha_attribute5, xu.ha_attribute6, xu.ha_attribute7, xu.ha_attribute8, xu.ha_attribute9, xu.ha_attribute10, xu.ha_attribute11, xu.ha_attribute12, xu.ha_attribute13, xu.ha_attribute14, xu.ha_attribute15, xu.ha_attribute16, xu.ha_attribute17, xu.ha_attribute18, xu.ha_attribute19, xu.ha_attribute20, xu.ha_attribute21, xu.ha_attribute22, xu.ha_attribute23, xu.ha_attribute24, xu.ha_attribute25, xu.ha_attribute26, xu.ha_attribute27, xu.ha_attribute28, xu.ha_attribute29, xu.ha_attribute30, xu.validity_rule_use, xu.validity_organization_code, xu.product, xu.vr_revision, xu.preference, xu.standard_quantity, xu.minimum_quantity, xu.maximum_quantity, xu.vr_detail_uom, xu.start_date, xu.end_date, xu.vr_planned_process_loss, xu.vr_fixed_process_loss, xu.vr_fixed_process_loss_uom, xu.va_attribute_category, xu.va_attribute1, xu.va_attribute2, xu.va_attribute3, xu.va_attribute4, xu.va_attribute5, xu.va_attribute6, xu.va_attribute7, xu.va_attribute8, xu.va_attribute9, xu.va_attribute10, xu.va_attribute11, xu.va_attribute12, xu.va_attribute13, xu.va_attribute14, xu.va_attribute15, xu.va_attribute16, xu.va_attribute17, xu.va_attribute18, xu.va_attribute19, xu.va_attribute20, xu.va_attribute21, xu.va_attribute22, xu.va_attribute23, xu.va_attribute24, xu.va_attribute25, xu.va_attribute26, xu.va_attribute27, xu.va_attribute28, xu.va_attribute29, xu.va_attribute30, xu.step, xu.operation, xu.operation_version, xu.step_quantity, xu.operation_yield, xu.material_line_type, xu.material_item, xu.minimum_transfer_quantity, xu.minimum_delay, xu.maximum_delay, xu.sub_organization_code, xu.process_loss, xu.pl_fixed_process_loss, xu.pl_fixed_process_loss_uom, xu.pl_contiguous, nvl((select hca_c.account_number from hz_cust_accounts hca_c where hca_c.cust_account_id=grc.customer_id), xu.customer) customer, xu.operation_line, xu.activity_factor, xu.resource_code, xu.resource_usage, xu.usage_uom, xu.process_quantity, xu.process_uom, xu.minimum_capacity, xu.maximum_capacity, xu.process_parameter_1, xu.process_parameter_2, xu.process_parameter_3, xu.process_parameter_4, xu.process_parameter_5, nvl(grcv.recipe_id, xu.recipe_id) recipe_id, xu.validity_rule_id, xu.routing_step_id, xu.formulaline_id, xu.recipe_process_loss_id from xxen_opm_recipe_upload_3936_u xu, mtl_parameters mp, gmd_recipes_vl grcv, hz_cust_accounts hca, gmd_recipe_customers grc where xu.row_type='Customer' and mp.organization_code(+)=xu.organization_code and grcv.recipe_no(+)=upper(xu.recipe) and grcv.recipe_version(+)=xu.recipe_version and grcv.owner_organization_id(+)=mp.organization_id and hca.account_number(+)=xu.customer and grc.recipe_id(+)=grcv.recipe_id and grc.customer_id(+)=hca.cust_account_id and xu.status_code_=xxen_upload.status_success union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_row, nvl(mp.organization_code, xu.organization_code) organization_code, nvl(grcv.recipe_no, xu.recipe) recipe, nvl(grcv.recipe_version, xu.recipe_version) recipe_version, xu.row_type, xu.creation_organization_code, xu.recipe_description, xu.formula, xu.formula_version, xu.routing, xu.routing_version, xu.recipe_type, xu.recipe_status, xu.planned_process_loss, xu.fixed_process_loss, xu.fixed_process_loss_uom, xu.recipe_yield, xu.contiguous, xu.enhanced_process_instructions, xu.calculate_step_quantity, xu.owner, xu.ha_attribute_category, xu.ha_attribute1, xu.ha_attribute2, xu.ha_attribute3, xu.ha_attribute4, xu.ha_attribute5, xu.ha_attribute6, xu.ha_attribute7, xu.ha_attribute8, xu.ha_attribute9, xu.ha_attribute10, xu.ha_attribute11, xu.ha_attribute12, xu.ha_attribute13, xu.ha_attribute14, xu.ha_attribute15, xu.ha_attribute16, xu.ha_attribute17, xu.ha_attribute18, xu.ha_attribute19, xu.ha_attribute20, xu.ha_attribute21, xu.ha_attribute22, xu.ha_attribute23, xu.ha_attribute24, xu.ha_attribute25, xu.ha_attribute26, xu.ha_attribute27, xu.ha_attribute28, xu.ha_attribute29, xu.ha_attribute30, xu.validity_rule_use, xu.validity_organization_code, xu.product, xu.vr_revision, xu.preference, xu.standard_quantity, xu.minimum_quantity, xu.maximum_quantity, xu.vr_detail_uom, xu.start_date, xu.end_date, xu.vr_planned_process_loss, xu.vr_fixed_process_loss, xu.vr_fixed_process_loss_uom, xu.va_attribute_category, xu.va_attribute1, xu.va_attribute2, xu.va_attribute3, xu.va_attribute4, xu.va_attribute5, xu.va_attribute6, xu.va_attribute7, xu.va_attribute8, xu.va_attribute9, xu.va_attribute10, xu.va_attribute11, xu.va_attribute12, xu.va_attribute13, xu.va_attribute14, xu.va_attribute15, xu.va_attribute16, xu.va_attribute17, xu.va_attribute18, xu.va_attribute19, xu.va_attribute20, xu.va_attribute21, xu.va_attribute22, xu.va_attribute23, xu.va_attribute24, xu.va_attribute25, xu.va_attribute26, xu.va_attribute27, xu.va_attribute28, xu.va_attribute29, xu.va_attribute30, nvl(frd.routingstep_no, xu.step) step, xu.operation, xu.operation_version, xu.step_quantity, xu.operation_yield, xu.material_line_type, xu.material_item, xu.minimum_transfer_quantity, xu.minimum_delay, xu.maximum_delay, nvl(groa.orgn_code, xu.sub_organization_code) sub_organization_code, xu.process_loss, xu.pl_fixed_process_loss, xu.pl_fixed_process_loss_uom, xu.pl_contiguous, xu.customer, nvl(goa.activity, xu.operation_line) operation_line, nvl(groa.activity_factor, xu.activity_factor) activity_factor, xu.resource_code, xu.resource_usage, xu.usage_uom, xu.process_quantity, xu.process_uom, xu.minimum_capacity, xu.maximum_capacity, xu.process_parameter_1, xu.process_parameter_2, xu.process_parameter_3, xu.process_parameter_4, xu.process_parameter_5, nvl(grcv.recipe_id, xu.recipe_id) recipe_id, xu.validity_rule_id, xu.routing_step_id, xu.formulaline_id, xu.recipe_process_loss_id from xxen_opm_recipe_upload_3936_u xu, mtl_parameters mp, gmd_recipes_vl grcv, fm_rout_dtl frd, gmd_operation_activities goa, gmd_recipe_orgn_activities groa where xu.row_type='Org Operation' and mp.organization_code(+)=xu.organization_code and grcv.recipe_no(+)=upper(xu.recipe) and grcv.recipe_version(+)=xu.recipe_version and grcv.owner_organization_id(+)=mp.organization_id and frd.routing_id(+)=grcv.routing_id and frd.routingstep_no(+)=xu.step and goa.oprn_id(+)=frd.oprn_id and goa.activity(+)=xu.operation_line and groa.recipe_id(+)=grcv.recipe_id and groa.routingstep_id(+)=frd.routingstep_id and groa.oprn_line_id(+)=goa.oprn_line_id and xu.status_code_=xxen_upload.status_success union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_row, nvl(mp.organization_code, xu.organization_code) organization_code, nvl(grcv.recipe_no, xu.recipe) recipe, nvl(grcv.recipe_version, xu.recipe_version) recipe_version, xu.row_type, xu.creation_organization_code, xu.recipe_description, xu.formula, xu.formula_version, xu.routing, xu.routing_version, xu.recipe_type, xu.recipe_status, xu.planned_process_loss, xu.fixed_process_loss, xu.fixed_process_loss_uom, xu.recipe_yield, xu.contiguous, xu.enhanced_process_instructions, xu.calculate_step_quantity, xu.owner, xu.ha_attribute_category, xu.ha_attribute1, xu.ha_attribute2, xu.ha_attribute3, xu.ha_attribute4, xu.ha_attribute5, xu.ha_attribute6, xu.ha_attribute7, xu.ha_attribute8, xu.ha_attribute9, xu.ha_attribute10, xu.ha_attribute11, xu.ha_attribute12, xu.ha_attribute13, xu.ha_attribute14, xu.ha_attribute15, xu.ha_attribute16, xu.ha_attribute17, xu.ha_attribute18, xu.ha_attribute19, xu.ha_attribute20, xu.ha_attribute21, xu.ha_attribute22, xu.ha_attribute23, xu.ha_attribute24, xu.ha_attribute25, xu.ha_attribute26, xu.ha_attribute27, xu.ha_attribute28, xu.ha_attribute29, xu.ha_attribute30, xu.validity_rule_use, xu.validity_organization_code, xu.product, xu.vr_revision, xu.preference, xu.standard_quantity, xu.minimum_quantity, xu.maximum_quantity, xu.vr_detail_uom, xu.start_date, xu.end_date, xu.vr_planned_process_loss, xu.vr_fixed_process_loss, xu.vr_fixed_process_loss_uom, xu.va_attribute_category, xu.va_attribute1, xu.va_attribute2, xu.va_attribute3, xu.va_attribute4, xu.va_attribute5, xu.va_attribute6, xu.va_attribute7, xu.va_attribute8, xu.va_attribute9, xu.va_attribute10, xu.va_attribute11, xu.va_attribute12, xu.va_attribute13, xu.va_attribute14, xu.va_attribute15, xu.va_attribute16, xu.va_attribute17, xu.va_attribute18, xu.va_attribute19, xu.va_attribute20, xu.va_attribute21, xu.va_attribute22, xu.va_attribute23, xu.va_attribute24, xu.va_attribute25, xu.va_attribute26, xu.va_attribute27, xu.va_attribute28, xu.va_attribute29, xu.va_attribute30, nvl(frd.routingstep_no, xu.step) step, xu.operation, xu.operation_version, xu.step_quantity, xu.operation_yield, xu.material_line_type, xu.material_item, xu.minimum_transfer_quantity, xu.minimum_delay, xu.maximum_delay, nvl(gror.orgn_code, xu.sub_organization_code) sub_organization_code, xu.process_loss, xu.pl_fixed_process_loss, xu.pl_fixed_process_loss_uom, xu.pl_contiguous, xu.customer, nvl(goa.activity, xu.operation_line) operation_line, xu.activity_factor, nvl(gror.resources, xu.resource_code) resource_code, nvl(gror.resource_usage, xu.resource_usage) resource_usage, nvl(gror.usage_uom, xu.usage_uom) usage_uom, nvl(gror.process_qty, xu.process_quantity) process_quantity, nvl(gror.process_um, xu.process_uom) process_uom, nvl(gror.min_capacity, xu.minimum_capacity) minimum_capacity, nvl(gror.max_capacity, xu.maximum_capacity) maximum_capacity, nvl(gror.process_parameter_1, xu.process_parameter_1) process_parameter_1, nvl(gror.process_parameter_2, xu.process_parameter_2) process_parameter_2, nvl(gror.process_parameter_3, xu.process_parameter_3) process_parameter_3, nvl(gror.process_parameter_4, xu.process_parameter_4) process_parameter_4, nvl(gror.process_parameter_5, xu.process_parameter_5) process_parameter_5, nvl(grcv.recipe_id, xu.recipe_id) recipe_id, xu.validity_rule_id, xu.routing_step_id, xu.formulaline_id, xu.recipe_process_loss_id from xxen_opm_recipe_upload_3936_u xu, mtl_parameters mp, gmd_recipes_vl grcv, fm_rout_dtl frd, gmd_operation_activities goa, gmd_recipe_orgn_resources gror where xu.row_type='Org Resource' and mp.organization_code(+)=xu.organization_code and grcv.recipe_no(+)=upper(xu.recipe) and grcv.recipe_version(+)=xu.recipe_version and grcv.owner_organization_id(+)=mp.organization_id and frd.routing_id(+)=grcv.routing_id and frd.routingstep_no(+)=xu.step and goa.oprn_id(+)=frd.oprn_id and goa.activity(+)=xu.operation_line and gror.recipe_id(+)=grcv.recipe_id and gror.routingstep_id(+)=frd.routingstep_id and gror.oprn_line_id(+)=goa.oprn_line_id and gror.resources(+)=xu.resource_code and xu.status_code_=xxen_upload.status_success