The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT WMT.ACCT_PERIOD_ID move_acct_period
, WMT.ATTRIBUTE_CATEGORY move_attribute_catagory
, WMT.ATTRIBUTE1 move_attribute1
, WMT.ATTRIBUTE2 move_attribute2
, WMT.ATTRIBUTE3 move_attribute3
, WMT.ATTRIBUTE4 move_attribute4
, WMT.ATTRIBUTE5 move_attribute5
, WMT.ATTRIBUTE6 move_attribute6
, WMT.ATTRIBUTE7 move_attribute7
, WMT.ATTRIBUTE8 move_attribute8
, WMT.ATTRIBUTE9 move_attribute9
, WMT.ATTRIBUTE10 move_attribute10
, WMT.ATTRIBUTE11 move_attribute11
, WMT.ATTRIBUTE12 move_attribute12
, WMT.ATTRIBUTE13 move_attribute13
, WMT.ATTRIBUTE14 move_attribute14
, WMT.ATTRIBUTE15 move_attribute15
, WMT.CREATED_BY move_created_by
, WMT.CREATION_DATE move_creation_date
-- , WMT.EMPLOYEE_ID move_employee_id
, MEV.FULL_NAME move_employee_id
, WMT.FM_OPERATION_SEQ_NUM move_fm_operation_seq_num
, WMT.FM_OPERATION_CODE move_fm_operation_code
, BD1.DEPARTMENT_CODE move_fm_department
, ML1.MEANING move_fm_intraoperation_step
, WMT.JOB_QUANTITY_SNAPSHOT move_job_quantity_snapshot
, WMT.LAST_UPDATED_BY move_last_updated_by
, WMT.LAST_UPDATE_DATE move_last_update_date
, WMT.LAST_UPDATE_LOGIN move_last_update_login
, WL.LINE_CODE move_line
, WMT.ORGANIZATION_ID move_organization_id
, MP.ORGANIZATION_CODE move_organization_code
, HAOU.NAME move_organization_name
, WMT.OVERCOMPLETION_PRIMARY_QTY move_overcomp_primary_quantity
, WMT.OVERCOMPLETION_TRANSACTION_QTY move_overcomp_txn_quantity
, WE.primary_item_id move_primary_item_id
, msik3.CONCATENATED_SEGMENTS move_primary_item
, WMT.PRIMARY_QUANTITY move_primary_quantity
, WMT.PRIMARY_UOM move_primary_uom
, WMT.QA_COLLECTION_ID move_qa_collection_id
, MTR.REASON_NAME move_reason
, WMT.REFERENCE move_reference
-- , WMT.SCRAP_ACCOUNT_ID move_scrap_account
, glcc.concatenated_segments move_scrap_account
, WMT.TO_OPERATION_SEQ_NUM move_to_operation_seq_num
, WMT.TO_OPERATION_CODE move_to_operation_code
, BD2.DEPARTMENT_CODE move_to_department
, ML2.MEANING move_to_intraoperation_step
, TO_CHAR(WMT.TRANSACTION_DATE, g_date_format_mask) move_transaction_date
, WMT.TRANSACTION_ID move_transaction_id
, WMT.TRANSACTION_QUANTITY move_transaction_quantity
, WMT.TRANSACTION_UOM move_transaction_uom
, WMT.WIP_ENTITY_ID wip_entity_id
, WE.WIP_ENTITY_NAME wip_job_name
, mfglkp2.meaning wip_job_type
, wipdj.start_quantity wip_job_start_quantity
, TO_CHAR(wipdj.scheduled_start_date, g_date_format_mask) wip_job_start_date
, TO_CHAR(wipdj.scheduled_completion_date, g_date_format_mask) wip_job_completion_date
, mmt.subinventory_code job_completion_subinventory
, inv_project.get_locsegs(mmt.locator_id, mmt.organization_id) job_completion_locator
FROM MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MTL_TRANSACTION_REASONS MTR
, BOM_DEPARTMENTS BD1
, BOM_DEPARTMENTS BD2
, WIP_ENTITIES WE
, WIP_LINES WL
, WIP_MOVE_TRANSACTIONS WMT
, WIP_DISCRETE_JOBS wipdj
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HAOU
, mtl_system_items_vl msik3
, MFG_LOOKUPS mfglkp2
, GL_CODE_COMBINATIONS_KFV glcc
, MTL_EMPLOYEES_VIEW MEV
, MTL_MATERIAL_TRANSACTIONS mmt
WHERE WMT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WMT.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND WMT.LINE_ID = WL.LINE_ID (+)
AND WMT.ORGANIZATION_ID = WL.ORGANIZATION_ID (+)
AND WMT.FM_DEPARTMENT_ID = BD1.DEPARTMENT_ID
AND ML1.LOOKUP_CODE = WMT.FM_INTRAOPERATION_STEP_TYPE
AND ML1.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND WMT.TO_DEPARTMENT_ID = BD2.DEPARTMENT_ID
AND ML2.LOOKUP_CODE = WMT.TO_INTRAOPERATION_STEP_TYPE
AND ML2.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND WMT.REASON_ID = MTR.REASON_ID (+)
AND WMT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND WMT.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND msik3.inventory_item_id(+) = WE.primary_item_id
AND msik3.organization_id(+) = WE.organization_id
AND wipdj.wip_entity_id(+) = WE.wip_entity_id
AND wipdj.organization_id(+) = WE.organization_id
AND mfglkp2.lookup_code(+) = wipdj.job_type
AND mfglkp2.lookup_type(+) = 'WIP_DISCRETE_JOB'
AND glcc.code_combination_id(+) = WMT.SCRAP_ACCOUNT_ID
AND MEV.ORGANIZATION_ID(+) = WMT.ORGANIZATION_ID
AND MEV.EMPLOYEE_ID(+) = WMT.EMPLOYEE_ID
AND mmt.MOVE_TRANSACTION_ID(+) = wmt.TRANSACTION_ID
AND mmt.INVENTORY_ITEM_ID(+) = wmt.PRIMARY_ITEM_ID
AND mmt.ORGANIZATION_ID(+) = wmt.ORGANIZATION_ID
AND mmt.TRANSACTION_SOURCE_ID(+) = wmt.WIP_ENTITY_ID
AND WMT.TRANSACTION_ID = p_transaction_id;
l_selected_fields inv_label.label_field_variable_tbl_type;
l_selected_fields_count NUMBER;
TRACE(' Getting selected fields ');
inv_label.get_variables_for_format(x_variables => l_selected_fields, x_variables_count => l_selected_fields_count
, p_format_id => p_label_type_info.default_format_id);
IF (l_selected_fields_count = 0)
OR(l_selected_fields.COUNT = 0) THEN
IF (l_debug = 1) THEN
TRACE('no fields defined for this format: ' || p_label_type_info.default_format_id || ',' || p_label_type_info.default_format_name);
TRACE(' Found variable defined for this format, count = ' || l_selected_fields_count);
/* insert a record into wms_label_requests entity to
call the label rules engine to get appropriate label */
inv_label.get_format_with_rule(
p_document_id => p_label_type_info.label_type_id
, p_label_format_id => p_label_type_info.manual_format_id
, p_organization_id => v_wip_move_lines_content.move_organization_id
, p_inventory_item_id => v_wip_move_lines_content.move_primary_item_id
, p_lpn_id => NULL -- Bug 5509692.
, p_last_update_date => SYSDATE
, p_last_updated_by => fnd_global.user_id
, p_creation_date => SYSDATE
, p_created_by => fnd_global.user_id
--, p_printer_name => l_printer-- Removed in R12: 4396558
, p_business_flow_code => p_label_type_info.business_flow_code
, x_return_status => l_return_status
, x_label_format_id => l_label_format_id
, x_label_format => l_label_format
, x_label_request_id => l_label_request_id
);
inv_label.get_variables_for_format(x_variables => l_selected_fields, x_variables_count => l_selected_fields_count
, p_format_id => l_label_format_id);
IF (l_selected_fields_count = 0)
OR(l_selected_fields.COUNT = 0) THEN
IF (l_debug = 1) THEN
TRACE('no fields defined for this format: ' || l_label_format || ',' || l_label_format_id);
TRACE(' Found selected_fields for format ' || l_label_format || ', num=' || l_selected_fields_count);
/* Loop for each selected fields, find the columns and write into the XML_content*/
FOR i IN 1 .. l_selected_fields.COUNT LOOP
IF (l_debug = 1) THEN
l_column_name_list := l_column_name_list || ',' || l_selected_fields(i).column_name;
IF (l_selected_fields(i).SQL_STMT IS NOT NULL AND l_selected_fields(i).column_name = 'sql_stmt') THEN
IF (l_debug = 1) THEN
trace('Custom Labels Trace [INVLA16B.pls]: ------------------------- REPORT BEGIN-------------------------------------');
trace('Custom Labels Trace [INVLA16B.pls]: LABEL_FIELD_ID : ' || l_selected_fields(i).label_field_id);
trace('Custom Labels Trace [INVLA16B.pls]: FIELD_VARIABLE_NAME : ' || l_selected_fields(i).variable_name);
trace('Custom Labels Trace [INVLA16B.pls]: COLUMN_NAME : ' || l_selected_fields(i).column_name);
trace('Custom Labels Trace [INVLA16B.pls]: SQL_STMT : ' || l_selected_fields(i).sql_stmt);
l_sql_stmt := l_selected_fields(i).sql_stmt;
|| l_selected_fields(i).variable_name
|| '">'
|| l_sql_stmt_result
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_acct_period' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_acct_period
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute_catagory' THEN
l_content_item_data :=
l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_wip_move_lines_content.move_attribute_catagory
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute1' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute1
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute2' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute2
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute3' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute3
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute4' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute4
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute5' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute5
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute6' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute6
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute7' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute7
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute8' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute8
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute9' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute9
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute10' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute10
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute11' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute11
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute12' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute12
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute13' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute13
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute14' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute14
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_attribute15' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_attribute15
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_created_by' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_created_by
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_creation_date' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_creation_date
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_employee' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_employee_id
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_fm_operation_seq_num' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_fm_operation_seq_num
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_fm_operation_code' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_fm_operation_code
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_fm_department' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_fm_department
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_fm_intraoperation_step' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_fm_intraoperation_step
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_job_quantity_snapshot' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_job_quantity_snapshot
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_last_updated_by' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_last_updated_by
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_last_update_date' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_last_update_date
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_last_update_login' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_last_update_login
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_line' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_line
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_organization_code' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_organization_code
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_organization_name' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_organization_name
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_overcomp_primary_quantity' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_overcomp_primary_quantity
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_overcomp_txn_quantity' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_overcomp_txn_quantity
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_primary_item' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_primary_item
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_primary_quantity' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_primary_quantity
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_primary_uom' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_primary_uom
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_qa_collection_id' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_qa_collection_id
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_reason' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_reason
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_reference' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_reference
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_scrap_account' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_scrap_account
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_to_operation_seq_num' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_to_operation_seq_num
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_to_operation_code' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_to_operation_code
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_to_department' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_to_department
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_to_intraoperation_step' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_to_intraoperation_step
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_transaction_date' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_transaction_date
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_transaction_id' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_transaction_id
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_transaction_quantity' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_transaction_quantity
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'move_transaction_uom' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.move_transaction_uom
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'wip_entity_id' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.wip_entity_id
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'job_name' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.wip_job_name
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'job_type' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.wip_job_type
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'job_qty' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.wip_job_start_quantity
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'job_scheduled_start_date' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.wip_job_start_date
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'job_scheduled_completion_date' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.wip_job_completion_date
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'job_completion_subinventory' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.job_completion_subinventory
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'job_completion_locator' THEN
l_content_item_data :=
l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_move_lines_content.job_completion_locator
|| variable_e;