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)
RCV API
DECLARE ln_user_id NUMBER; ln_po_header_id NUMBER := 3319024; --1713998; ln_vendor_id NUMBER; lv_segment1 VARCHAR2(20)...
-
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...
-
/* opm_undo_create_accounting_by_date_range_and_LE_R12.sql +=======================================================================+ * ...
No comments:
Post a Comment