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)
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...
-
OPM Financials Tables: TABLE NAME DESCRIPTION CM_ACER_MSG The Actual Cost Process Error Message Table will provide the user a...
-
FND API to Delete, Add and Update value set values in Oracle Applications 01. Need to create a table like : CREATE TABLE...
-
MMT -> GMF -> XLA GL ---------------------------------------- The Pre-Processor should pick up all Transactions (related to a proce...
No comments:
Post a Comment