Blitz Report™ Library

This library is a free open source SQL knowledge base for Oracle E-Business Suite customers and IT professionals. It contains SQLs that we created (category: Enginatics) and SQLs imported from Oracle’s BI Publisher reports (category: BI Publisher).

If you have Bitz Report installed, you can download a single or multiple reports as XML file from this library and automatically load them into your environment, including parameters, LOVs and category assignments.

If you would like to try one of these SQLs without having Blitz Report installed, as SQLs are composed dynamically at runtime, it is easiest to copy the query from the second tab of the example Excel sheet instead from the report’s detail page. Note that some of the reports require functions from utility package xxen_util.

To facilitate development work and help learning the EBS table structure, there are hyperlinks on each table to navigate directly to the corresponding Oracle ETRM record.

We also encourage you to contribute by adding your own SQL reports or suggesting enhancements and corrections to existing SQLs.
To add new reports, simply log in to our online demo environment, create a Blitz Report and it will automatically show up in this library (creation of a Blitz Report is shown here).

238 reports

DescriptionDownload
AP Supplier Upload
This upload can be used to create and/or update Suppliers, Supplier Sites, Supplier Bank Accounts, and Supplier Contacts Upload Mode Update only allows changes to existing Suppliers, Sites, Contacts and Bank Accounts. A row that would create any of them is rejected, including a bank or bank branch. Add Existing Bank Acct assigns a bank account the supplier already owns to another level, as the Add button on the supplier Banking Details page does. The account is assigned exactly as it stands, so the bank, branch and bank account columns are left blank on that row. The bank and branch…
full description
Enginatics, R12 only, Upload XML
AR AutoAccounting Upload
Creates and updates the Receivables AutoAccounting definitions - the Excel equivalent of the Automatic Accounting form (Setup > Transactions > AutoAccounting). Each row is one segment of the chart of accounts of an AutoAccounting type, with the operating unit and type repeated on every row. Enter either a Table Name, from which AutoAccounting takes the segment value, or a Constant. Each type is saved as a whole: after the upload, every enabled segment of the chart of accounts must have a table name or constant, and a dependent segment must use the table name of its parent segment or a…
full description
Enginatics, R12 only, Upload XML
AR Credit Memo Application Upload
Applies open on account credit memos to invoices and debit memos, and unapplies existing credit memo applications - the Applications action of the Transactions workbench (ar_cm_api_pub). The download lists the operating unit's open credit memos (Apply To Invoice empty) and their existing active applications (one row per application). To apply, enter Apply To Invoice on an open credit memo row. To unapply, set Unapply to Yes on an application row. An existing application cannot be changed in place: unapply it, then enter the new application on the credit memo's open row.
Enginatics, R12 only, Upload XML
AR Customer Statement
Application: Receivables Source: Customer Statement Short Name: ARSTMTRPT DB package: AR_TP_STMT_PKG When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, CGST Rate, SGST Rate, IGST Rate, CESS Rate, CGST Recoverable, CGST Non-Recoverable, SGST Recoverable, SGST Non-Recoverable, IGST Recoverable, IGST Non-Recoverable, Reverse Charge Flag, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code.
Enginatics, R12 only XML
AR HSBC FAA Asset File (France)
Extracts completed Receivables invoices and credit memos in the HSBC FACTORING FRANCE FAA file format, for invoice discounting. One 532 character record per document. The report is implemented from the HSBC specification document "HFF - Invoice Discounting - Asset File IT Protocol.pdf" dated 09/09/2025, and its output has been validated against both the field table in that document and the sample file supplied with it. The 31 zones are, in order, each followed by a semicolon: File type FAA (3), Seller account number (5), File creation date YYYYMMDDHHMM (12), Debtor's Seller Identifier (15),…
full description
Enginatics, R12 only XML
AR Refund Upload
Bulk-refund customer credit balances in AR. Each row refunds either an open credit memo or the unapplied/on-account portion of a customer cash receipt by applying it against the operating unit's Credit Memo Refund Receivables Activity, via AR_CM_APPLICATION_PUB.Activity_application or AR_RECEIPT_API_PUB.Activity_application. WHEN TO USE EACH REFUND SOURCE - Credit Memo - the customer has an open credit memo (e.g. overpayment recorded as a CM) and wants the money back. - Unapplied Receipt - the customer paid more than they owed, or paid against the account with no specific invoice. The…
full description
Enginatics, R12 only, Upload XML
AR Transaction Update Upload
Updates the post completion header fields of Receivables transactions in the same way as the Transactions workbench: comments, special instructions, print option, purchase order details, salesperson, remit to address, late charges exemption, ship via, FOB, waybill, cross reference and the transaction descriptive flexfield. The transaction is identified by Operating Unit and Transaction Number. A hidden transaction id links downloaded rows exactly; pasted rows resolve by number, and a number existing under more than one transaction source is rejected with a request to download the transaction…
full description
Enginatics, R12 only, Upload XML
AR Unaccounted Transaction Sweep
Imported from BI Publisher Application: Receivables Source: Unaccounted Transaction Sweep Short Name: ARTRXSWP DB package: ar_unaccounted_trx_sweep
BI Publisher, Enginatics, R12 only XML
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…
full description
Enginatics, R12 only, Upload XML
Blitz Report Assignment Upload
Upload to maintain Blitz Report assignments. The upload support creating, deleting or copying assignment and can be run with the following modes: -Create with 'Create Empty File'=Yes: Opens an empty Excel file to enter new assignments. -Create with 'Create Empty File'=blank: You can query a list of reports that you want create assignments for by report name, category or report type. -Create, Update: Allows querying existing assignments, which can be deleted, or copied to a different assignment level. A frequent use case for customers having custom responsibilities linked to custom…
full description
Enginatics, R12 only, Upload XML
Blitz Upload Example (Interface Table)
Sample upload to be used as a template by copying (Tools>Copy Report) to create new uploads using Interface Table.
Enginatics, R12 only, Upload XML
CAC AP Accrual Accounts Setup
Report to show the valid A/P Accrual Accounts which have been set up in the Select Accrual Accounts Form. Showing the Ledger, Operating Unit, Accrual Accounts, Creation Date, Created By and Last Updated By. The A/P Accrual Load Program uses these accounts to find the Payables, Receiving and Inventory accounting accrual entries for the A/P Accrual Load results. Parameters: =========== Operating Unit: enter the specific operating unit(s) you wish to report (optional). Ledger: enter the specific ledger(s) you wish to report (optional). /*…
full description
Enginatics, R12 only XML
CAC AP Accrual IR ISO Match Analysis
Use this report to match the A/P Accrual entries for internal order inventory receipts with the internal order payables invoices, by the internal sale order and line number. If run in Detail Mode, shows inventory receipts and payables invoices on separate lines with detailed information, if run in Summary Mode, the sales order line is summarized into one row. Parameters: =========== Report Mode: you can get a summary by sales order and line or a detailed report, enter Detail or Summary (mandatory). Transaction Date from: enter the IR/ISO beginning transaction date you wish to report…
full description
Enginatics, R12 only XML
CAC AP Accrual Reconciliation Load Request
Report to show when the A/P Accrual Reconciliation Load program was run and by whom, including the Ledger, Operating Unit, Build Id, Request Id, Creation Date and Last Updated By. Parameters: =========== Beginning Creation Date: enter the starting creation date to report, based on the operating unit for your session's inventory organization (optional). Operating Unit: enter the specific operating unit(s) you wish to report (optional). Ledger: enter the specific ledger(s) you wish to report (optional). /* +=============================================================================+ -- |…
full description
Enginatics, R12 only XML
CAC AP Accrual Reconciliation Summary by Match Type
Use this report to summarize the A/P Accrual entries from the Accrual Reconcilation Report tables, by operating unit, accrual match type and inventory organization. Use this report for summary reconciliation purposes, to justify the "at time of receipt" accrual balances for your inventory and expense A/P accrual accounts. Parameters: =========== Transaction Date From: enter the accrual starting transaction date you wish to report. Defaults to the earliest date found (mandatory). Transaction Date To: enter the accrual ending transaction date you wish to report. Defaults to the latest…
full description
Enginatics, R12 only XML
CAC Inventory Lot and Locator OPM Value (Period-End)
Report showing amount of inventory at the end of the month for Process Manufacturing (OPM) inventory organizations, for both onhand and intransit inventory. If you enter a cost type this report uses the item costs from the cost type; if you leave the cost type blank it uses the item costs from the month-end snapshot. In either case this report uses the month-end quantities, based on the entered period name, calendar code and period code. As these quantities come from the month-end snapshot, this also also allows you to specify the lot number and locator (row/rack/bin) for your onhand…
full description
Enginatics, R12 only XML
CAC Material Account Alias with Lot Numbers
Report to display the material account alias transactions by lot number. Specify Yes for Show Lot Number to split out the transaction quantities and amounts by transaction lot number. And if processed by Create Accounting, the Create Accounting column shows "Yes". Parameters: =========== Transaction Date From: enter the starting transaction date (mandatory). Transaction Date To: enter the ending transaction date (mandatory). Show Lot Number: enter Yes to see transactions by lot number, enter No to exclude lot information (mandatory). Account Alias: enter the account alias to report…
full description
Enginatics, R12 only XML
CAC OPM Batch Material Summary
Report showing Batch materials in summary for each product, byproduct and ingredient. Displaying batches which were open during the monthly inventory accounting period or batches which were closed during the monthly inventory accounting period. If you enter a cost type this report uses the item costs from the cost type; if you leave the cost type blank it uses the item costs from the month-end item costs. Parameters: ========== Period Name: enter the monthly inventory accounting period you wish to report (mandatory). Cost Type: enter a Cost Type to value the quantities using the Cost…
full description
Enginatics, R12 only XML
CAC OPM Costed Formula
eport showing OPM formulas and item costs, by OPM Cost Component Class. The report automatically displays the first thirty Cost Components, sorted by Usage Indicator (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc), then by the Cost Component Class. With the "Other Costs" column summing up any other non-displayed Cost Component Classes. For a different selection of Cost Component Classes, you may override any of the defaulted Cost Component Classes. If you have fewer than thirty Cost Components the report automatically displays "Not Available", for the succeeding Cost Component…
full description
Enginatics, R12 only XML
CAC OPM WIP Account Value
Report to show WIP values for process manufacturing (OPM), in summary by inventory organization and batch, with batch status, name and other details. The valuation accounts come from the cumulative WIP Valuation accounting entries, as processed by Create Accounting. Parameters: =========== Period Name: the inventory accounting period you wish to report (mandatory). Include Lab Batches: enter Yes to include laboratory batches. Enter No to exclude them. Defaults to No (mandatory). Show Batch Details: enter Yes to display the formula, routing and recipe numbers and versions. Defaults to…
full description
Enginatics, R12 only XML
CAC Recost Cost of Goods Sold
Report to compare the "as transacted" cost of goods sold (COGS) transactions in Oracle Inventory with the "what if" costs from a simulation cost type. Use this report when you need to make manual journal entry corrections to your COGS entries, due to incorrect item costs. In addition to reporting the normal COGS entries for the COGS Recognition, Sales Order Issue, RMA Receipt and RMA Return transactions, you can also report user-defined material transactions such as Account Issues/Receipts, Miscellaneous Issues/Receipts and Account Alias transactions which could represent COGS entries from…
full description
Enginatics, R12 only XML
CE Bank Statement Upload
CE Bank Statement Upload ======================== Loads bank statements (header and lines) into Oracle Cash Management through the bank statement open interface and runs Oracle's Bank Statement Import automatically after upload. Optionally, AutoReconciliation runs in the same step to match the imported statement lines against AR receipts, AP payments and GL journal lines according to the bank account's transaction codes and matching rules, in the same way as the standard 'Bank Statement Import & AutoReconciliation' concurrent program. Each row represents one statement line. Statement header…
full description
Enginatics, R12 only, Upload XML
CE Bank and Branch Upload
CE Bank and Branch Upload ========================== Creates or updates banks and bank branches in Oracle Cash Management (CE) using the ce_bank_pub API (TCA-based). Each row represents one bank branch. If the bank does not exist it is created automatically. The branch is then created or updated within that bank. Upload Mode =========== Create ------ Opens an empty spreadsheet to enter new banks and branches. Create, Update -------------- Returns existing bank branches. Edit fields and re-upload to update. Required Fields =============== - Country: Country of the bank (e.g. United…
full description
Enginatics, R12 only, Upload XML
CE Cash in Transit
Application: Cash Management Description: Cash in Transit Provides equivalent functionality to the following standard Oracle Forms/Reports - Cash in Transit Applicable Templates: - Pivot: Cash in Transit - Pivot: Bank Account Currency, Bank Account, In Transit Type, Operating Unit, Third Party (Supplier/Customer) with drill down to details - Cash In Transit Detail - Detail Extract Source: Cash in Transit (CEXCSHTR) DB package: CE_CEXCSHTR_XMLP_PKG (required to initialize security)
Enginatics, R12 only XML
CE Cleared Transactions
Application: Cash Management Description: Transactions - Cleared Payment/Receipt Transactions Provides equivalent functionality to the following standard Oracle Forms/Reports - Cleared Transactions Report Applicable Templates: Pivot: Cleared Transactions Summary Pivot: Cleared Batches Summary Source: Cleared Transactions Report (CEXCLEAR) DB package: CE_CEXCLEAR_XMLP_PKG (required to initialize security)
Enginatics, R12 only XML
CE Transactions Available for Reconciliation
Application: Cash Management Description: Transactions - Transactions Available for Reconciliation Provides equivalent functionality to the following standard Oracle Forms/Reports - Transactions Available for Reconciliation Report Applicable Templates: Pivot: Transactions Available by Bank Account, Source and Type Source: Transactions Available for Reconciliation Report (CEXAVTRX) DB package: CE_CEXSTMRR_XMLP_PKG (required to initialize security)
Enginatics, R12 only XML
CST Department Overhead Rate Upload
CST Department Overhead Rate Upload =================================== This upload can be used to - Upload new Department Overhead Rates - Download the current Department Overhead Rates for a Cost Type, update, and upload the amended rates - Download the current Department Overhead Rates from a Source Cost Type and upload them to a different Target Cost Type - Delete existing Department Overhead Rates Department Overhead Rates associate Overhead sub-elements with Departments and specify the rate or amount charged, per basis (Item, Lot, Resource Units, or Resource Value). The rates are…
full description
Enginatics, R12 only, Upload XML
CST Item Standard Cost Upload
CST Item Standard Cost Upload ============================= This upload can be used to - Upload New Item Costs - Download the current Item Costs, Update, and Upload the amended item costs for a specified Cost Type - Download the current item Costs from one Source cost type, update, and upload the amended item costs to a different Target Cost Type NOTE: You can only upload costs to cost types that are not flagged as frozen and are flagged as updateable. This upload is used for updating cost types using the standard costing method. Optionally, the upload can perform a Cost Rollup after the…
full description
Enginatics, R12 only, Upload XML
CST Resource Overhead Association Upload
CST Resource Overhead Association Upload ======================================== This upload can be used to - Upload new Resource Overhead Associations - Download the current Resource Overhead Associations for a Cost Type and upload them to a different Target Cost Type - Update the descriptive flexfield attributes of existing associations by re-uploading them in 'Remove and replace' mode - Delete existing Resource Overhead Associations Resource Overhead Associations link Resource or Outside Processing sub-elements to the Overhead or Material Overhead sub-elements they absorb. The…
full description
Enginatics, R12 only, Upload XML
CST Resource Rate Upload
CST Resource Rate Upload ======================== This upload can be used to - Upload new Resource Rates - Download the current Resource Rates for a Cost Type, update, and upload the amended rates - Download the current Resource Rates from a Source Cost Type and upload them to a different Target Cost Type - Delete existing Resource Rates Resource Rates apply to rate based Resource and Outside Processing sub-elements (sub-elements whose charge basis is not currency based). The rates are imported via the Oracle Cost Import Process. NOTE: You can only upload rates to cost types that are not…
full description
Enginatics, R12 only, Upload XML
EAM Asset Activity Association Upload
EAM Asset Activity Association Upload ===================================== - Create new associations between an Activity item and an Asset Group, specific Asset Number (serial instance), or Rebuildable item. - Update existing association attributes (dates, priority, owning department, WIP class, DFF, etc.). - Deletion is not supported by the public API in v1. Prerequisites ============= - The Activity item (eam_item_type=2) must already exist in the maintenance organization. Use the INV Item Upload to create Activity items. - For Asset Group associations, the Asset Group (eam_item_type=1)…
full description
Enginatics, R12 only, Upload XML
EAM Asset Number Upload
Create and update Oracle Enterprise Asset Management asset numbers (maintenance assets). Parent Asset Number places the asset in the asset hierarchy; clearing it on an existing asset removes the parent. Parent Asset Serial Number and Parent Asset Id follow the parent asset number and are read only. An existing asset is identified by its Asset Id, so its Asset Number can be changed. Current Location Address lists the addresses of the TCA locations, as the Update Asset page does; an address that exists more than once carries the location id in brackets.
Enginatics, R12 only, Upload XML
EAM Failure Codes Upload
Create, update, and delete EAM failure codes, cause codes, and resolution codes. Upload Mode =========== Create ------ Opens an empty spreadsheet to define new codes. Create, Update -------------- Downloads existing codes for review and modification, and allows adding new rows. Code Type ========= Determines which of the three code tables is affected: - Failure Code (stored in eam_failure_codes) - Cause Code (stored in eam_cause_codes) - Resolution Code (stored in eam_resolution_codes) Codes are global - not scoped to any operating unit. Fields ====== - Code Type: Required.…
full description
Enginatics, R12 only, Upload XML
EAM Failure Sets Upload
EAM Failure Sets Upload ======================= Creates and updates Oracle EAM (Enterprise Asset Management) Failure Sets, along with their Asset-Group Item Associations and Failure/Cause/Resolution Combinations. One Set Name can own many child rows (Associations and Combinations). A SET row defines the header explicitly. For Create rows, the upload also creates the missing failure set header automatically from the first ASSOCIATION or COMBINATION row for that Set Name. Row Type -------- - SET: Creates or updates the failure set header (set_name, description, effective_end_date). -…
full description
Enginatics, R12 only, Upload XML
EAM PM Schedule Upload
EAM Preventive Maintenance Schedule Upload ========================================= Create or update Oracle EAM Preventive Maintenance schedule definitions, including: - PM Schedule header (asset or asset group, activity, schedule name, set name, type, rescheduling point, etc.) - Activity group (for Rule Based schedules: list of activities with interval multiples) - Scheduling rules: Day Interval, Runtime / Meter, and List Date rules - Optional Last Service info (per meter) Row Model ========= Each spreadsheet row can contain PM header values plus any populated child-object columns.…
full description
Enginatics, R12 only, Upload XML
FA Asset Impairments
Source: Asset Impairment Report Short Name: FAXRASIM DB package:
Enginatics, R12 only XML
FA Fixed Assets Book
Assets held in a depreciation book with their cost, depreciation and net book value as at the end of the selected period. Replaces the Oracle standard RXi: Fixed Assets Book report. The rows are extracted by the same routine its RX-only: Fixed Assets Book data program uses, so cost and depreciation figures are identical. The two seeded RXi attribute sets, Default and Book Details, are shipped as the templates of the same names; each puts the asset detail on the report sheet and the RXi group subtotals on a pivot sheet beside it. One row per asset distribution, so an asset split over several…
full description
Enginatics, R12 only XML
FND Attached Documents (Operating Unit Secured)
Attachments of operating unit striped documents: sales orders and lines, purchase orders, lines, shipments and releases, requisitions, AP invoices, AR transactions, projects and delivery details. Each row shows the document the attachment belongs to, its category, title, file name and a clickable download link for file attachments. Short text, long text and URL attachments are shown inline. The report is secured by operating unit: only documents of the operating units accessible to the running responsibility (profile options MO: Security Profile or MO: Operating Unit) are returned, so it can…
full description
Enginatics, R12 only XML
GL Account Analysis (Drilldown)
** This report is used by the GL Financial Statement and Drilldown report, to show Subledger details. ** Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. For drilldown to the transaction screen please ensure the column View Transaction is present in the Displayed Columns View Transaction
Enginatics, R12 only XML
GL Account Analysis (Drilldown) (with inventory and WIP)
** This report is used by the GL Financial Statement and Drilldown report, to show Subledger details. ** Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. This also has inventory and WIP details.
Enginatics, R12 only XML
GL Account Distribution Analysis
Detailed GL transaction report with one line per distribution including all segments and subledger data, with amounts in both transaction currency and ledger currency. The report includes VAT tax codes and rates for AR and AP transactions.
Enginatics, R12 only XML
GL Journals (Drilldown)
** This report is used by the GL Financial Statement and Drilldown report, to show Journal details. ** GL batches and journals report, including amounts and attachments.To enable next level drilldown below columns should be present in Display columns of the custom templates Drill To Subledger Drill To Journal Attachment Drill To Full Journal
Enginatics, R12 only XML
GL Setup Upload
Create and update the General Ledger setup entities that the GL Setup menu maintains, replicating the Calendars (GLXSTCAL), Period Types (GLXSTPTY), Journal Sources (GLXSTSRC), Journal Categories (GLXSTCAT), Encumbrance Types (GLXSTENC), Statistical Units of Measure (GLXSTUOM), Ledger Sets (GLXSTLST), Data Access Sets (GLXSTACC), Journal Reversal Criteria (GLXSTARV) and AutoPost Criteria (GLXSTAPO) forms, plus ledger options. Each row is one of fifteen entity types, chosen in the Row Type column. Only the columns belonging to that entity are read; all other columns are ignored. A template is…
full description
Enginatics, R12 only, Upload XML
GL Summary Account Upload
This upload can be used to import Summary Account Templates.
Enginatics, R12 only, Upload XML
IEX Collection Note Upload
Creates and updates Collection Notes in Oracle Collections (IEX) - the same notes shown in the Collections work area. Each note is attached at a single Note Level: Customer (party), Account, Bill To, or Collections Transaction. The Note column is limited to 2,000 characters. The upload will reject the row if the note exceeds this. The Note Detail column is limited to 4,000 characters. Note details exceeding this will be truncated. Party Level Notes: Pary Name is required Party Number is required only when the Party Name is not unique. Account Level Notes: Party Name and Account Number…
full description
Enginatics, R12 only, Upload XML
IGI Dossier Maintenance Upload
Upload to create and maintain dossier transactions (budget transfers) for Oracle Public Sector Financials International (IGI). Supports header creation with source and destination budget lines using the seeded IGI Dossier Maintenance APIs.
Enginatics, R12 only, Upload XML
INV Cycle count unscheduled items
Imported Oracle standard Cycle count unscheduled items report Source: Cycle count unscheduled items report (XML) Short Name: INVARUIR_XML DB package: INV_INVARUIR_XMLP_PKG
Enginatics, R12 only XML
INV Item Cross Reference Upload
Creates, updates and deletes item cross references - the Cross Reference Types form (Inventory > Setup > Items > Cross-Reference Types), also reached from the Item form via Tools > Cross References. A cross reference is either organization independent (Applicable To All Organizations is set and Org is blank) or specific to one organization (Org is entered). The organization must be one the item is assigned to. Revision and Unit of Measure only apply to the GTIN cross reference type named by the profile option INV: GTIN Cross Reference Type, and Revision additionally requires an…
full description
Enginatics, R12 only, Upload XML
INV Item Subinventory Upload
Create, update and delete item-to-subinventory assignments (plus their optional item-subinventory-locator ties) across accessible inventory organizations. Each row is one (Organization, Item, Subinventory, Locator?) combination. When the Locator column is blank, only the item-subinventory header is processed. When the Locator column is populated, the item-subinventory header (if not already processed in this run) AND the locator tie are processed. When multiple rows share the same Organization/Item/Subinventory triple, the header is processed only on the first row of the triple (siblings…
full description
Enginatics, R12 only, Upload XML
INV Lot Upload
Creates and updates lots as in the Lot Numbers form (Inventory > On-hand, Availability > Lots). A row updates the lot when Organization Code, Item and Lot Number exist, and creates it otherwise. A new lot takes the item defaults for status, grade, origination type and the dates left blank, and copies the parent lot attributes where the item or organization is set up to copy them. A blank Origination Date on a new lot defaults to the current date. Parent Lot can only be entered for a new lot. Expiration Date, Expiration Action Date and Retest Date can be changed only for items under shelf…
full description
Enginatics, R12 only, Upload XML