Oracle EBs Apps Blog of Mahfuz, OPM and OBIEE Consultant

Monday 7 December 2020

Transaction Summary:

 Transaction Summary:

select transaction_type_name, count(1) tm from mtl_material_transactions a, mtl_transaction_types tp
  where a.transaction_type_id=tp.transaction_type_id
  group by transaction_type_name
  ORDER  by transaction_type_name
 

No comments:

Post a Comment

Internal location is Already assigned to another Ship-to Address

      SELECT *   FROM hz_cust_accounts  WHERE ACCOUNT_NUMBER = 'R08'; -- CUST_ACCOUNT_ID =51401 , PARTY_ID= 235048    SELECT *   FRO...