Transaction Open Interface

-

 






Comments

Post a Comment

Popular posts from this blog

Oracle Lock table

-
 SELECT B.Owner, B.Object_Name, A.Oracle_Username, A.OS_User_Name   FROM V$Locked_Object A, All_Objects B WHERE A.Object_ID = B.Object_ID select * from V$Locked_Object select    c.owner,    c.object_name,    c.object_type,    b.sid,    b.serial#,    b.status,    b.osuser,    b.machine from    v$locked_object a ,    v$session b,    dba_objects c where    b.sid = a.session_id and    a.object_id = c.object_id;
Read more

Query to find onhand quantity Oracle Apps

-
  SELECT   ON_HAND.SUBINVENTORY_CODE,ITEM.SEGMENT1 ITEM_CODE, ITEM.DESCRIPTION ITEM_DESCRIPTION,          SUM (ON_HAND.ON_HAND) ON_HAND     FROM MTL_SYSTEM_ITEMS_B ITEM, MTL_ONHAND_TOTAL_MWB_V ON_HAND    WHERE ITEM.ORGANIZATION_ID = 3762  --ORG   AND ITEM.INVENTORY_ITEM_ID = ON_HAND.INVENTORY_ITEM_ID      AND ON_HAND.SUBINVENTORY_CODE IN ('PI6.FG','PI7.FG')  --SUB INVENTORY    --  AND ITEM.SEGMENT1 = '886631' ---ITEM GROUP BY ON_HAND.SUBINVENTORY_CODE,ITEM.SEGMENT1, ITEM.DESCRIPTION ORDER BY ON_HAND.SUBINVENTORY_CODE;             ------------second    SELECT   ON_HAND.ORGANIZATION_CODE,ON_HAND.SUBINVENTORY_CODE, ITEM.DESCRIPTION ITEM_DESCRIPTION,ITEM.SEGMENT1 ITEM_CODE,          SUM (ON_HAND.ON_HAND) ON_HAND     FROM MTL_SYSTEM_ITEMS_B ITEM, MTL_ONHAND_TOTAL_MWB_V ON_HAND    WHERE ITEM...
Read more

create tablespace with multiple datafiles

-
CREATE TABLESPACE TBS_DATA     DATAFILE          '/oradata/PCDB/PINSV/tbs_data_001.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 25G,          '/oradata/PCDB/PINSV/tbs_data_002.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 25G,             '/oradata/PCDB/PINSV/tbs_data_003.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 25G; CREATE TABLESPACE TBS_INDEX      DATAFILE          '/oradata/PCDB/PINSV/tbs_index_001.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 25G,          '/oradata/PCDB/PINSV/tbs_index_002.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 25G,             '/oradata/PCDB/PINSV/tbs_index_003.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 25G; --windows---- CREATE TABLESPACE TBS_DATA     DATAFILE          'D:\ORACLE\ORA11G\APP\ADMINISTRATOR\ORADATA\PRAN\tbs_data_001.dbf' SI...
Read more