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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 122EB41EEB574685A2F16692D7A22B2BY select null action_, null status_, null message_, null modified_columns_, null upload_mode, x.*, null upload_row from ( select mp.organization_code, xxen_util.meaning(nvl(bso.operation_type,1),'BOM_OPERATION_TYPE',700) operation_type, wl.line_code line, bso.operation_code, bso.operation_description, bd.department_code department, case when bso.line_id is not null and nvl(bso.operation_type,1) in (2,3) then bso.sequence_num end display_sequence, bso.minimum_transfer_quantity min_transfer_qty, xxen_util.meaning(bso.wms_task_type,'WMS_TASK_TYPES',700) task_type, bso.default_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where milk.organization_id=bso.organization_id and milk.inventory_location_id=bso.default_locator_id) default_locator, xxen_util.yes(case when bso.option_dependent_flag=1 then 'Y' end) option_dependent, xxen_util.yes(bso.value_added) value_added, xxen_util.yes(bso.critical_to_quality) critical_to_quality, xxen_util.yes(case when bso.count_point_type in (1) then 'Y' end) count_point, xxen_util.yes(case when bso.count_point_type in (1,3) then 'Y' end) autocharge, xxen_util.yes(case when bso.backflush_flag=1 then 'Y' end) backflush, xxen_util.meaning(bso.shutdown_type,'BOM_EAM_SHUTDOWN_TYPE',700) shutdown_type, bso.yield, xxen_util.yes(case when bso.operation_yield_enabled=1 then 'Y' end) operation_yield_enabled, xxen_util.yes(case when bso.check_skill=1 then 'Y' end) check_skill, bso.lowest_acceptable_yield, xxen_util.yes(case when bso.use_org_settings=1 then 'Y' end) use_org_settings, xxen_util.yes(case when bso.queue_mandatory_flag=1 then 'Y' end) queue_mandatory, xxen_util.yes(case when bso.run_mandatory_flag=1 then 'Y' end) run_mandatory, xxen_util.yes(case when bso.to_move_mandatory_flag=1 then 'Y' end) to_move_mandatory, xxen_util.yes(case when bso.show_next_op_by_default=1 then 'Y' end) default_for_move_to_next_op, xxen_util.yes(case when bso.show_scrap_code=1 then 'Y' end) show_scrap_codes, xxen_util.yes(case when bso.show_lot_attrib=1 then 'Y' end) show_lot_attrib, xxen_util.yes(case when bso.track_multiple_res_usage_dates=1 then 'Y' end) track_multi_res_dates, xxen_util.display_flexfield_context(702,'OPERATIONS',bso.attribute_category) op_attribute_category, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE1',null,bso.attribute1) op_attribute1, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE2',null,bso.attribute2) op_attribute2, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE3',null,bso.attribute3) op_attribute3, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE4',null,bso.attribute4) op_attribute4, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE5',null,bso.attribute5) op_attribute5, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE6',null,bso.attribute6) op_attribute6, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE7',null,bso.attribute7) op_attribute7, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE8',null,bso.attribute8) op_attribute8, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE9',null,bso.attribute9) op_attribute9, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE10',null,bso.attribute10) op_attribute10, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE11',null,bso.attribute11) op_attribute11, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE12',null,bso.attribute12) op_attribute12, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE13',null,bso.attribute13) op_attribute13, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE14',null,bso.attribute14) op_attribute14, xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE15',null,bso.attribute15) op_attribute15, null substitute_resource, bsor.resource_seq_num resource_seq, bsor.substitute_group_num substitute_group, to_number(null) replacement_group, br.resource_code, xxen_util.meaning(bsor.basis_type,'BOM_BASIS_TYPE',700) basis, bsor.usage_rate_or_amount usage_rate, bsor.usage_rate_or_amount_inverse inverse_rate, bsor.schedule_seq_num schedule_seq, xxen_util.meaning(bsor.schedule_flag,'BOM_RESOURCE_SCHEDULE_TYPE',700) schedule, bsor.assigned_units, xxen_util.yes(case when bsor.principle_flag=1 then 'Y' end) principal, cavv.activity, xxen_util.yes(case when bsor.standard_rate_flag=1 then 'Y' end) standard_rate, xxen_util.meaning(bsor.autocharge_type,'BOM_AUTOCHARGE_TYPE',700) charge_type, xxen_util.display_flexfield_context(702,'OPERATION_RESOURCES',bsor.attribute_category) rsc_attribute_category, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE1',null,bsor.attribute1) rsc_attribute1, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE2',null,bsor.attribute2) rsc_attribute2, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE3',null,bsor.attribute3) rsc_attribute3, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE4',null,bsor.attribute4) rsc_attribute4, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE5',null,bsor.attribute5) rsc_attribute5, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE6',null,bsor.attribute6) rsc_attribute6, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE7',null,bsor.attribute7) rsc_attribute7, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE8',null,bsor.attribute8) rsc_attribute8, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE9',null,bsor.attribute9) rsc_attribute9, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE10',null,bsor.attribute10) rsc_attribute10, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE11',null,bsor.attribute11) rsc_attribute11, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE12',null,bsor.attribute12) rsc_attribute12, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE13',null,bsor.attribute13) rsc_attribute13, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE14',null,bsor.attribute14) rsc_attribute14, xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE15',null,bsor.attribute15) rsc_attribute15, null delete_std_op, null delete_resource, bso.standard_operation_id, rowidtochar(bso.rowid) standard_operation_rowid, rowidtochar(bsor.rowid) std_op_resource_rowid, null std_op_sub_resource_rowid from mtl_parameters mp, bom_standard_operations bso, bom_departments bd, wip_lines wl, bom_std_op_resources bsor, bom_resources br, cst_activities_val_v cavv where mp.organization_id=bso.organization_id and mp.organization_code=:p_organization_code and bso.department_id=bd.department_id and bso.line_id=wl.line_id(+) and bso.standard_operation_id=bsor.standard_operation_id(+) and bsor.resource_id=br.resource_id(+) and bsor.activity_id=cavv.activity_id(+) and nvl(cavv.organization_id(+),bso.organization_id)=bso.organization_id and 1=1 union all select mp.organization_code, xxen_util.meaning(nvl(bso.operation_type,1),'BOM_OPERATION_TYPE',700) operation_type, wl.line_code line, bso.operation_code, bso.operation_description, bd.department_code department, case when bso.line_id is not null and nvl(bso.operation_type,1) in (2,3) then bso.sequence_num end, bso.minimum_transfer_quantity, xxen_util.meaning(bso.wms_task_type,'WMS_TASK_TYPES',700), bso.default_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where milk.organization_id=bso.organization_id and milk.inventory_location_id=bso.default_locator_id), xxen_util.yes(case when bso.option_dependent_flag=1 then 'Y' end), xxen_util.yes(bso.value_added), xxen_util.yes(bso.critical_to_quality), xxen_util.yes(case when bso.count_point_type in (1) then 'Y' end), xxen_util.yes(case when bso.count_point_type in (1,3) then 'Y' end), xxen_util.yes(case when bso.backflush_flag=1 then 'Y' end), xxen_util.meaning(bso.shutdown_type,'BOM_EAM_SHUTDOWN_TYPE',700), bso.yield, xxen_util.yes(case when bso.operation_yield_enabled=1 then 'Y' end), xxen_util.yes(case when bso.check_skill=1 then 'Y' end), bso.lowest_acceptable_yield, xxen_util.yes(case when bso.use_org_settings=1 then 'Y' end), xxen_util.yes(case when bso.queue_mandatory_flag=1 then 'Y' end), xxen_util.yes(case when bso.run_mandatory_flag=1 then 'Y' end), xxen_util.yes(case when bso.to_move_mandatory_flag=1 then 'Y' end), xxen_util.yes(case when bso.show_next_op_by_default=1 then 'Y' end), xxen_util.yes(case when bso.show_scrap_code=1 then 'Y' end), xxen_util.yes(case when bso.show_lot_attrib=1 then 'Y' end), xxen_util.yes(case when bso.track_multiple_res_usage_dates=1 then 'Y' end), xxen_util.display_flexfield_context(702,'OPERATIONS',bso.attribute_category), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE1',null,bso.attribute1), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE2',null,bso.attribute2), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE3',null,bso.attribute3), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE4',null,bso.attribute4), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE5',null,bso.attribute5), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE6',null,bso.attribute6), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE7',null,bso.attribute7), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE8',null,bso.attribute8), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE9',null,bso.attribute9), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE10',null,bso.attribute10), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE11',null,bso.attribute11), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE12',null,bso.attribute12), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE13',null,bso.attribute13), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE14',null,bso.attribute14), xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE15',null,bso.attribute15), xxen_util.meaning('Y','YES_NO',0) substitute_resource, bssor.resource_id resource_seq, bssor.substitute_group_num substitute_group, bssor.replacement_group_num replacement_group, br.resource_code, xxen_util.meaning(bssor.basis_type,'BOM_BASIS_TYPE',700), bssor.usage_rate_or_amount, bssor.usage_rate_or_amount_inverse, bssor.schedule_seq_num, xxen_util.meaning(bssor.schedule_flag,'BOM_RESOURCE_SCHEDULE_TYPE',700), bssor.assigned_units, null principal, cavv.activity, xxen_util.yes(case when bssor.standard_rate_flag=1 then 'Y' end), xxen_util.meaning(bssor.autocharge_type,'BOM_AUTOCHARGE_TYPE',700), null rsc_attribute_category, null,null,null,null,null,null,null,null,null,null,null,null,null,null,null, null delete_std_op, null delete_resource, bso.standard_operation_id, rowidtochar(bso.rowid) standard_operation_rowid, null std_op_resource_rowid, rowidtochar(bssor.rowid) std_op_sub_resource_rowid from mtl_parameters mp, bom_standard_operations bso, bom_departments bd, wip_lines wl, bom_std_sub_op_resources bssor, bom_resources br, cst_activities_val_v cavv where mp.organization_id=bso.organization_id and mp.organization_code=:p_organization_code and bso.department_id=bd.department_id and bso.line_id=wl.line_id(+) and bso.standard_operation_id=bssor.standard_operation_id and bssor.resource_id=br.resource_id and bssor.activity_id=cavv.activity_id(+) and nvl(cavv.organization_id(+),bso.organization_id)=bso.organization_id and 1=1 ) x Report parameters: Organization Code now defaults from the MFG_ORGANIZATION_ID profile. The Standard Operation Type parameter was renamed to Manufacturing Mode (Flow vs Standard) to remove the confusion with Operation Type. Added download filters - Operation Code (multi-select, dependent on Organization Code / Manufacturing Mode / Operation Type), Operation Code like (free-text pattern), Department (multi-select, dependent on Organization Code) and Contains Resource (multi-select, dependent on Organization Code and, via department resources, Department). Contains Resource pulls in each matching standard operation in full - all resource and substitute rows - rather than only the specific resource line, and matches the resource whether it is used as a primary or a substitute resource. The Show Next Op Default column was renamed to Default for Move to Next Op to align with the form boiler-plate prompt; the upload API parameter p_show_next_op_default is unchanged. U A xxen_bom_upload.upload_std_op xxen_bom_upload.validate_std_op_excel_row (p_organization_code=>:$column$.organization_code ,p_operation_type=>:$column$.operation_type ,p_line=>:$column$.line ,p_display_sequence=>:$column$.display_sequence ,p_task_type=>:$column$.task_type ,p_default_subinventory=>:$column$.default_subinventory ,p_default_locator=>:$column$.default_locator ,p_value_added=>:$column$.value_added ,p_critical_to_quality=>:$column$.critical_to_quality ,p_count_point=>:$column$.count_point ,p_autocharge=>:$column$.autocharge ,p_backflush=>:$column$.backflush ,p_shutdown_type=>:$column$.shutdown_type ,p_yield=>:$column$.yield ,p_operation_yield_enabled=>:$column$.operation_yield_enabled ,p_check_skill=>:$column$.check_skill ,p_lowest_acceptable_yield=>:$column$.lowest_acceptable_yield ,p_use_org_settings=>:$column$.use_org_settings ,p_queue_mandatory=>:$column$.queue_mandatory ,p_run_mandatory=>:$column$.run_mandatory ,p_to_move_mandatory=>:$column$.to_move_mandatory ,p_show_next_op_default=>:$column$.default_for_move_to_next_op ,p_show_scrap_codes=>:$column$.show_scrap_codes ,p_show_lot_attrib=>:$column$.show_lot_attrib ,p_track_multi_res_dates=>:$column$.track_multi_res_dates ,p_resource_code=>:$column$.resource_code ,p_substitute_resource=>:$column$.substitute_resource ,p_replacement_group=>:$column$.replacement_group ,p_operation_code=>:$column$.operation_code ,p_department=>:$column$.department ) US BOM Standard Operations Upload Report: BOM Standard Operations Upload This upload can be used to create and/or update BOM Standard Operations. Standard operations are reusable operation templates that routings can reference. The upload covers: - Standard operation header (code, type, line, department, attributes, EAM and OSFM extensions) - Primary resource assignments to the standard operation - Substitute (alternate) resource assignments - Descriptive flexfield attributes on the header and primary resources Each Excel row represents one resource of a standard operation. Header columns repeat across resource rows of the same standard operation. To upload a standard operation with no resources, leave the Resource Code blank. To upload a substitute resource, set Substitute Resource to Yes and supply Substitute Group + Replacement Group. Standard operations are one of four types: discrete Standard (not tied to a production line), or Flow Event, Flow Process or Flow Line (each tied to a line). Many columns apply, default or are editable differently by operation type - for example Value Added and Critical to Quality can only be set to No on Flow Events, Count Point, Auto-charge and Backflush can only be set to No on discrete Standard operations, and Display Sequence applies only to Flow Process and Flow Line operations. Each affected column carries a cell comment describing its behaviour, and the supplied templates already show only the columns relevant to each type. Five templates are provided, one per operation type and scenario - pick the one matching the operation you are creating. Each shows only the columns relevant to that type, and the flow templates pre-set the Operation Type: - Discrete Standard Operation: a standard operation not tied to a production line. - Discrete Standard Operation - Shop Floor Management: the same, for OSFM/WSM-enabled organizations, additionally showing the Shop Floor Management fields (Operation Yield Enabled, Yield, Lowest Acceptable Yield, the Queue/Run/To Move Mandatory flags, Track Multiple Resource Usage Dates and the Show flags). - Flow Standard Events: a Flow Event operation tied to a production line. - Flow Standard Line Operations: a Flow Line operation tied to a production line. - Flow Standard Processes: a Flow Process operation tied to a production line. The download parameters control which operations are returned: Organization Code (defaults to your current manufacturing organization), Manufacturing Mode (Flow or Standard), Operation Type, Operation Code, Operation Code like (pattern search), Department and Contains Resource. Contains Resource returns each matching operation in full - all of its resource and substitute rows - so a resource is shown in the context of its whole operation rather than as an isolated line. Deletion is supported at two levels via the Delete Std Op and Delete Resource columns. Header delete cascades to resources, substitute resources, and OSFM child rows (bonus codes, scrap codes, responsibility exclusions). Header delete is blocked if the standard operation is referenced by an active routing operation or by a setup transition. Enginatics R12 only Upload 1=1 :p_organization_code 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 :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.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 mp.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') Y US Organization Code 3 30 1=1 bso.line_id is not null LOV custom Y select 1 id, 'Flow' value, null description from dual union all select 2 id, 'Standard' value, null description from dual order by id 1 US Manufacturing Mode Restrict the download to Flow standard operations (those tied to a production line) or to discrete Standard operations (no line). Leave blank to download both. 4 1=1 bso.line_id is null and nvl(bso.operation_type,1)=1 2 US Manufacturing Mode 5 40 1=1 bso.operation_type=:p_operation_type LOV custom Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='BOM_OPERATION_TYPE' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and :$flex$.Manufacturing_Mode=1 order by flvv.lookup_code US Operation Type Restrict downloaded Flow operations to a specific operation type: Event, Process or Line operation. Applies only when Manufacturing Mode is Flow. 6 50 1=1 bso.operation_code=:operation_code LOV custom Y select bso.operation_code id, bso.operation_code value, max(bso.operation_description) description from bom_standard_operations bso, mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code and bso.organization_id=mp.organization_id and (:$flex$.Manufacturing_Mode is null or :$flex$.Manufacturing_Mode=1 and bso.line_id is not null or :$flex$.Manufacturing_Mode=2 and bso.line_id is null and nvl(bso.operation_type,1)=1) and (:$flex$.Operation_Type is null or nvl(bso.operation_type,1)=:$flex$.Operation_Type) group by bso.operation_code order by bso.operation_code US Operation Code Restrict the download to specific standard operation codes. Supports multiple values. The list is filtered by Organization Code, and further by Manufacturing Mode and Operation Type when those are set. 7 60 1=1 bso.operation_code like :operation_code_like Char US Operation Code like Restrict the download to operation codes matching a pattern, for example ABC%. Use % as the wildcard. 8 70 1=1 bd.department_code=:department LOV custom Y select bd.department_code id, bd.department_code value, bd.description from bom_departments bd, mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code and bd.organization_id=mp.organization_id order by bd.department_code US Department Restrict the download to operations in specific departments. Supports multiple values. The list is filtered by Organization Code. 9 80 1=1 bso.standard_operation_id in (select r.standard_operation_id from (select bsor2.standard_operation_id, bsor2.resource_id from bom_std_op_resources bsor2 union all select bssor2.standard_operation_id, bssor2.resource_id from bom_std_sub_op_resources bssor2) r, bom_resources br2 where r.resource_id=br2.resource_id and br2.resource_code=:resource_code) LOV custom Y select br.resource_code id, br.resource_code value, br.description from bom_resources br, mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code and br.organization_id=mp.organization_id and (:$flex$.Department is null or exists ( select null from bom_department_resources bdr, bom_departments bd where bdr.resource_id=br.resource_id and bdr.department_id=bd.department_id and bd.organization_id=br.organization_id and xxen_util.contains(:$flex$.Department,bd.department_code)='Y' )) order by br.resource_code US Contains Resource Restrict the download to standard operations that use the selected resources, and pull in each such operation in full - all of its resource and substitute rows - so the resource is shown in context rather than as an isolated row. An operation is included when the resource is used as an assigned (primary) resource or as a substitute resource. Supports multiple values. The list is filtered by Organization Code, and by the selected Departments (via their assigned resources) when Department is set. 573C985DDF9C365EE0630100007FA71F Discrete Standard Operation Discrete Standard Operations ERIC.CLEGG 24 ACTIVITY 20 ASSIGNED_UNITS 9 AUTOCHARGE 10 BACKFLUSH 17 BASIS 26 CHARGE_TYPE 11 CHECK_SKILL 8 COUNT_POINT 28 DELETE_RESOURCE 27 DELETE_STD_OP 4 DEPARTMENT 19 INVERSE_RATE 5 MIN_TRANSFER_QTY 2 OPERATION_CODE 3 OPERATION_DESCRIPTION Y 7 OPTION_DEPENDENT 1 ORGANIZATION_CODE 23 PRINCIPAL 15 REPLACEMENT_GROUP 16 RESOURCE_CODE 13 RESOURCE_SEQ 22 SCHEDULE 21 SCHEDULE_SEQ 25 STANDARD_RATE 14 SUBSTITUTE_GROUP 12 SUBSTITUTE_RESOURCE 6 TASK_TYPE 18 USAGE_RATE Manufacturing Mode 2 Y S Site Operation Type 573C985DDF9D365EE0630100007FA71F Discrete Standard Operation - Shop Floor Management Discrete Standard Operations for Shop Floor Management enabled Organizations ERIC.CLEGG 36 ACTIVITY 32 ASSIGNED_UNITS 9 AUTOCHARGE 10 BACKFLUSH 29 BASIS 38 CHARGE_TYPE 11 CHECK_SKILL 8 COUNT_POINT 19 DEFAULT_FOR_MOVE_TO_NEXT_OP 23 DEFAULT_LOCATOR 22 DEFAULT_SUBINVENTORY 40 DELETE_RESOURCE 39 DELETE_STD_OP 4 DEPARTMENT 31 INVERSE_RATE 14 LOWEST_ACCEPTABLE_YIELD 5 MIN_TRANSFER_QTY 2 OPERATION_CODE 3 OPERATION_DESCRIPTION Y 13 OPERATION_YIELD_ENABLED 7 OPTION_DEPENDENT 1 ORGANIZATION_CODE 35 PRINCIPAL 16 QUEUE_MANDATORY 27 REPLACEMENT_GROUP 28 RESOURCE_CODE 25 RESOURCE_SEQ 17 RUN_MANDATORY 34 SCHEDULE 33 SCHEDULE_SEQ 20 SHOW_LOT_ATTRIB 21 SHOW_SCRAP_CODES 37 STANDARD_RATE 26 SUBSTITUTE_GROUP 24 SUBSTITUTE_RESOURCE 6 TASK_TYPE 18 TO_MOVE_MANDATORY 30 USAGE_RATE 15 USE_ORG_SETTINGS 12 YIELD Manufacturing Mode 2 Y S Site Operation Type 573C985DDF9E365EE0630100007FA71F Flow Standard Events Flow Standard Events ERIC.CLEGG 22 ACTIVITY 18 ASSIGNED_UNITS 15 BASIS 24 CHARGE_TYPE 10 CRITICAL_TO_QUALITY 26 DELETE_RESOURCE 25 DELETE_STD_OP 6 DEPARTMENT Y 17 INVERSE_RATE 3 LINE Y 7 MIN_TRANSFER_QTY 4 OPERATION_CODE 5 OPERATION_DESCRIPTION Y 2 OPERATION_TYPE Y Event 11 OPTION_DEPENDENT 1 ORGANIZATION_CODE 21 PRINCIPAL 14 RESOURCE_CODE 12 RESOURCE_SEQ 20 SCHEDULE 19 SCHEDULE_SEQ 23 STANDARD_RATE 13 SUBSTITUTE_GROUP 8 TASK_TYPE 16 USAGE_RATE 9 VALUE_ADDED Manufacturing Mode 1 Y Operation Type 1 Y S Site 573C985DDFA0365EE0630100007FA71F Flow Standard Line Operations Flow Standard Line Operations ERIC.CLEGG 11 DEFAULT_LOCATOR 10 DEFAULT_SUBINVENTORY 13 DELETE_STD_OP 6 DEPARTMENT 7 DISPLAY_SEQUENCE 3 LINE Y 8 MIN_TRANSFER_QTY 4 OPERATION_CODE 5 OPERATION_DESCRIPTION Y 2 OPERATION_TYPE Y Line operation 12 OPTION_DEPENDENT 1 ORGANIZATION_CODE 9 TASK_TYPE Manufacturing Mode 1 Y Operation Type 3 Y S Site 573C985DDF9F365EE0630100007FA71F Flow Standard Processes Flow Standard Processes ERIC.CLEGG 11 DEFAULT_LOCATOR 10 DEFAULT_SUBINVENTORY 13 DELETE_STD_OP 6 DEPARTMENT 7 DISPLAY_SEQUENCE 3 LINE Y 8 MIN_TRANSFER_QTY 4 OPERATION_CODE 5 OPERATION_DESCRIPTION Y 2 OPERATION_TYPE Y Process 12 OPTION_DEPENDENT 1 ORGANIZATION_CODE 9 TASK_TYPE Manufacturing Mode 1 Y Operation Type 2 Y S Site ERIC.CLEGG 573C985DDF9F365EE0630100007FA71F ANDY.HAACK 573C985DDF9F365EE0630100007FA71F 573C985DDF9C365EE0630100007FA71F 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 UPLOAD_MODE Char varchar2 :$flex$.upload_mode Y 6 ORGANIZATION_CODE LOV custom varchar2 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.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 mp.organization_code :$flex$.organization_code Y Y 7 OPERATION_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='BOM_OPERATION_TYPE' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code select xxen_util.meaning(1,'BOM_OPERATION_TYPE',700) from dual Y 8 LINE LOV custom varchar2 Y select wl.line_id id, wl.line_code value, wl.description from wip_lines wl, mtl_parameters mp where wl.organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and nvl(wl.disable_date,trunc(sysdate+1))>trunc(sysdate) order by wl.line_code Y 9 OPERATION_CODE Char varchar2 Y 10 OPERATION_DESCRIPTION Char varchar2 11 DEPARTMENT LOV custom varchar2 Y select bdvv.department_id id, bdvv.department_code value, bdvv.description from bom_departments_val_v bdvv, mtl_parameters mp where bdvv.organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code order by bdvv.department_code Editable only for Flow Process and Flow Line operations. On discrete Standard and Flow Event operations the department cannot be changed once the operation exists. Y 12 DISPLAY_SEQUENCE Number number Applies only to Flow Process and Flow Line operations. Leave blank for discrete Standard and Flow Event operations. 13 MIN_TRANSFER_QTY Number number 14 TASK_TYPE LOV custom varchar2 Y select ml.lookup_code id, ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='WMS_TASK_TYPES' order by to_number(ml.lookup_code) 15 DEFAULT_SUBINVENTORY LOV custom varchar2 Y select msi.secondary_inventory_name value, msi.description from mtl_secondary_inventories msi, mtl_parameters mp where msi.organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and nvl(msi.disable_date,trunc(sysdate+1))>trunc(sysdate) order by msi.secondary_inventory_name Not applicable to Flow Event operations. On discrete Standard operations it also requires an OSFM/WSM-enabled organization. 16 DEFAULT_LOCATOR LOV custom varchar2 Y select milk.inventory_location_id id, milk.concatenated_segments value, milk.description from mtl_item_locations_kfv milk, mtl_parameters mp where milk.organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and milk.subinventory_code=:$column$.default_subinventory order by milk.concatenated_segments Not applicable to Flow Event operations. On discrete Standard operations it also requires an OSFM/WSM-enabled organization. 17 OPTION_DEPENDENT LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='SYS_YES_NO' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) select xxen_util.meaning('1','SYS_YES_NO',700) from dual where :$column$.standard_operation_id is null and :$column$.organization_code is not null 18 VALUE_ADDED LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code desc select xxen_util.meaning('Y','YES_NO',0) from dual where :$column$.standard_operation_id is null and :$column$.organization_code is not null Defaults to Yes. Can be set to No only on Flow Event operations; it is always Yes for discrete Standard, Flow Process and Flow Line operations. 19 CRITICAL_TO_QUALITY LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code desc select xxen_util.meaning('Y','YES_NO',0) from dual where :$column$.standard_operation_id is null and :$column$.organization_code is not null Defaults to Yes. Can be set to No only on Flow Event operations; it is always Yes for discrete Standard, Flow Process and Flow Line operations. 20 COUNT_POINT LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code desc select xxen_util.meaning('Y','YES_NO',0) from dual where :$column$.standard_operation_id is null and :$column$.organization_code is not null Defaults to Yes. Can be set to No only on discrete Standard operations; it is always Yes for Flow Event, Flow Process and Flow Line operations. 21 AUTOCHARGE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code desc select xxen_util.meaning('Y','YES_NO',0) from dual where :$column$.standard_operation_id is null and :$column$.organization_code is not null Defaults to Yes. Can be set to No only on discrete Standard operations; it is always Yes for Flow Event, Flow Process and Flow Line operations. 22 BACKFLUSH LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='SYS_YES_NO' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) select xxen_util.meaning('1','SYS_YES_NO',700) from dual where :$column$.standard_operation_id is null and :$column$.organization_code is not null Defaults to Yes. Can be set to No only on discrete Standard operations; it is always Yes for Flow Event, Flow Process and Flow Line operations. 23 SHUTDOWN_TYPE LOV custom varchar2 Y select ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='BOM_EAM_SHUTDOWN_TYPE' and ml.enabled_flag='Y' and nvl(ml.start_date_active,sysdate-1)<sysdate and nvl(ml.end_date_active,sysdate+1)>sysdate order by ml.lookup_code Applies only to discrete Standard operations in an eAM-enabled organization. 24 YIELD Number number Applies only to discrete Standard operations in an OSFM/WSM-enabled organization. 25 OPERATION_YIELD_ENABLED LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='SYS_YES_NO' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) select xxen_util.meaning('1','SYS_YES_NO',700) from dual where :$column$.standard_operation_id is null and :$column$.organization_code is not null Defaults to Yes; can only be set to No in an OSFM/WSM-enabled organization. 26 CHECK_SKILL LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='SYS_YES_NO' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) Applies only to discrete Standard operations. 27 LOWEST_ACCEPTABLE_YIELD Number number Applies only to discrete Standard operations in an OSFM/WSM-enabled organization. 28 USE_ORG_SETTINGS LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PMI_YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) desc select xxen_util.meaning('1','PMI_YES_NO',0) from dual where :$column$.standard_operation_id is null and :$column$.organization_code is not null Defaults to Yes; can only be set to No in an OSFM/WSM-enabled organization. 29 QUEUE_MANDATORY LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PMI_YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) desc Applies only to discrete Standard operations in an OSFM/WSM-enabled organization. 30 RUN_MANDATORY LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PMI_YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) desc Applies only to discrete Standard operations in an OSFM/WSM-enabled organization. 31 TO_MOVE_MANDATORY LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PMI_YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) desc Applies only to discrete Standard operations in an OSFM/WSM-enabled organization. 32 DEFAULT_FOR_MOVE_TO_NEXT_OP LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PMI_YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) desc select xxen_util.meaning('1','PMI_YES_NO',0) from dual where :$column$.standard_operation_id is null and :$column$.organization_code is not null Defaults to Yes; can only be set to No in an OSFM/WSM-enabled organization. 33 SHOW_SCRAP_CODES LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PMI_YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) desc select xxen_util.meaning('1','PMI_YES_NO',0) from dual where :$column$.standard_operation_id is null and :$column$.organization_code is not null Defaults to Yes; can only be set to No in an OSFM/WSM-enabled organization. 34 SHOW_LOT_ATTRIB LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PMI_YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) desc select xxen_util.meaning('1','PMI_YES_NO',0) from dual where :$column$.standard_operation_id is null and :$column$.organization_code is not null Defaults to Yes; can only be set to No in an OSFM/WSM-enabled organization. 35 TRACK_MULTI_RES_DATES LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PMI_YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) desc Applies only to discrete Standard operations in an OSFM/WSM-enabled organization. 36 OP_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcv.descriptive_flex_context_code!='Global Data Elements' order by fdfcv.descriptive_flex_context_name 37 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE1' 38 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE2' 39 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE3' 40 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE4' 41 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE5' 42 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE6' 43 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE7' 44 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE8' 45 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE9' 46 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE10' 47 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE11' 48 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE12' 49 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE13' 50 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE14' 51 OP_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 => 702, p_descriptive_flexfield_name => 'OPERATIONS', p_context_name => :$column$.op_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.op_attribute1, p_attribute2 => :$column$.op_attribute2, p_attribute3 => :$column$.op_attribute3, p_attribute4 => :$column$.op_attribute4, p_attribute5 => :$column$.op_attribute5, p_attribute6 => :$column$.op_attribute6, p_attribute7 => :$column$.op_attribute7, p_attribute8 => :$column$.op_attribute8, p_attribute9 => :$column$.op_attribute9, p_attribute10 => :$column$.op_attribute10, p_attribute11 => :$column$.op_attribute11, p_attribute12 => :$column$.op_attribute12, p_attribute13 => :$column$.op_attribute13, p_attribute14 => :$column$.op_attribute14, p_attribute15 => :$column$.op_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATIONS' and fdfcuv.application_column_name='ATTRIBUTE15' 52 SUBSTITUTE_RESOURCE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code desc Substitute resources apply to discrete Standard operations only. They cannot be entered for Flow Event, Flow Process or Flow Line operations. 53 RESOURCE_SEQ Number number 54 SUBSTITUTE_GROUP Number number 55 REPLACEMENT_GROUP Number number Required when Substitute Resource is Yes, and must be left blank for a primary resource. Substitute resources exist only on discrete Standard operations. 56 RESOURCE_CODE LOV custom varchar2 Y select br.resource_id id, br.resource_code value, br.description from bom_resources_val_v br, bom_department_resources bdr, bom_departments_val_v bdvv, mtl_parameters mp where br.resource_id=bdr.resource_id and bdr.department_id=bdvv.department_id and bdvv.organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and bdvv.department_code=:$column$.department and br.cost_code_type in (3,4) order by br.resource_code Resources apply to discrete Standard and Flow Event operations only. They cannot be entered for Flow Process or Flow Line operations. 57 BASIS LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='BOM_BASIS_TYPE' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code select xxen_util.meaning(br.default_basis_type,'BOM_BASIS_TYPE',700) from bom_resources br, mtl_parameters mp where mp.organization_code=:$column$.organization_code and br.organization_id=mp.organization_id and br.resource_code=:$column$.resource_code and :$column$.std_op_resource_rowid is null 58 USAGE_RATE Number number 59 INVERSE_RATE Number number select round(1/:$column$.usage_rate,nvl(fnd_profile.value('BOM:ROUND_OFF_VALUE'),6)) from dual where nvl(:$column$.usage_rate,0)<>0 60 SCHEDULE_SEQ Number number 61 SCHEDULE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='BOM_RESOURCE_SCHEDULE_TYPE' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code select xxen_util.meaning('2','BOM_RESOURCE_SCHEDULE_TYPE',700) from dual where :$column$.resource_code is not null 62 ASSIGNED_UNITS Number number select 1 from dual where :$column$.resource_code is not null 63 PRINCIPAL LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='SYS_YES_NO' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) 64 ACTIVITY LOV custom varchar2 Y select cavv.activity_id id, cavv.activity value, cavv.description from cst_activities_val_v cavv, mtl_parameters mp where mp.organization_code=:$column$.organization_code and nvl(cavv.organization_id,mp.organization_id)=mp.organization_id order by cavv.activity select cavv.activity from bom_resources br, cst_activities_val_v cavv, mtl_parameters mp where mp.organization_code=:$column$.organization_code and br.organization_id=mp.organization_id and br.resource_code=:$column$.resource_code and cavv.activity_id=br.default_activity_id and :$column$.std_op_resource_rowid is null 65 STANDARD_RATE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='SYS_YES_NO' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.lookup_code='2' or exists (select null from bom_resources br, mtl_parameters mp where mp.organization_code=:$column$.organization_code and br.organization_id=mp.organization_id and br.resource_code=:$column$.resource_code and br.standard_rate_flag=1)) order by to_number(flvv.lookup_code) select case when br.standard_rate_flag=1 then xxen_util.meaning('1','SYS_YES_NO',700) end from bom_resources br, mtl_parameters mp where mp.organization_code=:$column$.organization_code and br.organization_id=mp.organization_id and br.resource_code=:$column$.resource_code and :$column$.std_op_resource_rowid is null 66 CHARGE_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='BOM_AUTOCHARGE_TYPE' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code select xxen_util.meaning(br.autocharge_type,'BOM_AUTOCHARGE_TYPE',700) from bom_resources br, mtl_parameters mp where mp.organization_code=:$column$.organization_code and br.organization_id=mp.organization_id and br.resource_code=:$column$.resource_code and :$column$.std_op_resource_rowid is null 67 RSC_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcv.descriptive_flex_context_code!='Global Data Elements' order by fdfcv.descriptive_flex_context_name 68 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE1' 69 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE2' 70 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE3' 71 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE4' 72 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE5' 73 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE6' 74 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE7' 75 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE8' 76 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE9' 77 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE10' 78 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE11' 79 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE12' 80 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE13' 81 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE14' 82 RSC_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 => 702, p_descriptive_flexfield_name => 'OPERATION_RESOURCES', p_context_name => :$column$.rsc_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.rsc_attribute1, p_attribute2 => :$column$.rsc_attribute2, p_attribute3 => :$column$.rsc_attribute3, p_attribute4 => :$column$.rsc_attribute4, p_attribute5 => :$column$.rsc_attribute5, p_attribute6 => :$column$.rsc_attribute6, p_attribute7 => :$column$.rsc_attribute7, p_attribute8 => :$column$.rsc_attribute8, p_attribute9 => :$column$.rsc_attribute9, p_attribute10 => :$column$.rsc_attribute10, p_attribute11 => :$column$.rsc_attribute11, p_attribute12 => :$column$.rsc_attribute12, p_attribute13 => :$column$.rsc_attribute13, p_attribute14 => :$column$.rsc_attribute14, p_attribute15 => :$column$.rsc_attribute15 ) ) 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=702 and fdfv.descriptive_flexfield_name='OPERATION_RESOURCES' and fdfcuv.application_column_name='ATTRIBUTE15' 83 DELETE_STD_OP LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 84 DELETE_RESOURCE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 85 STANDARD_OPERATION_ID Number number Y 86 STANDARD_OPERATION_ROWID Char varchar2 Y 87 STD_OP_RESOURCE_ROWID Char varchar2 Y 88 STD_OP_SUB_RESOURCE_ROWID Char varchar2 Y 89 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 10 p_organization_code in Char ORGANIZATION_CODE U 11 p_operation_type in Char OPERATION_TYPE U 12 p_line in Char LINE U 13 p_operation_code in Char OPERATION_CODE U 14 p_operation_description in Char OPERATION_DESCRIPTION U 15 p_department in Char DEPARTMENT U 16 p_display_sequence in Number DISPLAY_SEQUENCE U 17 p_min_transfer_qty in Number MIN_TRANSFER_QTY U 18 p_task_type in Char TASK_TYPE U 19 p_default_subinventory in Char DEFAULT_SUBINVENTORY U 20 p_default_locator in Char DEFAULT_LOCATOR U 21 p_option_dependent in Char OPTION_DEPENDENT U 22 p_value_added in Char VALUE_ADDED U 23 p_critical_to_quality in Char CRITICAL_TO_QUALITY U 24 p_count_point in Char COUNT_POINT U 25 p_autocharge in Char AUTOCHARGE U 26 p_backflush in Char BACKFLUSH U 27 p_shutdown_type in Char SHUTDOWN_TYPE U 28 p_yield in Number YIELD U 29 p_operation_yield_enabled in Char OPERATION_YIELD_ENABLED U 30 p_check_skill in Char CHECK_SKILL U 31 p_lowest_acceptable_yield in Number LOWEST_ACCEPTABLE_YIELD U 32 p_use_org_settings in Char USE_ORG_SETTINGS U 33 p_queue_mandatory in Char QUEUE_MANDATORY U 34 p_run_mandatory in Char RUN_MANDATORY U 35 p_to_move_mandatory in Char TO_MOVE_MANDATORY U 36 p_show_next_op_default in Char DEFAULT_FOR_MOVE_TO_NEXT_OP U 37 p_show_scrap_codes in Char SHOW_SCRAP_CODES U 38 p_show_lot_attrib in Char SHOW_LOT_ATTRIB U 39 p_track_multi_res_dates in Char TRACK_MULTI_RES_DATES U 40 p_op_attribute_category in Char OP_ATTRIBUTE_CATEGORY U 41 p_op_attribute1 in Char OP_ATTRIBUTE1 U 42 p_op_attribute2 in Char OP_ATTRIBUTE2 U 43 p_op_attribute3 in Char OP_ATTRIBUTE3 U 44 p_op_attribute4 in Char OP_ATTRIBUTE4 U 45 p_op_attribute5 in Char OP_ATTRIBUTE5 U 46 p_op_attribute6 in Char OP_ATTRIBUTE6 U 47 p_op_attribute7 in Char OP_ATTRIBUTE7 U 48 p_op_attribute8 in Char OP_ATTRIBUTE8 U 49 p_op_attribute9 in Char OP_ATTRIBUTE9 U 50 p_op_attribute10 in Char OP_ATTRIBUTE10 U 51 p_op_attribute11 in Char OP_ATTRIBUTE11 U 52 p_op_attribute12 in Char OP_ATTRIBUTE12 U 53 p_op_attribute13 in Char OP_ATTRIBUTE13 U 54 p_op_attribute14 in Char OP_ATTRIBUTE14 U 55 p_op_attribute15 in Char OP_ATTRIBUTE15 U 56 p_substitute_resource in Char SUBSTITUTE_RESOURCE U 57 p_resource_seq in Number RESOURCE_SEQ U 58 p_substitute_group in Number SUBSTITUTE_GROUP U 59 p_replacement_group in Number REPLACEMENT_GROUP U 60 p_resource_code in Char RESOURCE_CODE U 61 p_basis in Char BASIS U 62 p_usage_rate in Number USAGE_RATE U 63 p_inverse_rate in Number INVERSE_RATE U 64 p_schedule_seq in Number SCHEDULE_SEQ U 65 p_schedule in Char SCHEDULE U 66 p_assigned_units in Number ASSIGNED_UNITS U 67 p_principal in Char PRINCIPAL U 68 p_activity in Char ACTIVITY U 69 p_standard_rate in Char STANDARD_RATE U 70 p_charge_type in Char CHARGE_TYPE U 71 p_rsc_attribute_category in Char RSC_ATTRIBUTE_CATEGORY U 72 p_rsc_attribute1 in Char RSC_ATTRIBUTE1 U 73 p_rsc_attribute2 in Char RSC_ATTRIBUTE2 U 74 p_rsc_attribute3 in Char RSC_ATTRIBUTE3 U 75 p_rsc_attribute4 in Char RSC_ATTRIBUTE4 U 76 p_rsc_attribute5 in Char RSC_ATTRIBUTE5 U 77 p_rsc_attribute6 in Char RSC_ATTRIBUTE6 U 78 p_rsc_attribute7 in Char RSC_ATTRIBUTE7 U 79 p_rsc_attribute8 in Char RSC_ATTRIBUTE8 U 80 p_rsc_attribute9 in Char RSC_ATTRIBUTE9 U 81 p_rsc_attribute10 in Char RSC_ATTRIBUTE10 U 82 p_rsc_attribute11 in Char RSC_ATTRIBUTE11 U 83 p_rsc_attribute12 in Char RSC_ATTRIBUTE12 U 84 p_rsc_attribute13 in Char RSC_ATTRIBUTE13 U 85 p_rsc_attribute14 in Char RSC_ATTRIBUTE14 U 86 p_rsc_attribute15 in Char RSC_ATTRIBUTE15 U 87 p_delete_std_op in Char DELETE_STD_OP U 88 p_delete_resource in Char DELETE_RESOURCE U 89 p_standard_operation_id in Number STANDARD_OPERATION_ID U 90 p_std_op_sub_resource_rowid in Char STD_OP_SUB_RESOURCE_ROWID U 91 p_standard_operation_row_id out Char STANDARD_OPERATION_ROWID U 92 p_std_op_resource_row_id out Char STD_OP_RESOURCE_ROWID U 93 p_std_op_sub_resource_row_id out Char STD_OP_SUB_RESOURCE_ROWID Error SQL Order By upload_row, organization_code, operation_type, line, operation_code, nvl2(substitute_resource,2,1), resource_seq, substitute_group, replacement_group Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_mode, nvl2(bso.rowid,mp.organization_code,xu.organization_code) organization_code, nvl2(bso.rowid,xxen_util.meaning(nvl(bso.operation_type,1),'BOM_OPERATION_TYPE',700),xu.operation_type) operation_type, nvl2(bso.rowid,wl.line_code,xu.line) line, nvl2(bso.rowid,bso.operation_code,xu.operation_code) operation_code, nvl2(bso.rowid,bso.operation_description,xu.operation_description) operation_description, nvl2(bso.rowid,bd.department_code,xu.department) department, nvl2(bso.rowid,bso.sequence_num,xu.display_sequence) display_sequence, nvl2(bso.rowid,bso.minimum_transfer_quantity,xu.min_transfer_qty) min_transfer_qty, nvl2(bso.rowid,xxen_util.meaning(bso.wms_task_type,'WMS_TASK_TYPES',700),xu.task_type) task_type, nvl2(bso.rowid,bso.default_subinventory,xu.default_subinventory) default_subinventory, nvl2(bso.rowid,(select milk.concatenated_segments from mtl_item_locations_kfv milk where milk.organization_id=bso.organization_id and milk.inventory_location_id=bso.default_locator_id),xu.default_locator) default_locator, nvl2(bso.rowid,xxen_util.yes(case when bso.option_dependent_flag=1 then 'Y' end),xu.option_dependent) option_dependent, nvl2(bso.rowid,xxen_util.yes(bso.value_added),xu.value_added) value_added, nvl2(bso.rowid,xxen_util.yes(bso.critical_to_quality),xu.critical_to_quality) critical_to_quality, nvl2(bso.rowid,xxen_util.yes(case when bso.count_point_type in (1) then 'Y' end),xu.count_point) count_point, nvl2(bso.rowid,xxen_util.yes(case when bso.count_point_type in (1,3) then 'Y' end),xu.autocharge) autocharge, nvl2(bso.rowid,xxen_util.yes(case when bso.backflush_flag=1 then 'Y' end),xu.backflush) backflush, nvl2(bso.rowid,xxen_util.meaning(bso.shutdown_type,'BOM_EAM_SHUTDOWN_TYPE',700),xu.shutdown_type) shutdown_type, nvl2(bso.rowid,bso.yield,xu."YIELD") yield, nvl2(bso.rowid,xxen_util.yes(case when bso.operation_yield_enabled=1 then 'Y' end),xu.operation_yield_enabled) operation_yield_enabled, nvl2(bso.rowid,xxen_util.yes(case when bso.check_skill=1 then 'Y' end),xu.check_skill) check_skill, nvl2(bso.rowid,bso.lowest_acceptable_yield,xu.lowest_acceptable_yield) lowest_acceptable_yield, nvl2(bso.rowid,xxen_util.yes(case when bso.use_org_settings=1 then 'Y' end),xu.use_org_settings) use_org_settings, nvl2(bso.rowid,xxen_util.yes(case when bso.queue_mandatory_flag=1 then 'Y' end),xu.queue_mandatory) queue_mandatory, nvl2(bso.rowid,xxen_util.yes(case when bso.run_mandatory_flag=1 then 'Y' end),xu.run_mandatory) run_mandatory, nvl2(bso.rowid,xxen_util.yes(case when bso.to_move_mandatory_flag=1 then 'Y' end),xu.to_move_mandatory) to_move_mandatory, nvl2(bso.rowid,xxen_util.yes(case when bso.show_next_op_by_default=1 then 'Y' end),xu.default_for_move_to_next_op) default_for_move_to_next_op, nvl2(bso.rowid,xxen_util.yes(case when bso.show_scrap_code=1 then 'Y' end),xu.show_scrap_codes) show_scrap_codes, nvl2(bso.rowid,xxen_util.yes(case when bso.show_lot_attrib=1 then 'Y' end),xu.show_lot_attrib) show_lot_attrib, nvl2(bso.rowid,xxen_util.yes(case when bso.track_multiple_res_usage_dates=1 then 'Y' end),xu.track_multi_res_dates) track_multi_res_dates, nvl2(bso.rowid,xxen_util.display_flexfield_context(702,'OPERATIONS',bso.attribute_category),xu.op_attribute_category) op_attribute_category, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE1',null,bso.attribute1),xu.op_attribute1) op_attribute1, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE2',null,bso.attribute2),xu.op_attribute2) op_attribute2, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE3',null,bso.attribute3),xu.op_attribute3) op_attribute3, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE4',null,bso.attribute4),xu.op_attribute4) op_attribute4, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE5',null,bso.attribute5),xu.op_attribute5) op_attribute5, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE6',null,bso.attribute6),xu.op_attribute6) op_attribute6, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE7',null,bso.attribute7),xu.op_attribute7) op_attribute7, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE8',null,bso.attribute8),xu.op_attribute8) op_attribute8, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE9',null,bso.attribute9),xu.op_attribute9) op_attribute9, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE10',null,bso.attribute10),xu.op_attribute10) op_attribute10, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE11',null,bso.attribute11),xu.op_attribute11) op_attribute11, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE12',null,bso.attribute12),xu.op_attribute12) op_attribute12, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE13',null,bso.attribute13),xu.op_attribute13) op_attribute13, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE14',null,bso.attribute14),xu.op_attribute14) op_attribute14, nvl2(bso.rowid,xxen_util.display_flexfield_value(702,'OPERATIONS',bso.attribute_category,'ATTRIBUTE15',null,bso.attribute15),xu.op_attribute15) op_attribute15, xu.substitute_resource, nvl(nvl(bsor.resource_seq_num,bssor.resource_id),xu.resource_seq) resource_seq, nvl(nvl(bsor.substitute_group_num,bssor.substitute_group_num),xu.substitute_group) substitute_group, nvl(bssor.replacement_group_num,xu.replacement_group) replacement_group, nvl((select br.resource_code from bom_resources br where br.resource_id=nvl(bsor.resource_id,bssor.resource_id)),xu.resource_code) resource_code, nvl(xxen_util.meaning(nvl(bsor.basis_type,bssor.basis_type),'BOM_BASIS_TYPE',700),xu.basis) basis, nvl(nvl(bsor.usage_rate_or_amount,bssor.usage_rate_or_amount),xu.usage_rate) usage_rate, nvl(nvl(bsor.usage_rate_or_amount_inverse,bssor.usage_rate_or_amount_inverse),xu.inverse_rate) inverse_rate, nvl(nvl(bsor.schedule_seq_num,bssor.schedule_seq_num),xu.schedule_seq) schedule_seq, nvl(xxen_util.meaning(nvl(bsor.schedule_flag,bssor.schedule_flag),'BOM_RESOURCE_SCHEDULE_TYPE',700),xu.schedule) schedule, nvl(nvl(bsor.assigned_units,bssor.assigned_units),xu.assigned_units) assigned_units, nvl(xxen_util.yes(case when bsor.principle_flag=1 then 'Y' end),xu.principal) principal, nvl((select cavv.activity from cst_activities_val_v cavv where cavv.activity_id=nvl(bsor.activity_id,bssor.activity_id)),xu.activity) activity, nvl(xxen_util.yes(case when nvl(bsor.standard_rate_flag,bssor.standard_rate_flag)=1 then 'Y' end),xu.standard_rate) standard_rate, nvl(xxen_util.meaning(nvl(bsor.autocharge_type,bssor.autocharge_type),'BOM_AUTOCHARGE_TYPE',700),xu.charge_type) charge_type, nvl(xxen_util.display_flexfield_context(702,'OPERATION_RESOURCES',bsor.attribute_category),xu.rsc_attribute_category) rsc_attribute_category, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE1',null,bsor.attribute1),xu.rsc_attribute1) rsc_attribute1, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE2',null,bsor.attribute2),xu.rsc_attribute2) rsc_attribute2, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE3',null,bsor.attribute3),xu.rsc_attribute3) rsc_attribute3, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE4',null,bsor.attribute4),xu.rsc_attribute4) rsc_attribute4, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE5',null,bsor.attribute5),xu.rsc_attribute5) rsc_attribute5, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE6',null,bsor.attribute6),xu.rsc_attribute6) rsc_attribute6, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE7',null,bsor.attribute7),xu.rsc_attribute7) rsc_attribute7, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE8',null,bsor.attribute8),xu.rsc_attribute8) rsc_attribute8, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE9',null,bsor.attribute9),xu.rsc_attribute9) rsc_attribute9, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE10',null,bsor.attribute10),xu.rsc_attribute10) rsc_attribute10, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE11',null,bsor.attribute11),xu.rsc_attribute11) rsc_attribute11, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE12',null,bsor.attribute12),xu.rsc_attribute12) rsc_attribute12, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE13',null,bsor.attribute13),xu.rsc_attribute13) rsc_attribute13, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE14',null,bsor.attribute14),xu.rsc_attribute14) rsc_attribute14, nvl(xxen_util.display_flexfield_value(702,'OPERATION_RESOURCES',bsor.attribute_category,'ATTRIBUTE15',null,bsor.attribute15),xu.rsc_attribute15) rsc_attribute15, xu.delete_std_op, xu.delete_resource, nvl(bso.standard_operation_id,xu.standard_operation_id) standard_operation_id, nvl(rowidtochar(bso.rowid),xu.standard_operation_rowid) standard_operation_rowid, nvl(rowidtochar(bsor.rowid),xu.std_op_resource_rowid) std_op_resource_rowid, nvl(rowidtochar(bssor.rowid),xu.std_op_sub_resource_rowid) std_op_sub_resource_rowid, xu.upload_row from xxen_bom_standard_opera_5047_u xu, bom_standard_operations bso, mtl_parameters mp, bom_departments bd, wip_lines wl, bom_std_op_resources bsor, bom_std_sub_op_resources bssor where bso.rowid(+)=chartorowid(xu.standard_operation_rowid) and mp.organization_id(+)=bso.organization_id and bd.department_id(+)=bso.department_id and wl.line_id(+)=bso.line_id and bsor.rowid(+)=chartorowid(xu.std_op_resource_rowid) and bssor.rowid(+)=chartorowid(xu.std_op_sub_resource_rowid) and xu.status_code_=xxen_upload.status_success