Description: |
This function fetches information about a stores requisition report (SRR) 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: |
'SRR Number: ' || l_srr_number || v_cr || 'SRR Create Date: ' || l_create_date || v_cr || 'SRR Type: ' || l_srr_type || v_cr || 'Created By: ' || l_created_by || v_cr || 'Received By: ' || l_received_by || v_cr || 'Issued By: ' || l_issued_by || v_cr || 'Work Order: ' || l_work_order || v_cr || 'Resv Requested By: ' || l_resv_request_by || v_cr || 'Delivery Date: ' || l_delivery_date || v_cr || 'Work Item: ' || l_work_package || v_cr || 'Expiry Date: ' || l_expiry_date || v_cr || 'MRR Number: ' || l_mrr_number || v_cr || 'MRR Revision: ' || l_mrr_revision || v_cr || 'MRR Posted Date: ' || l_mrr_posted_date || 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; |