Description: |
This function fetches information about a material issue report (MIR) and appends it to the approval email body. |
Type: |
Function |
Usage: |
Called by BUILD_APPORVAL_BODY CIP function |
Event: |
Select Ready for Approval, or click Approve button |
Default: |
'MIR Number: ' || l_mir_number || v_cr || 'Rev: ' || l_revision_id || v_cr || 'MIR Create Date: ' || l_create_date || v_cr || 'MIR Type: ' || l_mir_type || v_cr || 'Issue Date: ' || l_issue_date || v_cr || 'Issue By: ' || l_issue_by || v_cr || 'Reservation Code: ' || l_fah_code || v_cr || 'Run Number: ' || l_run_number || v_cr || 'Split Result: ' || l_split_result || v_cr || 'Company: ' || l_company_code || v_cr || 'Company Name: ' || l_company_name || v_cr || 'Overissue Warehouse: ' || l_wh_code || v_cr || 'Location: ' || l_loc_code || v_cr ||v_cr; |