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
Subscribe to:
Post Comments (Atom)
OM Order Info of respective ORDER_NUMBER in R12
SELECT ood.organization_code org_code, ood.organization_name org_name, wdd.DELIVERY_DETAIL_ID ...
-
FND API to Delete, Add and Update value set values in Oracle Applications 01. Need to create a table like : CREATE TABLE...
-
OPM Financials Tables: TABLE NAME DESCRIPTION CM_ACER_MSG The Actual Cost Process Error Message Table will provide the user a...
-
SELECT * FROM hz_cust_accounts WHERE ACCOUNT_NUMBER = 'R08'; -- CUST_ACCOUNT_ID =51401 , PARTY_ID= 235048 SELECT * FRO...
No comments:
Post a Comment