You can using the following package to create the IB (Install base) for the sales Order It has missed. Normally, we enable the Install base option in the “Master Item” form for the Items for which we want to track. If we enable this option, then when we create the sales order with the Item […]
The following query can be used to display the number in the words.select ‘Your Number’, (to_char(to_date(‘Your Number’,’j’), ‘jsp’)) from dual;Example:-select 211, (to_char(to_date(211,’j’), ‘jsp’)) from dual;
The following query can be used to get the duplicate records from table.SELECT * FROM ‘Your table name’ WHERE ROWID NOT IN (SELECT MAX(ROWID) FROM ‘Your Table Name’ GROUP BY ‘Your duplicate values field name’);Example:-SELECT * FROM emp WHERE ROWID NOT IN (SELECT MAX(ROWID) FROM emp GROUP BY ename);To eliminate/delete the duplicate rows from the table, […]
You can get all the Canceled Requisitions in the PO Module using the following Query. SELECTprha.requisition_header_id “requisition_header_id”,prha.segment1 “Requisition Number”,prha.preparer_id “preparer_id”,TRUNC(prha.creation_date) “creation_date”,prha.description “description”,prha.note_to_authorizer “note_to_authorizer”FROMpo_requisition_headers_all prha,po_action_history pahWHERE action_code=’CANCEL’AND pah.object_type_code=’REQUISITION’AND pah.object_id=prha.requisition_header_id
Requisitions (PO Module) would be 2 types. 1) Purchasing Requisitions (Handled by the PO Module) 2) Internal Requisitions (Handled by the OM Module). We create the Purchase Orders for the Purchasing Requisitions and Internal Sales Orders will be created for the Internal Requisitions. Note:- We create Internal Sales Order to transfer the material between the […]
Recent Comments