Form: INVIRSIQ Use the Subinventory Quantities Report to show inventory item quantities by subinventory. Report Submission Use the On-hand Quantity Reports or Submit Requests window and enter Subinventory quantities report in the Name field to submit the report. Report Parameters Item Range Choose one of the following options: Full listing : Report all subinventories. Partial […]
Following APIs used to Launch Workflow declarecursor c1 isselect incident_no,CREATED_BY_USER_ID from org_sr_summary awhere trunc(create_dt) = trunc(sysdate) and incident_no = ‘1203950’and not exists ( select 1 from org_incident_history b where a.incident_no = b.incident_id); v_return_status varchar2(150);v_msg_count number;v_msg_data varchar2(150);v_itemkey varchar2(150);v_initiator_user_id number;v_count number := 0;v_null number:=0; begin For i in c1Loop beginselect workflow_process_id into v_nullfrom cs_incidents_all_bwhere incident_number = TO_CHAR(i.incident_no)and […]
These are the tips that needs to be followed to performance tune your SQL scripts; · Never do a calculation on an indexed column (e.g., WHERE salary*5 > :myvalue) · Whenever possible, use the UNION statement instead of OR conditions · Avoid the use of NOT IN or HAVING in the WHERE clause. Instead, use […]
Item Replenishment Overview: One can use the replenishment counting system to plan your inventories. This may be ideal for replenishing free stock items that you store on the production floor, or office supplies kept in departmental cabinets. Oracle Inventory provides an open interface for loading replenishment count data collected from some other system. In some […]
CREATE OR REPLACE PACKAGE A07_REPLENISHMENT_INT AUTHID CURRENT_USER AS /****************************************************************************** NAME: A07_REPLENISH_INTERFACE PURPOSE: Item Replenishment Interface. PARAMETERS: INPUT: OUTPUT: RETURNED VALUE: CALLED BY: CALLS: EXAMPLE USE: NUMBER := A07_REPLENISH_INTERFACE.MyFuncName(Number); A07_REPLENISH_INTERFACE.MyProcName(Number, Varchar2); ASSUMPTIONS:+ LIMITATIONS: ALGORITHM: NOTES: ******************************************************************************/ — All the Global Variables to […]
Recent Comments